Arg81
Well-known member
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
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
