Sir

I have two Dataset naming Employee and Salary

Employee Dataset have three colomns coloumns ------------- Emp_id, Name, Address,

Salary Dataset have three more coloumns -------------------- Sal_id, Salary, Emp_id

in Employee Dataset Emp_id is parimary Key

in Salary Dataset Emp_id is Foreign Key


Now I want that both the dataset in Windows Form Employee Dataset in Details

and Salary Dataset in DatagridView.

that all things I done


Now what I required is when I select a Emp_id is 1
then in Datagridview they also show a detail of Emp_id is 1

I thing I clear my point.

and when you have any difficulty understanding this

please asked me

Please help me out in this

Thanks
Ashish

I think I understand

Employee DataSet
=======

- Emp_id PRIMARY KEY
- Name
- Address

Salary dataset
=============

- Sal_id
- Salary
- Emp_id FOREIGN KEY

You want to select all of the salary rows, where the emp_id = 1?

Firstly, you have to place the 2 DataTables into the same DataSet, and then add a DataRelation to the columns like this:

DataSet myDataSet = new DataSet();
myDataSet.Tables.Add ( GetEmployeeTable() );
myDataSet.Tables.Add ( GetSalaryTable() );

DataColumn prmyEmployeeId = myDataSet.Tables["Employee"].Columns["Emp_id"];
DataColumn frgnEmployeeId = myDataSet.Tables["Salary"].Columns["Emp_id"];

DataRelation dr = new DataRelation( prmyEmployeeId, frgnEmployeeId );

myDataSet.Relations.Add ( dr );

//Now get the row you need.

DataRow[] filteredRow = myDataSet.Tables["Employee"].Select("Emp_id = 1");

DataRow[] salaryRow = filteredRow[0].GetChildRows();

//Since there is a 1=>1 relation, salaryRow is of length 1.

Hope this helps

Dom