Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
ADO.NET For discussion about ADO.NET.  Topics such as question regarding the System.Data namespace are appropriate.  Questions specific to a particular application should be posted in a forum specific to the application .
Welcome to the p2p.wrox.com Forums.

You are currently viewing the ADO.NET section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old May 3rd, 2004, 04:27 AM
Friend of Wrox
Points: 3,558, Level: 25
Points: 3,558, Level: 25 Points: 3,558, Level: 25 Points: 3,558, Level: 25
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: California, USA
Posts: 996
Thanks: 2
Thanked 11 Times in 11 Posts
Send a message via Yahoo to melvik
Default DataSet idea

Dear all:
Im using DataSet for my C# Windows App. My app has just a DataSet including more than 20 different table. But each form use just 1 or 2 tables of that (Max 5).
sence
Now I wanna ask for ur idea, since there is no form witch use all these 20 table, should I have separate DataSet?! or it doesnt sense?!
FOR example: my form1 is useing [u]Table1, Table2, Table3</u>
& form2 is useing [u]Table4, Table5</u>.
Should I have [u]DataSet1 for form1</u> & [u]DataSet1 for form2</u>?!

Tnx in Advance.

Always:),
Hovik Melkomian.
__________________
Always,
Hovik Melkomian.
 
Old May 4th, 2004, 07:55 AM
planoie's Avatar
Friend of Wrox
Points: 16,481, Level: 55
Points: 16,481, Level: 55 Points: 16,481, Level: 55 Points: 16,481, Level: 55
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Aug 2003
Location: Clifton Park, New York, USA.
Posts: 5,407
Thanks: 0
Thanked 16 Times in 16 Posts
Default

It would certainly make sense that if all the tables do not HAVE to live together, then they shouldn't. Why load 15 tables in a dataset if you don't use them? However, concidering that you are writing a windows application, you might not need to worry about constant reloading of a dataset from a file (assuming this is how you are doing it). Some factors to consider are: how are you loading this dataset (from a file, SQL)? How often are you REloading the dataset? If you don't reload the dataset during the lifetime of the application you might need to worry about loading the whole thing. In fact, it might be better for you application to load the whole thing first on program load and have the data available immediately when you need it.

Peter
-------------------------
Work smarter, not harder
 
Old May 4th, 2004, 11:21 PM
Friend of Wrox
Points: 3,558, Level: 25
Points: 3,558, Level: 25 Points: 3,558, Level: 25 Points: 3,558, Level: 25
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: California, USA
Posts: 996
Thanks: 2
Thanked 11 Times in 11 Posts
Send a message via Yahoo to melvik
Default

Dear Peter tnx for ur responce, but I would like to add some info to my scenario:
As I said my DataSet has more than 20 table but I dont use them in my all forms. As I said I just fill & update each table witch depend to form.
Yes, tables might update every min. specially 3-5 main tables, since App has about 30-50 users, & Im using MS-SQL 2000 as my DB.

Always:),
Hovik Melkomian.
 
Old May 5th, 2004, 12:06 AM
Friend of Wrox
Points: 3,558, Level: 25
Points: 3,558, Level: 25 Points: 3,558, Level: 25 Points: 3,558, Level: 25
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: California, USA
Posts: 996
Thanks: 2
Thanked 11 Times in 11 Posts
Send a message via Yahoo to melvik
Default

Dear Peter:
So u suggest to make DataSet for each form in App. Isnt it?!

Always:),
Hovik Melkomian.




Similar Threads
Thread Thread Starter Forum Replies Last Post
no idea ! help lscjtw XSLT 4 July 23rd, 2007 09:55 AM
Brilliant idea, no idea how! imaginitive-idea-guy Ajax 9 January 14th, 2007 05:32 AM
Idea about project. shivanshub C# 0 August 20th, 2006 06:54 AM
MSHFlexGrid Idea Rudner Pro VB Databases 1 November 20th, 2004 06:12 AM
idea of report & DataSet melvik Crystal Reports 1 May 18th, 2004 02:10 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.