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;
    DataColumn pk2;

    pk1(0)=ds1.Tables[0].Columns["EmployeeID"];
    ds1.Tables[0].PrimaryKey =pk1;


    pk2(0)=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();

}

The places where i am getting error is highlighted in RED.
And d errors are:

1)'pk1' denotes a 'variable' where a 'method' was expected

2)Cannot implicitly convert type 'System.Data.DataColumn' to 'System.Data.DataColumn[]'

3)'pk2' denotes a 'variable' where a 'method' was expected

4)Cannot implicitly convert type 'System.Data.DataColumn' to 'System.Data.DataColumn[]'

please help me out.

Thanks & Regards,
Muskaan. :)

Right, use [] instead of () for arrays; but the problem is you need a DataColumn[] array declared and not a DataColumn type for that to work first and foremost.

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

Brian

Thanks Brian, but now 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..

Can anybody help me out with my problem.

It seems the data in the column you are assigning as primary key is containing some duplicate values. Remove those duplicate values and try again.

Regards
Raj

Yes, there is some duplicated data is what it is saying, you can combine columns for the primary key or use another key that is unique.

Brian