Kevin,
>>Is there a 'simpler' way to do this?<Seems pretty simple to me to use the DataAdaper.Fill(). And no, to answer your question, there is no simpler way. <g>
~~Bonnie
>I'm glad you thought that was a good question, because (now) I have a really stupid question.
>
>If I want to do an SQL query and bring back the results in a dataset, do I *have* to use the data adapter?
>
>I have a form where I need to bring back 3 data tables...so I do a
>
>MyAdapter = new SqlDataAdapter("SELECT * FROM TABLE1; SELECT * FROM TABLE2; SELECT * FROM TABLE3,MyConnection)
>
>DsReturn = new DataSet();
>MyAdapter.Fill(DsReturn,"whatever");
>
>Is there a 'simpler' way to do this? About the only requirement is that it has to be a dataset, it can't be a data reader.
>
>Thanks,
>Kevin