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.

delete rows from DataTable based on comparing row values

Answers (4)