Isolate Dataset result

[Shaitan00]

Given a Dataset [oRecs] generated by an SQL query.

I want to isolate/extrat some specific date

 

C# CODE:

oRecs = oDB.GetRecords("select [X] from

 

This will generate a dataset [oRecs] with one row of data [only one result from the query] and one column [X].

I need to pass that value in Column [X] (as a string) to a function on the next line.

 

So the question is, how do I isolate the value in the Dataset itself?

[Nerseus]

You'd probably be better off using a Command object's ExecuteScalar function, which is meant to be used when you have exactly one value being returned from a query.

 

If you want to use the DataSet, try something like:

string s = oRecs.Tables[0].Rows[0][0].ToString();

 

There are a LOT of assumptions there, but you get the idea.

 

-ner