If you need to run multiple queries to fill the dataset it's better to open the connection, use the DataAdapters, and then close it. Otherwise you'll be opening and closing the connection multiple times. The DataAdapter will leave the connection in the state it found it.

Roger

>
>This is only in the case if you explicitly open the connection. If your DataSet is filled with a da.Fill(ds), there's no reason to manually open it *or* close it ... the DataAdapter takes care of that for you.
>