delete rows from DataTable based on comparing row values

Question

CR	CN
4.69517	4.559232
6.100273	4.942965
4.148316	4.039106
4.469541	4.339533
121.9486	121.2923
118.4546	117.8093
126.1222	125.5393
41.86481	42.70397
48.10417	48.88662

I have a datatable I want to delete rows if both (CR > 6 && CN > 6) I need to check both conditions and then delete

foreach( DataRow row in table1.Rows )
{
if( /* condition* / )
row.Delete();
}

Vulpes · Answer

If dt is your DataTable and both columns are of type double then you can do: DataView dv = dt.DefaultView; dv.RowFilter = NOT(CR > 6 AND CN > 6); dt = dv.ToTable();

Vulpes · Answer

As it's a new question I've replied on the new thread you've started.

Farhan Shariff · Answer

I am trying to delete some data in column (Delta_sigma) by comparing it with value entered in textbox but i get error : Cannot perform ' DataColumn Delta_sigma = table1.Columns.Add(Delta_Sigma typeof(double)); Delta_sigma.Expression = (Convert(Median'System.Double') - Convert(Median_Refrence'System.Double')) / (sigma_Refrence); double delta_sigma_critical = double.Parse(textBox1.Text); DataRow[] rows4; rows4 = table1.Select( Delta_sigma foreach (DataRow r in rows4) r.Delete();

Jignesh Trivedi · Answer

hi Try following code DataTable dt = new DataTable(); dt.Columns.Add(CR typeof(decimal)); dt.Columns.Add(CN typeof(decimal)); dt.Rows.Add(new object[] { 4.69517 4.559232 }); dt.Rows.Add(new object[] { 6.100273 4.942965 }); dt.Rows.Add(new object[] { 4.148316 4.039106 }); dt.Rows.Add(new object[] { 4.469541 4.339533 }); dt.Rows.Add(new object[] { 121.9486 121.2923 }); dt.Rows.Add(new object[] { 118.4546 117.8093 }); var removeList = dt.DefaultView; removeList.RowFilter = CR>6 and CN>6; for (var i = 0; i { dt.Rows.Remove(removeList[i].Row); } hope this will help you.