Find a data in the data set

DataSet DSR = DS4;

Dsr.tables [0] .primarykey = new datacolumn [] {dsr.tables [0] .columns ["partname"]};

DataRow FoundRows = dsr.tables [0] .rows.find ("Channel Department");

DSR.Tables [0]. Rows.Remove (FoundRows);