Programming Help

Web Development



What's Here?

  • Members: 117,162
  • Replies: 430,685
  • Topics: 66,410
  • Snippets: 2,388
  • Tutorials: 629
  • Total Online: 2,424
  • Members: 87
  • Guests: 2,337

Who's Online?

Welcome to Dream.In.Code
Click Here
Getting VB.NET Help is Easy!

Join 117,162 VB.NET Programmers for FREE! Ask your question and get quick answers from experts. There are 2,424 online right now! We've got more than 500 tutorials and 2,000 snippets. Join and find out why Dream.In.Code is the #1 programming help community on the internet! Registration is fast and FREE... Join Now!



DataSet Issues

 
 Reply to this topicStart new topic

DataSet Issues
Tomaso48
post 2 Jul, 2008 - 09:36 AM
Post #1


New D.I.C Head

*
Joined: 1 Jun, 2008
Posts: 10
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
User is offlineProfile CardPM

Go to the top of the page


jayman9
post 2 Jul, 2008 - 06:54 PM
Post #2


Student of Life

Group Icon
Joined: 26 Dec, 2005
Posts: 6,434



Thanked 27 times

Dream Kudos: 500

Expert In: C#, VB.NET, Java

My Contributions
These questions are difficult to answer without seeing your code. Post your code using code.gif tags.
User is offlineProfile CardPM

Go to the top of the page

Tomaso48
post 3 Jul, 2008 - 05:32 AM
Post #3


New D.I.C Head

*
Joined: 1 Jun, 2008
Posts: 10
QUOTE(jayman9 @ 2 Jul, 2008 - 06:54 PM) *

These questions are difficult to answer without seeing your code. Post your code using code.gif 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
User is offlineProfile CardPM

Go to the top of the page

Tomaso48
post 5 Jul, 2008 - 08:18 PM
Post #4


New D.I.C Head

*
Joined: 1 Jun, 2008
Posts: 10
QUOTE(Tomaso48 @ 3 Jul, 2008 - 05:32 AM) *

QUOTE(jayman9 @ 2 Jul, 2008 - 06:54 PM) *

These questions are difficult to answer without seeing your code. Post your code using code.gif 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,
User is offlineProfile CardPM

Go to the top of the page

Tomaso48
post 7 Jul, 2008 - 11:42 AM
Post #5


New D.I.C Head

*
Joined: 1 Jun, 2008
Posts: 10
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,
User is offlineProfile CardPM

Go to the top of the page

Fast ReplyReply to this topicStart new topic
Time is now: 10/6/08 11:06AM
Invision Power Board v2.1.7 © 2008  IPS, Inc.
Licensed to: MediaGroup1

Live VB.NET Help!

VB.NET Tutorials

Reference Sheets

VB.NET Snippets

Bye Bye Ads

Free DIC T-Shirt

T-Shirt Example

Related Sites

Monthly Drawing

Thumb Drive

Partners

Top Contributors

Top 10 Kudos This Month