Search results for query: *

I turned off the enable caching for the SqlDataSource and it works. It may not be the most effection method for bandwidth. If there's a better way, feel free to tell me.

I found the enableviewstate property for the gridview and it is set to false.

Are you calling the SP a second time, or is it wrapped in an if(!page.ispostback) block? No What control are you displaying the data in? datagrid Did you turn off Viewstate on that control? This may be my problem, I'm reading about viewstate as I wait for a reply. Currently, I don't know how...

I call formA which displays a table. FormA calls another formB, which allows me to make selections that calls 2 SPs and alters the table displayed in formA. When in formB, focus is no longer on formA. The changes in the tables are made correctly, but the original table still displays when I call...

...sqlConn.Close() End Sub Stored Procedure: ALTER PROCEDURE dbo.ckselections ( @MyID varchar(55), @nSelections bigint OUTPUT ) AS /* SET NOCOUNT ON */ declare @tmpselcond varchar(55) = 'tmpselcond' + ltrim(rtrim(@MyID)) set rowcount 0 exec('select * from ' + @tmpselcond + ' where...

I should add that all the tables I'm having trouble dropping are programmatically made. Would them being programmatically created have anything to do with this?

1. IE was updated from 7/8 to 9 - is what happened. I downloaded Google Chrome browser and made it my default and it now works. Eventually, I'll have to figure this out as that's the direction MS is going. 2. If the JS is auto-generated via webforms, then you might need to look for an update...

When you run the DROP statement (#1), what error message do you get back? -----None. it runs as if there were no errors. The only reason I know it didn't drop the table is because I selected it into a new table when it should have been dropped and it did create the new table. Since the stored...

I didn't write the javascript. I don't know javascript. So you're saying my vb.net caused a javascript error?

Other tables drop earlier in the process. I just tried changing the code to delete the data and not drop the tables and they won't delete. If I run a sample test SP against the very same tables without running the entire app, it works. There are no filters, triggers or indexes established with...

I installed the IE developer tool bar thinking it would overwrite the existing developer tool, but it didn't. I'm still getting those errors. Do you know how to shut it off?

...the SP to see if it were being entered. None of these tables are being used in an ASP.net form. 1. DROP Table Mytbl1 2. IF EXISTS (SELECT * from sysobjects WHERE id = object_id(N'[yeldata].[dbo].[Mytbl]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1) DROP Table...

I may have asked the wrong question in a previous post. I call a stored procedure twice. The first time it works. The second time, it seems that it's not even entered. What should I look for? Below is the process: 1. FormA = made selections calls stored procedureA to create tables 2. stored...

How do I write this line when the table name is dynamic? com.CommandText = "Select * From @tmpselcond";

I upgraded my IE to version 9 and now when I run asp.net apps that were once working get javascript errors. I didn't write these scripts, it's the behind-the-screen code. I can hit ignore and continue, but it's annoying. I tried to look to uninstall this IE 9, but it seems that's no longer an...

FormA has a gridview and a SQLDataSource control which refers to a dynamic table which was created in the screen prior to FormA. On FormA there is a button that leads to FormB, which allows restrictions to the table displayed in FormA. Currently I drop the table and try to recreate it, then...

That's exactly what I want. Thanks!

How can I reuse code without using code snippets or cutting and pasting. I was hoping that I could use some sort of class, but it seems that classes are meant for the entire page or a portion of the page. I don't want to use snippets because if a change is needed, I'll need to go to each page...

It turned out that I had 7 ZIPs and had qualifiers on the last ZIP. I wasn't careful in cleaning the data.

The following dynamic bulk insert works but gives an error on the last record. I checked the import and the data was in the file. What would cause this error? ERROR MSG: Bulk load data conversion error (truncation) for row 7, column 1 (dircode). [Note: Dircode is the name of the column of the...