reading just one cell out of a dataset.

[N. Okan Guney]

Hello,
How could I read just one cell out of a dataset?

I have a query returing a 3 x 3 table.

a b c
d e f
x y z
I need the value of "f" ([2][2] ) from the table. How could I do this using
C#?

Thanks in advance,

System.Data.Dat aSet onhand(string partno) {

string connectionStrin g = "server=\'sql01 \'; trusted_connect ion=true;
database=\'data 03\'";

System.Data.IDb Connection dbConnection = new
System.Data.Sql Client.SqlConne ction(connectio nString);

string queryString = "SELECT [inmast].[fonhand] FROM [inmast] WHERE
(([inmast].[fpartno] = \'"+partno+"\ ') AND" + " ([inmast].[fcstscode] =
\'A\'))";

System.Data.IDb Command dbCommand = new System.Data.Sql Client.SqlComma nd();

dbCommand.Comma ndText = queryString; dbCommand.Conne ction = dbConnection;

System.Data.IDb DataAdapter dataAdapter = new
System.Data.Sql Client.SqlDataA dapter();

dataAdapter.Sel ectCommand = dbCommand; System.Data.Dat aSet dataSet = new
System.Data.Dat aSet();
dataAdapter.Fil l(dataSet);
return dataSet;
}