Using the same data adapter?

Arg81

Well-known member
Joined
Mar 11, 2005
Messages
949
Location
Midlands, UK
Programming Experience
1-3
Here's my scenario:

I have an Employee table linked to an EmployeeType table. Using an inner join I get;
EmployeeID | EmployeeName | EmployeeType

where EmployeeType can be Account Manager, Technician, Technologist, Admin or Administrative (just for note, Admin=IT staff, Administrative=department seniors)

On my form I have 4 combo boxes to select the Employee. BUT each combo box needs to be different, i.e. I have a combo box for Account Manager, Dept. Contact, who record was created by, and who did the work for the request (this is in a DataGrid)

Can I use SQL statements after the data adapter has generated the dataset, or do I have to have a data adapter for each combobox field? I.E. views in SQL server, e.g for account managers, "select * from Employee WHERE EmployeeType=3"?

Cheers,
Luke
 
Top Bottom