values from database

Question

Hi there

Im havin a problem to get values from a table into variables, setting each variable with row values. To get values per column is easy I use this code:

string sql = "select val from fmFactor";

conn.Open();

OdbcCommand cmd = new OdbcCommand(sql,conn);

OdbcDataReader dr = cmd.ExecuteReader();

while(dr.Read())

{

fmDiscount = dr.GetDouble(0);

fmAdvert = dr.GetDouble(1);

fmExcess = dr.GetDouble(2);

fmTotal = dr.GetDouble(3);

}

conn.Close();
----
but thats for diffirent colums not rows
if any12 could assist me in this. I don't think its difficult at all tho
but Im stuck. o and im not using the dataset and adapters stuff to use the datarow thing.

thanx