Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. whateveragain

    2nd call to form doesn't work

    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.
  2. whateveragain

    2nd call to form doesn't work

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

    2nd call to form doesn't work

    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...
  4. whateveragain

    2nd call to form doesn't work

    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...
  5. whateveragain

    Retrieving Data from a Stored Procedure

    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...
  6. whateveragain

    Tables will not drop

    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?
  7. whateveragain

    Microsoft JScript runtime error

    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...
  8. whateveragain

    Tables will not drop

    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...
  9. whateveragain

    Microsoft JScript runtime error

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

    Tables will not drop

    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...
  11. whateveragain

    Microsoft JScript runtime error

    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?
  12. whateveragain

    Tables will not drop

    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...
  13. whateveragain

    Stored procedure doesn't work 2nd time around

    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...
  14. whateveragain

    Which Data source to use?

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

    Microsoft JScript runtime error

    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...
  16. whateveragain

    Which Data source to use?

    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...
  17. whateveragain

    How can I resuse code

    That's exactly what I want. Thanks!
  18. whateveragain

    How can I resuse code

    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...
  19. whateveragain

    Bulk load data conversion error (truncation) for row 7

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

    Bulk load data conversion error (truncation) for row 7

    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...

Part and Inventory Search

Back
Top