HOW TO: Merge Two Tables in One GridView
<!DOCTYPE html PUBLIC “-//W3C//DTD XHTML 1.0 Transitional//EN” “http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd”>
<html xmlns=”http://www.w3.org/1999/xhtml” >
<head runat=”server”>
<title>Merge Two DataSet</title>
</head>
<body>
<form id=”form1″ runat=”server”>
<div>
<table width=”70%” align=”center” border=”4″>
<tr><td height=”20px”></td></tr>
<tr><td align=”center”>
<asp:DataGrid ID=”GridAllRecord” runat=”server” HeaderStyle-BackColor=”blue”>
</asp:DataGrid>
<tr><td height=”20px”></td></tr>
</td></tr>
</table>
</div>
</form>
</body>
</html>
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
public partial class _Default : System.Web.UI.Page
{
SqlConnection con;
SqlDataAdapter da;
DataSet ds1 = new DataSet();
DataSet ds2 = new DataSet();
protected void Page_Load(object sender, EventArgs e)
{
binddata();
}
public void binddata()
{
con=new SqlConnection(“Data Source=MCN101; Initial Catalog=MergeTable; Uid=sa; pwd=”);
da = new SqlDataAdapter(“Select * from Table1″, con);
da.Fill(ds1, “Record”);
da = new SqlDataAdapter(“select * from Table2″, con);
da.Fill(ds2, “Record”);
ds1.Merge(ds2);
GridAllRecord.DataSource = ds1;
GridAllRecord.DataBind();
}
}