Binding GriView

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Default.aspx.cs" Inherits="Merge._Default" %>

using System; using System.Collections; using System.Configuration; using System.Data; using System.Linq; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Xml.Linq; using System.Data.SqlClient; namespace Merge { public partial class _Default : System.Web.UI.Page { string strConnString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString; SqlDataAdapter sqlda1, sqlda2; protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { bindgrid1(); bindgrid2(); bindgrid3(); } } public void bindgrid1() { SqlConnection con = new SqlConnection(strConnString); con.Open(); sqlda1 = new SqlDataAdapter("select * from employee", con); DataSet ds1 = new DataSet(); sqlda1.Fill(ds1, "employee"); GridView1.DataSource = ds1; GridView1.DataBind(); } public void bindgrid2() { SqlConnection con = new SqlConnection(strConnString); con.Open(); sqlda2 = new SqlDataAdapter("select * from product", con); DataSet ds2 = new DataSet(); sqlda2.Fill(ds2, "product"); GridView2.DataSource = ds2; GridView2.DataBind(); } public void bindgrid3() { SqlConnection con = new SqlConnection(strConnString); con.Open(); sqlda1 = new SqlDataAdapter("select * from employee", con); sqlda2 = new SqlDataAdapter("select * from product", con); DataSet ds1 = new DataSet(); DataSet ds2 = new DataSet(); sqlda1.Fill(ds1, "employee"); sqlda2.Fill(ds2, "employee"); ds1.Merge(ds2, false, MissingSchemaAction.Add); GridView3.DataSource = ds1; GridView3.DataBind(); } } }

Dear Abhipriya,

      please use datatable by to fill gridview,then third datatble use to get values from first and second ,then this third datatable use to bind third grid view and you get the result is merging of first and second gridview

Please Read below sample code and apply your appliaction

page.cs

datatable dt=new datatable();

datatable dt2=new datatable();

datatable dt3=new datatable();

dt=<"get value from database or others'>;

dt2=<"get value from database or others'>;

gridview1.datasource=dt;

gridview1.databind();

gridview2.datasource=dt2;

gridview2.databind();

dt3 = dt.Copy()

dt3.Merge(dt2, false, MissingSchemaAction.Ignore);

gridview.datasource=dt3;

gridview.databind();

Please try this code 

Thanks

Sreejesh S P