Select values from dataset

1 . Using Like
---------
foreach (DataRow dr in dsItem.Tables[0].Select("Name like '" + prefixText + "%'"))
{
items.Add(dr["Name"].ToString());
}
2. Using =
-----------
DataRow[] dRow = dsPurchaseRequestItems.Tables[0].Select("ItemId='" + hfItemId.Value + "'");
if (dRow.Length > 0)
{
dRow[0].Delete();
}
dsPurchaseRequestItems.AcceptChanges();