Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > .NET > Other .NET > ADO.NET
Password Reminder
Register
Register | FAQ | Members List | Calendar | 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 tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developersí questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Display Modes
  #1 (permalink)  
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 Send a message via Skype™ 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.
Reply With Quote
  #2 (permalink)  
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,409
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
Reply With Quote
  #3 (permalink)  
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 Send a message via Skype™ 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.
Reply With Quote
  #4 (permalink)  
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 Send a message via Skype™ to melvik
Default

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

Always:),
Hovik Melkomian.
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

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 04:32 AM
Idea about project. shivanshub C# 0 August 20th, 2006 06:54 AM
MSHFlexGrid Idea Rudner Pro VB Databases 1 November 20th, 2004 05:12 AM
idea of report & DataSet melvik Crystal Reports 1 May 18th, 2004 02:10 AM



All times are GMT -4. The time now is 04:26 AM.


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.