Lost SQLDataAdapter on page design 1

[randysmid]

Hi ALL,
For some reason, I've lost my SQLDataAdapter, SQLConnection, and Dataset icons that appear at the bottom of the design page. Of course, I need these to make property changes. Anyway, I closed VS and reopened it, but it didn't make any difference. The version I am using is: Microsoft Visual Basic .NET 69461-270-0000007-18910

Has anyone seen this before? Any thoughts, ideas?

TIA, Randy

 

[RTomes]

Don't trust what you see graphically. Right click on the page and view the code to make sure it is not still there.

Keep the data componants in a seperate componant class seperate from the web pages.
You can access a componant named MyData in your webpage by
Dim MD as new MyData
md.Connection....
md.cmdGetAll.parameters(0).value=sID
and so on ...


Another hassle to watch for using the designer:
If you create a bunch of dataadapters and command objects using the designer and then one dat delete your connnection object to replace it with a new one, you will end up having to re-asign to all of the dataadapters and command objects the new connection object.

Keep zipped backups daily of your code in case strange stuff like this happens again.

 

[randysmid]

Hi,
Thank you for both valuable tips (the other was the 23 html errors)!! A star for taking the time to respond so quickly, and with such insight.
Randy