delete rows from DataTable based on comparing row values

Farhan Shariff

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();
}

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vulpes12y ago
Accepted 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();
Vulpes12y ago
As it's a new question, I've replied on the new thread you've started.
Farhan Shariff12y ago
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 '<' operation on System.Double and System.String.

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 < delta_sigma_critical ");
foreach (DataRow r in rows4)
r.Delete();
Jignesh Trivedi12y ago
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 <= removeList.Count - 1; i++)
{
dt.Rows.Remove(removeList[i].Row);
}
hope this will help you.