Home All Groups Group Topic Archive Search About

Refresh my memory on datatables, datasets etc.

Author
9 Mar 2006 7:54 PM
cj
I've used datatables and datasets before.  Datasets being able to hold
more than one table and datatables being only one table.  My mind keeps
coming up with recordsets.  I can't remember how they fit into the picture.

I'm going to be reading some records from a table in a sql db.

Author
9 Mar 2006 8:43 PM
Kerry Moorman
cj,

A recordset is ADO classic terminology.

In ADO.Net you need to be able to work with dataadapters, datasets,
datatables, datarows, etc. But not recordsets.

Kerry Moorman


Show quoteHide quote
"cj" wrote:

> I've used datatables and datasets before.  Datasets being able to hold
> more than one table and datatables being only one table.  My mind keeps
> coming up with recordsets.  I can't remember how they fit into the picture.
>
> I'm going to be reading some records from a table in a sql db.
>
Author
9 Mar 2006 9:02 PM
cj
Thanks, I suspected my mind might be regressing.


Kerry Moorman wrote:
Show quoteHide quote
> cj,
>
> A recordset is ADO classic terminology.
>
> In ADO.Net you need to be able to work with dataadapters, datasets,
> datatables, datarows, etc. But not recordsets.
>
> Kerry Moorman
>
>
> "cj" wrote:
>
>> I've used datatables and datasets before.  Datasets being able to hold
>> more than one table and datatables being only one table.  My mind keeps
>> coming up with recordsets.  I can't remember how they fit into the picture.
>>
>> I'm going to be reading some records from a table in a sql db.
>>
Author
10 Mar 2006 3:16 AM
CMM
In .NET a Dataset is a container for one or more DataTables. They are
completely database unaware and agnostic.... think of it as an Array of
Arrays of Arrays. IMHO, it doesn't even belong in the System.Data namespace,
but should be in System.Collections.

A DataAdapter communicates with a database and fills the Dataset's tables.
It's the "bridge."

In .NET 2.0, the highly RETARDED throwback to the "1990's ADO" new
"TableAdapter" is an easier to use wrapper around the DataAdapter. It is
tightly coupled to a Dataset (violating all sorts of true n-tier principles)
and is for the braindead folks who couldn't grasp the way the original
DataAdapter worked.

--
-C. Moya
www.cmoya.com
Show quoteHide quote
"cj" <cj@nospam.nospam> wrote in message
news:emkb$M7QGHA.5584@TK2MSFTNGP12.phx.gbl...
> I've used datatables and datasets before.  Datasets being able to hold
> more than one table and datatables being only one table.  My mind keeps
> coming up with recordsets.  I can't remember how they fit into the
> picture.
>
> I'm going to be reading some records from a table in a sql db.