i want to merge two tables in dataset.

Pavan Bujji

im getting the exception cannot find table 0.

My code is

con = new SqlConnection(strConString);

con.Open();

cmd = new SqlCommand("select * from Empdetails", con);

cmd.CommandType = CommandType.Text;

Da = new SqlDataAdapter(cmd);

Ds = new DataSet();

Da.Fill(Ds, "Empdetails");

cmd = new SqlCommand("select * from EmpTable", con);

cmd.CommandType = CommandType.Text;

Da = new SqlDataAdapter(cmd);

Ds = new DataSet();

Da.Fill(Ds, "EmpTable");

Grdtables.DataSource = Ds.Tables[0];

Grdtables.DataBind();

con.Close();

Ds.Tables[0].Merge(Ds.Tables[1]);

Dt = Ds.Tables[0];

for (i = 0; i <= Dt.Rows.Count - 1; i++)

{

Response.Write(Dt.Rows[i].ItemArray[0] + " -- " + Dt.Rows[i].ItemArray[1]);

}

Please give me the solution.

Regards,

Pavan.

6 Replies

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

Manas Mohapatra10y ago
You are getting exception because Dataset doen't contains tables.
Here couple of actions need to take care:
1. You are creating the DataSet each time before getting the result.
It should be once only.
2. Make sure that you have same no of columns and their data typpes in two tables otherwise it won't perfectly.
Because you are fetching data from EmpTable, Empdetails table.
Note : Please share any excpetion you are getting.
0
Salman Beg10y ago
okay then let me run the code once and will check and let you know.thanks.
0
Pavan Bujji10y ago
im using the same code which u have sent to me.eventhough it wilnt work.
0
Salman Beg10y ago
Please follow this link,
http://csharp.net-informations.com/dataset/dataset-merge-sqlserver.htm
Thanks.
0
Pavan Bujji10y ago
But I got the data from only first table [ Empdetails] . i didn't get from second table.But i want to merge that two tables.
0
Salman Beg10y ago
Hi.
The code is ok but i think there is no data exist in your dataset .
So please check it and restrict it before using it.
Thanks.
0