Solved

How to split vb.net dataset

Posted on 2013-05-27
12
394 Views
Last Modified: 2013-05-28
Software vb.net & sql server 2005.

How do I go about splitting a large dataset into 2 datasets using one sqlserver database.

The existing dataset is too large and it is difficult to add columns to tables.

Thanks!
0
Comment
Question by:dave_sky
  • 6
  • 6
12 Comments
 
LVL 44

Expert Comment

by:Arthur_Wood
ID: 39200974
What do you mean by "too large"?  Too many rows, or too many columns?

AW
0
 

Author Comment

by:dave_sky
ID: 39201687
93 tables - several tables have a large number of rows.
0
 
LVL 44

Expert Comment

by:Arthur_Wood
ID: 39201700
You have a dataset composed of 93 DataTables?

AW
0
 

Author Comment

by:dave_sky
ID: 39201802
Yes
0
 
LVL 44

Expert Comment

by:Arthur_Wood
ID: 39201811
What is the nature of your application.  

AW
0
 

Author Comment

by:dave_sky
ID: 39201893
Construction quotes, workorders, material data.
0
3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

 
LVL 44

Accepted Solution

by:
Arthur_Wood earned 500 total points
ID: 39201905
Rather than creating a single, all-encompassing Dataset, how about creating more targetted datasets - say per form, or per application area.  Would something along those lines fit?

AW
0
 

Author Comment

by:dave_sky
ID: 39201958
Yes that should work, the application is almost finished.

Can I use the same sql server 2005 database for more than one dataset?
0
 

Author Comment

by:dave_sky
ID: 39201983
Actually, If I only move one area that would free up the the main dataset so it can be used.
0
 
LVL 44

Expert Comment

by:Arthur_Wood
ID: 39202025
>>Can I use the same sql server 2005 database for more than one dataset? <<  Yes, what gave you the idea that you couldn't?

A Dataset is composed to DataTables.  You can have as many Datasets as your application design requires.  There is nothing that requires a single dataset to describe an entire database.  A Dataset can be thought of as an "in-memory mini-database"  That does not mean that the Dataset is an in-memory version of the entire database.

AW
0
 

Author Closing Comment

by:dave_sky
ID: 39202093
Thanks, that really helped!
0
 
LVL 44

Expert Comment

by:Arthur_Wood
ID: 39202193
Glad to be of assistance.

Happy Programming!!! :-)
AW
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Need help parsing JSON in my VB.Net application 4 42
Unable to upgrade to .Net 4.6.2 on Server 2012r2 2 42
Error in page 3 45
Connection String 16 43
A basic question.. “What is the Garbage Collector?” The usual answer given back: “Garbage collector is a background thread run by the CLR for freeing up the memory space used by the objects which are no longer used by the program.” I wondered …
Welcome my friends to the second instalment and follow-up to our Minify and Concatenate Your Scripts and Stylesheets (http://www.experts-exchange.com/Programming/Languages/.NET/ASP.NET/A_4334-Minify-and-Concatenate-Your-Scripts-and-Stylesheets.html)…
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, just open a new email message. In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
Hi friends,  in this video  I'll show you how new windows 10 user can learn the using of windows 10. Thank you.

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now