Compare DataTable and show rows that are not present

Question

table1 | Par Name .........| Par #|.......Units |LSL | USL | -----SKIP | Diffusion ......... 908513100. ......-... .. 0 ----- 99.9 ----- 1 Program ........... 908514100. ......-... 99.5 --- 999 -----1 AC_IC .. . . . . .908512100. . . . . . . .14-------13---------1 ACX_IC. . . . . . .98212100.. . . . . . 1 ------62----------1 table2 starttime | Product | Device | Diffusion | Program | 11 / 7 / 2013 SAF5100EL 163 - 0.145712003 - 0.146583006 11 / 7 / 2013 SAF5100EL 84 - 0.137499005 - 0.137592003 11 / 7 / 2013 SAF5100EL 44 - 0.142690003 - 0.143250003 11 / 7 / 2013 SAF5100EL 164 - 0.139434993 - 0.140459001 11 / 7 / 2013 SAF5100EL 34 - 0.147183999 - 0.148519993 table3 | Diffusion | | Program | - 0.145712003 - 0.146583006 - 0.137499005 - 0.137592003 - 0.142690003 - 0.143250003 - 0.139434993 - 0.140459001 - 0.147183999 - 0.148519993 //dt1 contains Diffusion etc as rows //dt2 contains diffusion etc as columns //dt3 is the required table table1 and table2 are compared and all parameter names present in table 1[row] and also in table2[column] are copied to table 3. Now i want to display Par names which are present table1 and not in table2[ie AC_IC ACX_IC ] how to include statements to show those parameter names DataTabl DataT e dt3 = new able (); DataRow dr = null ; for ( int i = 0 ; i Rows . Count ; i++) { string col = dt1. Rows [i][ Par Name ]. ToString (); if (dt2. Columns . Contains (col)) { if (!dt3. Columns . Contains (col)) { dt3. Columns . Add (col typeof ( string )); } if (dt3. Rows . Count == 0 ) { for ( int j = 0 ; j Rows . Count ; j++) { dr = dt3. NewRow (); dt3. Rows . Add (dr); } } for ( int j = 0 ; j Rows . Count ; j++) { dt3. Rows [j][col] = dt2. Rows [j][col]. ToString (); } } }

Vulpes · Answer

If you just want to display the excluded Par names on the console (say) then this should work: List excludedNames = new List (); DataTable dt3 = new DataTable(); DataRow dr = null; for (int i = 0; i { string col = dt1.Rows[i][Par Name].ToString(); if (dt2.Columns.Contains(col)) { if (!dt3.Columns.Contains(col)) { dt3.Columns.Add(col typeof(string)); } if (dt3.Rows.Count == 0) { for (int j = 0; j { dr = dt3.NewRow(); dt3.Rows.Add(dr); } } for (int j = 0; j { dt3.Rows[j][col] = dt2.Rows[j][col].ToString(); } } else { excludedNames.Add(col); } } Console.WriteLine(The following Par names were excluded from dt3
); foreach(string name in excludedNames) { Console.WriteLine(name); }

Vulpes · Answer

Yes but you've already changed the type of the columns to double when building table3. What I think you will need to do is to parse the strings in table2 to double when adding rows to table3: table3.Rows[j][col] = double.Parse (table2.Rows[j][col].ToString()); // EDITED If some values could be null then a more complicated expression will be needed.

Farhan Shariff · Answer

table type is string there are negative values also present in the table so in in order to sort them and chage their type clone is used

Vulpes · Answer

I don't see how you can efficiently build a list of excluded names without using an 'else' clause. But in any case you can't sort table3 before it's been built and populated. Looking now at this part of the code: DataTable resultDt = table3.Clone(); for (int m = 0; m { DataView dv = new DataView(table3); dv.Sort = filterExp.Split('')[m]; table3 = dv.ToTable(); for (int i = 0; i { if (resultDt.Rows.Count != table3.Rows.Count) { resultDt.Rows.Add(); } resultDt.Rows[i][m] = table3.Rows[i][m]; } } return resultDt; I don't see the need to clone table3 and also to sort the view one column at a time. I'd have thought the following code would suffice: DataView dv = table3.DefaultView; dv.Sort = filterExp.TrimEnd(''); // get rid of trailing comma return dv.ToTable();

Farhan Shariff · Answer

What about not using else how to build table3 at the same time show Parameter Names which are excluded

Farhan Shariff · Answer

Oh yeah :)

Vulpes · Answer

I'm just wondering why you've put Console.ReadLine() in the foreach loop? You'll then need to press enter to display the next excluded name.

Farhan Shariff · Answer

Can you please check the code [I have included sorting by using clone] But more importantly the excluded parameter's are not getting looped only one excluded parameter is being displayed I want to display excluded parameters and also build table3 with only those parameter names present. using else will stop table3 from building If I am not wrong. private static DataTable CompareTwoDataTable(DataTable table1 DataTable table2) { List excludedNames = new List (); DataTable table3 = new DataTable(); DataRow dr = null; string filterExp = string.Empty; for (int i = 0; i { string col = table1.Rows[i][Par Name].ToString(); if (table2.Columns.Contains(col)) { if (!table3.Columns.Contains(col)) { table3.Columns.Add(col typeof(double)); filterExp = filterExp + col +  asc ; } for (int j = 0; j { if (table3.Rows.Count != table2.Rows.Count) { dr = table3.NewRow(); table3.Rows.Add(dr); } table3.Rows[j][col] = (table2.Rows[j][col]); } } else { excludedNames.Add(col); } } Console.WriteLine(The following Par names were excluded from dt3
); foreach (string name in excludedNames) { Console.WriteLine(name); Console.ReadLine(); } DataTable resultDt = table3.Clone(); for (int m = 0; m { DataView dv = new DataView(table3); dv.Sort = filterExp.Split('')[m]; table3 = dv.ToTable(); for (int i = 0; i { if (resultDt.Rows.Count != table3.Rows.Count) { resultDt.Rows.Add(); } resultDt.Rows[i][m] = table3.Rows[i][m]; } } return resultDt; }