I have a
dsView = new DataSet();
select * from MEN where Fname = 'zz'
You cannot run complete SQL statements on a
DataSet - but the
DataTable inside your
DataSet does have a method called
Select(string) which selects an array of
DataRow object that match a certain criteria.
Check out the MSDN docs on DataTable
You would probably have to do something like (untested):
DataTable tblMEN = dsView.Tables["MEN"]; DataRow results = tblMen.Select("Fname = 'zz'");