Once you fill a dataset from a table in a database we can manupulate the data in the dataset just like we do in the database.
Select
DataRow[] drMainAccount = dsData.Tables[“Accounts”].Select(“CST_CODE = ‘” + MainAccount + “‘”);
AccountName = drMainAccount[0][“CST_NAME”].ToString();