Thread: one or more dataset in one application

If you're creating DataSets in forms then yes, creating multiple DataSets in multiple forms is appropriate. It really depends on the specifics of each form as to whether that form requires its own DataSet or it should get data from another form.

As you get more experienced you'll find that it's preferred not to create DataSets in forms at all. The most professional way to build software is with a dedicated data access layer. That data access layer can be constructed in various ways but it handles all the database access and then other components in your application request data from it.

hello where could i find a good reference?

Originally Posted by ghassan_aljabiri

hello where could i find a good reference?

For what exactly?

Originally Posted by jmcilhinney

As you get more experienced you'll find that it's preferred not to create DataSets in forms at all.

Can you expand on this a little? I'd have advocated that a strongly typed DataSet, and all its associated TableAdapter/DataTable/DataRelation paraphernalia IS a good abstracted data layer for an application.

By contrast, if by "creating datasets in forms " you mean that button click handler code literally contains: Dim ds as New DataSet: ds.Tables.Add(New DataTable): ds.Tables(0).Columns.Add(...)
then yes, I'd agree that it's "bad"

I asked for a reference on how to construct the dedicated data access layer

but i want to ask cjard the same question , is it prefered to use one global dataset or use many datasets (one per form)

Originally Posted by cjard

Can you expand on this a little? I'd have advocated that a strongly typed DataSet, and all its associated TableAdapter/DataTable/DataRelation paraphernalia IS a good abstracted data layer for an application.

By contrast, if by "creating datasets in forms " you mean that button click handler code literally contains: Dim ds as New DataSet: ds.Tables.Add(New DataTable): ds.Tables(0).Columns.Add(...)
then yes, I'd agree that it's "bad"

Dragging DataSets and TableAdapters onto forms is simple but violates separation of concerns. Using typed DataSets, DataTables and DataRows as your entity layer and TableAdapters in your DAL is fine, but data access in forms is obviously not when you start talking about serious applications. I know that you know this and were just asking for clarification of my position.

How to create the DAL?

Originally Posted by ghassan_aljabiri

How to create the DAL?

There's no one answer to that. You should do some reading a n-tier design and DALs specifically.