To DataSet or Not to DataSet 
Author Message
 To DataSet or Not to DataSet

Hello,

I am an Access/VBA/VB6 developer learning VB.NET.

I am working on a database application that I am building in VB.NET
connecting to a Jet 4.0 database.  I have a single dataset that I am working
with and I have all of my OleDbDataAdapters connected to it.

Is this a good practice or should I have a separate dataset for each
OleDbDataAdapter or some combination of the above?  What's a good rule of
thumb?

Any insight would be greatly appreciated.

Thanks,
Scott



Thu, 22 Sep 2005 12:00:27 GMT  
 To DataSet or Not to DataSet
Hi Scott,

I think it makes sense to hold datatables that are related to each other in
some way (possibly just in purpose, not literally) in a dataset eg:
everything to do with some aspect of the data.

HTH

--
Greg Low
MSDE Manager SQL Tools
www.whitebearconsulting.com



Quote:
> Hello,

> I am an Access/VBA/VB6 developer learning VB.NET.

> I am working on a database application that I am building in VB.NET
> connecting to a Jet 4.0 database.  I have a single dataset that I am
working
> with and I have all of my OleDbDataAdapters connected to it.

> Is this a good practice or should I have a separate dataset for each
> OleDbDataAdapter or some combination of the above?  What's a good rule of
> thumb?

> Any insight would be greatly appreciated.

> Thanks,
> Scott



Fri, 23 Sep 2005 18:05:26 GMT  
 To DataSet or Not to DataSet
Greg,

Thanks for the insight!

Scott



Fri, 23 Sep 2005 21:54:15 GMT  
 
 [ 3 post ] 

 Relevant Pages 

1. Cannot DataSet.ReadXml a file written with DataSet.WriteXml

2. How to generate dataset class from dataset xsd file

3. dataset : cannot fil the dataset because the field is empty

4. dataset problems - cant update sql after editing dataset

5. Insert dataset into dataset

6. dataset not set to an instance of an object when using Server.transfer

7. dataset not set to instance of an object

8. Database relationships not represented in DataSet...

9. New Column not appear in Dataset.

10. Bind DataTable to Datagrid (Not from a DataSet)

11. Binding a datetimepicker control to a date time dataset field does not work

12. Not getting error message back from dataset delete

 

 
Powered by phpBB® Forum Software