Hi
I am working on a database application. I have several ComboBoxes in the main window. They all retrieve data from one table (a lookup table). Each reads a subset of the table. What i am doing now is that I have several SqlDataAdapters & DataSets each reads one subset of the table. And each ComboBox gets its data from one DataSet. What I want to do, if possible, is to have only one SqlDataAdapter and pass it parameters from the ComboBoxes. Is it possible? If yes, How?
I am using VS2003 and creating everything from the design window not from the code
Thanks
I am working on a database application. I have several ComboBoxes in the main window. They all retrieve data from one table (a lookup table). Each reads a subset of the table. What i am doing now is that I have several SqlDataAdapters & DataSets each reads one subset of the table. And each ComboBox gets its data from one DataSet. What I want to do, if possible, is to have only one SqlDataAdapter and pass it parameters from the ComboBoxes. Is it possible? If yes, How?
I am using VS2003 and creating everything from the design window not from the code
Thanks