I have the following code which connects to a database and stores the data into a dataset.
What I need to do now is get a single value from the data set (well actually its two the first row column 4 and 5)
OdbcConnection conn = new OdbcConnection();
conn.ConnectionString = ConfigurationManager.ConnectionStrings["ConnectionString2"].ConnectionString;
DataSet ds = new DataSet();
OdbcDataAdapter da = new OdbcDataAdapter("SELECT * FROM MTD_FIGURE_VIEW1", conn);
da.Fill(ds)
So, I need to get two specific items and store them into ints, the psudo code would be
int var1 = ds.row1.column4
int var2 = ds.row1.column5
Any ideas on how I can do this?
Also, can some one shed a light on data tables too as this may be related to how I'm going about doing this.