DataSet column values

[wallaceoc80]

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

 

[adonet]

use:
appID.Text = dsAppData.Tables[0].Columns[0]("Column name")

 

[wallaceoc80]

Same result! Any more ideas?

 

[adonet]

Sorry, should use:
appID.Text = dsAppData.Tables[0].rows[0]("Column name")

 

[wallaceoc80]

Tried this but it does not work. I get an error. Is this code c# or for VB? I'm writing in C# if this makes any difference to you.

Thanks again,

Wallace

 

[wallaceoc80]

I should have said that when I use the syntax provided by you the error I get is:

Method Expected

Regards,

Wallace

 

[adonet]

in help, index, type "cells, changing DataGrid cell values

 

[stsuing]

appID.Text = (string)dsAppData.Tables[0].Rows[0][0];

This gets the first column in the first row of the first table. This is returned as an object so you have to cast it.