Max/Mini Value in datatable by comparing with other datatabl

Question

I have two datatables table1 and table 5
Table1

Par Name	Lowest	Highest	lower_limit	upper_limit
Con_3			-0.65	0.03
Con_2			-0.12	0.06
Con_1			-0.41	0.02

Table5

Con_1	Con_3	Con_2	Split	Die_ID	Normal_Inverse
0.0013	0.0018	0.0012	Stressed	N6K83_12	-2.49897
-0.0071	0.0015	-0.0005	Ref	N634-10_12	-2.16681
-0.0004	0.082	-0.0027	Stressed	N610_15	-1.97699

I want to compare lower limit and upper limit from table 1 with corresponding column (Con_1,Con_2,Con_3 from table 5 ) and delete the column in table5 if :

There is no value lesser then lower_limit OR there is no value greater than upper_limit in the table5 column

Vulpes · Answer

Assuming all numeric columns are of type double then try: foreach(DataRow dr in table1.Rows) { string colName = dr[Par Name].ToString(); if(table5.Columns.Contains(colName)) { double lower = (double)dr[lower_limit]; double upper = (double)dr[upper_limit]; double min = table5.Rows.Cast ().Min(r => r.Field (colName)); if (min >= lower) { double max = table5.Rows.Cast ().Max(r => r.Field (colName)); if (max } } } or if they're all strings try: foreach(DataRow dr in table1.Rows) { string colName = dr[Par Name].ToString(); if(table5.Columns.Contains(colName)) { double lower = double.Parse(dr[lower_limit].ToString()); double upper = double.Parse(dr[upper_limit].ToString()); double min = table5.Rows.Cast ().Min(r => double.Parse(r.Field (colName))); if (min >= lower) { double max = table5.Rows.Cast ().Max(r => double.Parse(r.Field (colName))); if (max } } }

Farhan Shariff · Answer

Thank you vulpes . works perfect only thing is I had to remove the last three columns from table5 ( Split  Die_id and normal inverse ) since I am adding it later again no problem :)

Khan Abrar Ahmed · Answer

Hi what basis u want to match the rows?? please explain little bit more.