How to remove a certain row from DataTable ?

Question

How do i achieve simple sql query like

delete from Users where userCity='Munich'

with DataTables ?

p.s. without using Linq or something like that simply because i do not use it though project.

Answer 1

DataRow[] rows;
rows=dataTable.Select("userCity = 'Munich'");
foreach(DataRow r in rows)
r.Delete();

Answer 2

DataTable dt =ds.tables[0]; DataRow row =dt.Select("the condition") dt.Rows.Remove(row);

Answer 3

DataRow[] rows = YourDataTable.Select("Your Condition");
foreach(DataRow r in rows)
r.Delete();