Hi guys,
This is the problem.
I have three tables: factory, employee, activity
In my db I use an intersectiontable factoryemployeeactitvity.
Now I want all employees of a certain factory.
I call a dataset from that intersectiontable to get all the id's of the employees who are related to the factory. So far so good.
But now I want to get the employeedetails for every record in that dataset.
Can someone please help me because I'm losing it :-)
Mahesh ChandPosted Dec 2, 2012, 6:22 PM
A DataSet is a collection of DataTable objects. If you selected 3 tables in your DataSet, it will have 3 DataTable object, one for each table.
You can access a table like this:
DataTable empTable = DataSet["Employee"];
Now you can use any Filter, search operations on empTable.