Returning values to variables from a c# SQL statement

Do you mean you execute a SQLCommand to get a dataset or datareader from DB2 and you want to get the vaues of field2,4, and 10 into C# variables?

If so:

I assume you are doing something like this:
http://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp?topic=/com.ibm.db2.udb.dndp.doc/htm/frlrfIBMDataDB2DB2DataReaderClassTopic.htm
So take a look at this section:

 myReader = myCommand.ExecuteReader();
   // Always call Read before accessing data.
   while (myReader.Read()) {
      Console.WriteLine(myReader.GetInt32(0) + ", " + myReader.GetString(1));

Select allOpen in new window

You get the data via:
myReader.GetSomething(Indexvalue--zero based)

Example:
Int32 i = myReader.GetInt32(0)

This would get the first field into an int treating it as such or cause an error if field 0 is a string.