?
Solved

How to split vb.net dataset

Posted on 2013-05-27
12
Medium Priority
?
416 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

 

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
 
LVL 44

Accepted Solution

by:
Arthur_Wood earned 2000 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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

IP addresses can be stored in a database in any of several ways.  These ways may vary based on the volume of the data.  I was dealing with quite a large amount of data for user authentication purpose, and needed a way to minimize the storage.   …
The object model of .Net can be overwhelming at times – so overwhelming that quite trivial tasks often take hours of research. In this case, the task at hand was to populate the datagrid from SQL Server database in Visual Studio 2008 Windows applica…
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…
How to fix incompatible JVM issue while installing Eclipse While installing Eclipse in windows, got one error like above and unable to proceed with the installation. This video describes how to successfully install Eclipse. How to solve incompa…
Suggested Courses

800 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