datasets disappear from designer
-
We have had multiple occurances of datasets disappering from the designer. We cannot be specific about the circumstances since we simply do not know when this will occur or under what conditions. The .xsd and associated .vb files are still located in the source directory. The .vbproj file has references to both but is missing the following tagged lines (as an example). Restoring the tagged lines allows the code to compile correctly, but the data sets still do not show up in the designer. The implication is that we can't select the dataset and look at or modify the schema. Here is a snippet from the .vbproj with the missing lines tagged by >>> >> DependentUpon = "LabNfonts.xsd" SubType = "code" >>> BuildAction = "Compile" >>> DesignTime = "True" >>> AutoGen = "True" /> >> Generator = "MSDataSetGenerator" >>> LastGenOutput = "LabNfonts.xsd" /> We are using a single data adapter and reconfiguring it to generate each data set. At execution time, the dataAdapter select, insert, delete, and update comman text is dynamically altered. The only other way we have found to get the datasets back is to completely delete the dataset and all references to it in the MS generated code, then reconfigure the dataAdaper and regenerate the the dataset. This is a huge waste of time, and I believe there must be s simple solution for prevention and cure of the problem. Any insight would be greatly appreciated. Thanks.