Loading

Handling Multiple Tables in Typed Dataset

mspadam

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

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

mspadam22y ago
Hi Jagan, This holds true for a query Select Employee.EMPID,Employee.EMPNAME,Department.ID,Department.DEPTNAME from Employee,Department where Employee.DeptID=Department.ID. ? Regards, Manpreet
jaac7922y ago
dataAdapter.Fill(dataSet, "Employee") dataAdapter.Fill(dataSet, "Department")