having lots of query in a page

[pelegk1]

i have a page where i read lot of tables from the DB and show it in an asp:DropDownList for example.
can i make all this reading from the db withought the need all the time to close and open the connection to the DB for each query?
thnaks in advance
peleg

[takkie]

yup.

open connection, and exec multiple equerys, and then close the connection....

- Tak