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.
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...
I'm trying to retrieve a value from a stored procedure but the SP doesn't return the correct value.
asp.net VB code:
Sub ckselections()
Dim sqlConn As New SqlConnection
Dim sqlComm As New SqlCommand
'Create a SqlParameter object to hold the output parameter value...
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...
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?
What reasons are there for a table not being dropped? I tried the following 3 ways and none of them work. If I run the SP outside the app, it works. The SP is being called and run because I created a junk table within the SP to see if it were being entered. None of these tables are being used in...
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...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.