Newbie with VB.NET & Ado

  • Thread starter Thread starter Newbie!
  • Start date Start date
N

Newbie!

Morning Group,

Can someone possible answer a simple question for me?

Should I use the Database Connection, DataAdapter, and Dataset Wizard or
should I right my own code and not bother with the Wizards?

Anybody know any good Links for me to read up on?

I have a Simpl(ish) DB - Access XP with around 20 Tables and some
Relationships

Ta
Regards
Si
 
Hi Newbie,

Newbie! said:
Morning Group,

Can someone possible answer a simple question for me?

Should I use the Database Connection, DataAdapter, and Dataset Wizard or
should I right my own code and not bother with the Wizards?
Click to expand...

Sure. They are probably not optimal but they do a fairly good work.
Anybody know any good Links for me to read up on?
Click to expand...

A good starting point would be .net help files - look for ado.net.
 
The code written is a bit heavy (in lines of code), but runs as fast as code
you will write, if you use DataSets. The drag and drop is easy to implement
and maintain, overall.

Personally, I like multi-tiered apps, so I do not use the wizards ... at
all. They will speed up your development at first, so do not be afraid to
use them.

I like the Data Access Application Block that you can download from
http://msdn.microsoft.com, as it makes an easy to implement data access
layer once you understand it. For questions, there is a forum on
www.asp.net.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

**********************************************************************
Think Outside the Box!
**********************************************************************
 
Great Stuff Thanks for you replys,

Im just a little confuse with the Wizards:

I Have my main form with 5 Datagrids on - all of which come from a seperate
table on my database, do i need 1 Database Connection then a Seperate Data
Adapter and Data Set for each Table?

Thanks for your help so far

Ta
Si
 
You can use a single connection for all of these DataGrids, but you can only
populate one at a time (with the current version).
You'll want to create a separate DataAdapter for each DataGrid that need to
be updatable. In a Windows application, you can't bind to a DataReader (even
for populating lists and grids), but you can in an ASP application. I would
probably try to create a single command with all of the SELECT statements
needed to populate the RO grids and fill them from the multiple resultsets
that the DataAdapter Fill method returns.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
MVP, hRD
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
 
Back
Top