Find specific data row in Dataset

[Grey]

I have a dataset, is it possible to find one specific row of data with some
criteria?? For example There are two fields, Field1 and Field2 in the
datatable of dataset. i need to search is Field1 column has value 'a', if
so, i need to get the data of Field2.

Million thanks

 

[GrantMagic]

You can loop through a dataset to find that value

DataSet ds = new DataSet("table");
//FILL THE DATASET
string RequiredValue;

foreach(DataRow dr in ds.Table["tale"].Rows)
{
if(dr[0].ToString == "a") //WHERE 0 is the field1
{
RequiredValue = dr[1].ToString(); //WHERE 1 is field2
}
}


If you don't know the name of the datatable before hand, you can loop
through those too

foreach(DataTable dt in ds.Tables)
{
foreach(DataRow dr in dt.Rows)
{
if(dr[0].ToString == "a") //WHERE 0 is the field1
{
RequiredValue = dr[1].ToString(); //WHERE 1 is field2
}
}
}

 

[Hermit Dave]

DataRows[] drFiltered =
yourDataSet.Tables[0].Select("yourcolumnfiltercriteria");
if drFiltered.Length != 0 then you know you have the records filtered.

yourcolumnfiltercriteria could be
your columnname with any of the operators = != > < >= <= etc etc. look it up

--

Regards,

Hermit Dave
(http://hdave.blogspot.com)