I'm using a DataSet to retrive data from a Database and access the values of the columsn returned. I then want to set the Text of various labels to the values of the columns. To do this I use to code below

appID.Text = dsAppData.Tables[0].Columns[0].ToString();


appName.Text = dsAppData.Tables[0].Columns[1].ToString();


gripsID.Text = dsAppData.Tables[0].Columns[2].ToString();

The problem is that it sets the text of the labels to the column names and not the values. Am I using the wrong code?

Thanks,

Wallace

Sorry but does anybody have any idea on this one?

Thanks,

Wallace

Another point that might help is when I try to write the name of the table as follows:

Response.Write(dsAppData.Tables[0].TableName.ToString());

The word "Table" is outputted on the screen. Anbody have any ideas?

The code I use to fill the DataSet is as follows:

string strAppDetailsQry = "Select A.AppID, A.AppName, A.GripsID";


strAppDetailsQry += " from Application A, FAQ F";


strAppDetailsQry += " where F.AppID = A.AppID";	


strAppDetailsQry += " AND F.FAQID = " + Int32.Parse(FAQID.Text);


SqlCommand appDetailsCmd = new SqlCommand(strAppDetailsQry, conn);





...


...





try


{


	conn.Open();


	dataAdapter = new SqlDataAdapter(strAppDetailsQry, conn);


	dsAppData = new DataSet();


	dataAdapter.Fill(dsAppData);


....


...


}


...

This is really bugging me so please help!

Regards,

Wallace

after you fill the dataset you must declare a datarow

dim dr as new datarow
dr = dataset.tables(0).rows(0)

and after that you use it like this:

label1.text = dr("column_name1").ToString()
label2.text = dr("column_name2").ToString()
....

and here you are.

HTH
Kiddu

Legend!!

How do i add logical table created (on the fly in the stored procedure, say @DisplayOutput)  to DataAdapter ? plz help.........

THanks in advance

You can use as shown below:

txtRow0Col0.Text = dsAppData.Tables[0].Rows[0][0].ToString();

txtRow0Col1.Text = dsAppData.Tables[0].Rows[0][1].ToString(); 

txtRow1Col3.Text = dsAppData.Tables[0].Rows[1][3].ToString();