[Tomaso48]

I am using a dataset in an application I am building and when I configure the tableadapter for a table I am selecting the option to generate the Insert, Delete, and Update queries. However, when I am finished the Update query is blank on the properties.

The other issue I am having is that I added a couple of new tables to the dataset and then rebuilt the dataset. Now, when executing my app, the two new tables do not appear in the lists.

Any thoughts on resolving these frustrating issues?

Thanks,
Tomas

[Jayman]

These questions are difficult to answer without seeing your code. Post your code using tags.

[Tomaso48]

jayman9, on 2 Jul, 2008 - 06:54 PM, said:

These questions are difficult to answer without seeing your code. Post your code using tags.

I understand. Unfortunately, the issue isn't so much code, rather the VS interface and developement environment. When I figure it out I will post the fix here.

Thanks,
Tomas

[Tomaso48]

Tomaso48, on 3 Jul, 2008 - 05:32 AM, said:

jayman9, on 2 Jul, 2008 - 06:54 PM, said:

These questions are difficult to answer without seeing your code. Post your code using tags.

I understand. Unfortunately, the issue isn't so much code, rather the VS interface and developement environment. When I figure it out I will post the fix here.

Thanks,
Tomas

Well, here's an update. I found that the problem with the Update query not being generated was actually a SQL Server setup issue. Although each of the tables had an auto-incrememnting identity field, these identity fields were not set as the primary key. Once each table had the primary key set, the Update query was automatically generated when brought into the VB.Net application. One down, one to go.

Thanks,

[Tomaso48]

Here is the update on the tables not fully being included in the dataset. When I looked at the designer file for the dataset, the two tables in question were not included in the definition section with the other tables. It turns out that on the properties for the .xsd file, the Custom Tool = MSDataSetGenerator entry was missing. Once it was added back and rebuilt the tables were included as they should be.

Thanks,