[Mono-list] ADO and mono

Eric Damron edamron@spamcop.net
Tue, 19 Oct 2004 20:11:15 -0700


Thanks Hector.

It's still a bit confusing.  So what you're saying is that a single 
dataset can contain the result of more than one query?  Each query 
result in its own table?  Did I get it right?

My head hurts...

Hector Geraldino wrote:

>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
>>    
>>
>
>
>  
>