Handling Multiple Tables in Typed Dataset

Question

Hi How will i create and fill data in Typed Dataset containing more then one table?..How will i populate the respective table involved in the SQL Query? For example in my Typed Dataset i have 2 tables Employee and Department table. I'm fetching the data from both the tables in the sql query. How will i use DataAdapter to fill both the tables in the Typed DataSet? regards Manpreet

mspadam · Answer

Hi Jagan This holds true for a query Select Employee.EMPIDEmployee.EMPNAMEDepartment.IDDepartment.DEPTNAME from EmployeeDepartment where Employee.DeptID=Department.ID. ? Regards Manpreet

jaac79 · Answer

dataAdapter.Fill(dataSet Employee) dataAdapter.Fill(dataSet Department)