Binding GriView

Question

How to merge two gridviews and display it in another gridview ?? thank u!!

Satyapriya Nayak · Answer

Untitled Page 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(); } } }

Sreejesh SP · Answer

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= ; dt2= ; 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

AbhiPriya M V · Answer

Hi thanks for ur reply!!!! Satyapriya getting values in gridview 3 but they are not merging..either gridview1 r gridview2 displayed in gridview3..

Binding GriView

Answers (3)