[Mono-list] ADO and mono

[Hector Geraldino]

Hi,

Maybe a single query can only return a single database, but in a Dataset you
can hold more than one table (a collection of datatables).  Look at the
DataSet.Tables.Add() method to see how it works.

You migth ask "why have more than one datatable in a dataset", and if you
visit the topic about relationships between tables, you'll find that you can
create a complete (pseudo-complete) RDBMS with a great characteristic: it's
absolutely disconnected.

hectorG
----- Original Message -----
From: "Eric Damron" <edamron@spamcop.net>
To: "mono-list" <mono-list@lists.ximian.com>
Sent: Tuesday, October 19, 2004 7:48 PM
Subject: Re: [Mono-list] ADO and mono


>
> Thanks for the reply Morten.  I guess what confused me was that the
> author used the same name for the recordset return table as the table he
> was querying.
>
> I'm still a little confused because the next thing he does is:
>
> DataTable dataTable = ds.Tables[0];
>
> If a single recordset table is returned isn't the [0] redundant?  How
> can one return more than a single recordset table?
>
> Thanks
> _______________________________________________
> Mono-list maillist  -  Mono-list@lists.ximian.com
> http://lists.ximian.com/mailman/listinfo/mono-list