DataAdapter for every Query?

[gdboling]

In my learning process I have an asp page that has several combobox's that will be populated from a database.

 

I was able to get one populated, but then I wondered,

 

Do I have to have a seperate SqlDataAdapter for every single combo box? Or can I re-use the DataAdapter I have and issue seperate SQL commands to gather my information?

 

I realize that I am going to have to have a DataSet and DataView for each one, but I would like some info on reusing a DataAdapter.

 

Thanks.

 

Gregg

[hrabia]

Yes, you can reuse DataAdaptor. Every DA has four command objects (for select, insert, delete and update) which can be modifided.