Delete data row from data table

[Mr_JDavey (Joshua Davey)]

Hi there @1vivek12.

@1vivek12

i need to delete row which are not equal to a string variable how should i delete row then as variable value keep on changing

@1vivek12

My column name is ENODEB and my variable is Current_SiteID. so in a data datable if row is not equal current_siteid ,then delete row

You can do the following:

dtMyDataTable = dtMyDataTable.AsEnumerable.Where(Function (x) x.Item("ENODEB").ToString.Trim.ToLower.Equals(current_siteid.Trim.ToLower) = True).CopyToDataTable

This will return a DataTable where all rows meet your criteria (‘ENODEB’ column = current_siteid).

Thanks,
Josh