Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 433
  • Last Modified:

How to split vb.net dataset

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
dave_sky
Asked:
dave_sky
  • 6
  • 6
1 Solution
 
Arthur_WoodCommented:
What do you mean by "too large"?  Too many rows, or too many columns?

AW
0
 
dave_skyAuthor Commented:
93 tables - several tables have a large number of rows.
0
 
Arthur_WoodCommented:
You have a dataset composed of 93 DataTables?

AW
0
Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

 
dave_skyAuthor Commented:
Yes
0
 
Arthur_WoodCommented:
What is the nature of your application.  

AW
0
 
dave_skyAuthor Commented:
Construction quotes, workorders, material data.
0
 
Arthur_WoodCommented:
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
 
dave_skyAuthor Commented:
Yes that should work, the application is almost finished.

Can I use the same sql server 2005 database for more than one dataset?
0
 
dave_skyAuthor Commented:
Actually, If I only move one area that would free up the the main dataset so it can be used.
0
 
Arthur_WoodCommented:
>>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
 
dave_skyAuthor Commented:
Thanks, that really helped!
0
 
Arthur_WoodCommented:
Glad to be of assistance.

Happy Programming!!! :-)
AW
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

  • 6
  • 6
Tackle projects and never again get stuck behind a technical roadblock.
Join Now