Dear All,
i am trying to display 2 datatables in a single datagrid with the following code:

private void Page_Load(object sender, System.EventArgs e)
{
// Filling DataSets
      SqlConnection myconn=new SqlConnection(connstr);
      SqlDataAdapter da1=new SqlDataAdapter("select * from emp_Pers", myconn);
      SqlDataAdapter da2=new SqlDataAdapter("select * from emp_Off", myconn);

    DataSet ds1=new DataSet();
    DataSet ds2=new DataSet();

    da1.Fill(ds1, "emp_Pers");
    da2.Fill(ds1, "emp_Pers");

// Setting Primary Keys
   DataColumn[] pk1 = new DataColumn[] {ds1.Tables[0].Columns ["EmployeeID"]};
   ds1.Tables[0].PrimaryKey = pk1 ;

   DataColumn[] pk2 = new DataColumn[] {ds2.Tables[0].Columns["EmployeeID"]};
   ds2.Tables[0].PrimaryKey = pk2 ;

// Merging DataSets
    ds1.Merge(ds2, false, MissingSchemaAction.Add);

// Binding to DataGrid
    dgrid.DataSource =ds1;
    dgrid.DataBind();

}

i am getting runtime error as :

"System.ArgumentException: These columns don't currently have unique values" at the following line:
   ds1.Tables[0].PrimaryKey = pk1 ;

plz help out.

Regards,
Muskaan..

A. You can't bind a datagrid to more than one datatable (or specifically the DefaultView of a table). When you bind a dataset, the grid binds to the DefaultView of the first table in .Tables.

B. Look at the error you are getting. Your query is returning multiple rows with the same EmployeeID so ADO.NET can't make that column a primary key. You don't have to have a primary key on the datatable to bind it to a grid. However, it seems that you want to bind multiple tables so I'd guess that you are trying to do 1 of two things:

  1. Get related data from the second table (you'll need to do some complex binding)
  2. Perform a union of data. Instead of trying to merge data in .NET you could use a union query to lump it all together at the database level.

-Peter

Thanks Peter, i'll try it out.

Regards,
Muskaan.