compare 2 different datagridview

Question

Dear Sir/Madam i want to compare two different datagridview with same column name with different row count. i want to compare both and fine row count (how much row not exist in second datagridview) and row which is not ixist in second datagridview into array or its display on third seprate datagridview. please help me to find solution as soon as possible.

Rashmiranjan Dalabehera · Answer

Hi Vedant Please check with below code. 1- Default.aspx .style1 { width: 100%; } Width=100%> BorderStyle=Solid BorderWidth=1px CellPadding=3 ForeColor=Black GridLines=Vertical Width=100%> BorderWidth=1px CellPadding=2 ForeColor=Black GridLines=None Width=100%> 2- Default.aspx.cs DataSet ds; DataSet ds1; protected void Page_Load(object sender EventArgs e) { ds = new DataSet(); ds.ReadXml(Server.MapPath(Employee.xml)); GridView1.DataSource = ds; GridView1.DataBind(); //------------------------------------------------------------------------ ds1 = new DataSet(); ds1.ReadXml(Server.MapPath(Employee1.xml)); GridView2.DataSource = ds1; GridView2.DataBind(); } private DataTable GoforDataSetCompare(DataSet ds DataSet dataSet int compareCase) { IEnumerable first = (from g in ds.Tables[0].AsEnumerable() select g); IEnumerable second = (from g in dataSet.Tables[0].AsEnumerable() select g); DataTable dt1 = first.CopyToDataTable(); DataTable dt2 = second.CopyToDataTable(); var getNotExistingds1 = first.AsEnumerable().Except(second.AsEnumerable() DataRowComparer.Default); var getNotExistingds2 = second.AsEnumerable().Except(first.AsEnumerable() DataRowComparer.Default); DataTable dtAll = new DataTable(); dtAll.Columns.Add(new DataColumn(EmpID typeof(string))); dtAll.Columns.Add(new DataColumn(EmpName typeof(string))); dtAll.Columns.Add(new DataColumn(EmpDept typeof(string))); dtAll.Columns.Add(new DataColumn(EmpMailID typeof(string))); if (compareCase == 1) { foreach (var dataRow in getNotExistingds1) { DataRow dr = dtAll.NewRow(); dr[0] = dataRow[0]; dr[1] = dataRow[1]; dr[2] = dataRow[2]; dr[3] = dataRow[3]; dtAll.Rows.Add(dr); } } else { foreach (var dataRow in getNotExistingds2) { DataRow dr = dtAll.NewRow(); dr[0] = dataRow[0]; dr[1] = dataRow[1]; dr[2] = dataRow[2]; dr[3] = dataRow[3]; dtAll.Rows.Add(dr); } } return dtAll; } protected void Button1_Click(object sender EventArgs e) { GridView3.DataSource = GoforDataSetCompare(ds ds11); GridView3.DataBind(); } protected void Button2_Click(object sender EventArgs e) { GridView3.DataSource = GoforDataSetCompare(ds ds1 2); GridView3.DataBind(); } 3- Emplyee.xml 1 A AB a@gmail.com 2 B AC b@gmail.com 3 C AD c@gmail.com 4 D AE d@gmail.com 4- Emplyee1.xml 1 A AB a@gmail.com 2 B AC b@gmail.com EMP001 Rashmiranjan IT rashmi@gmail.com EMP002 Dalabehera IT-Software dalabehera@gmail.com

Manas Mohapatra · Answer

Consider you have 3 grids G1 G2 G3. You are displaying data in G1 and G2. As per your question you to display records which are not present in G2 Gridview as compared to G1. Here I am checking first column value of G1 to first column value of G2 and adding records to list as per condition. If you want to change the logic you can put your own logic there. Here is the code: List newLists = new List (); //iterate first gridview foreach (GridViewRow row1 in G1.Rows) { if (row1.RowType == DataControlRowType.DataRow) { string gv1Value = row1.Cells[0].Text; //iterate second gridview foreach (GridViewRow row2 in G2.Rows) { if (row2.RowType == DataControlRowType.DataRow) { string gv2Value = row2.Cells[0].Text; //do comparison here if (!gv1Value.Contains(gv2Value)) { //if your criteria are met put the data in the new lists newLists.Add(Convert.ToInt32(gv1Value)); } } } } } if (newLists.Count > 0) { G3.DataSource = newLists; G3.DataBind(); } Here I created a demo list of Integers you can create as per your own requirement.