How to query a dataset more easier

[Guest]

Is there an easier way to query a dataset other than doing the following
code: I just want to set a variable based on the value of a input paramenter.

foreach(DataRow currentRow in dsAllData.Tables["WorkSheet"].Rows)
{

if (currentRow["WRKBK_CD"] == WorkSheet_Code)
{
WorkSheet_Name = currentRow["WS_NM"].ToString();
}
}

 

[Juno]

Hi Nicole,

If you'd like to query a single row, use find
methodataSet.Tables(TableName).Rows.Find(keys)

For query multi rows : DataSet.Tables(TableName).Select(filterExpression)

 

[Sijin Joseph]

foreach(DataRow selRow in daAllData.Tables["Worksheet"].Select("WRKBK_CD ==
" + WorkSheet_Code.ToString())
{
WorkSheet_Name = selRow["WS_NM"].ToString();
}

 

[Cor Ligthert]

Nicole

Use a dataview and in that the property rowfilter

http://msdn.microsoft.com/library/d...rlrfsystemdatadataviewclassrowfiltertopic.asp

You can as well use a datatable.select however the dataview is a little bit
faster (it is also dynamic while the select is static)

I hope this helps?

Cor