Retrieving Value from a DataColumn

reverendleo · 11-22-2005, 09:00 PM

Hello All!!

Can't figure out for the life of me how to get the value from a DataColumn and throw it in a label. I've tried about every variation I can think of, and no dice. I know the DataSet/DataTable was populated correctly, and I know the name of the column I want is "JDESC"

Here's the code:

Code:

lblJobName.Text = ds.Tables("MASTER_JCM_R1").Rows[0].(Item("JDESC").Value)

I've also tried:

Code:

ds.Tables("MASTER_JCM_R1").Columns("JDESC").Value
ds.Tables("MASTER_JCM_R1").Columns("JDESC").ToString()
ds.Tables("MASTER_JCM_R1").Rows[0].Item("JDESC").ToString()

...a few others as well. ALL generate the error:

Value of type 'System.Data.DataRowCollection' cannot be converted to 'String'

Help! Thanks so much!

Brandoe85 · 11-23-2005, 04:15 AM

Have you tried this?

Code:

lblJobName.Text = ds.Tables("MASTER_JCM_R1").Rows(0).Item("JDESC")

Good luck;

reverendleo · 11-23-2005, 01:42 PM

Brando!

Thank you sir!

The final line that worked properly came to be this:

Code:

lblJobName.Text = ds.Tables("MASTER_JCM_R1").Rows(0).Item("JDESC").ToString()

I really appreciate the brain jump-start. Much obliged!

Nischumacher · 11-23-2005, 01:49 PM

i don't know why but mentioning the names of table and column gave me a null refence error... so i used index instead... which worked...

Code:

lblJobName.Text = ds.Tables(0).Rows(0).Item(3)

Brandoe85 · 11-23-2005, 02:18 PM

Glad you got it working

Quote:

Originally Posted by Nischumacher

i don't know why but mentioning the names of table and column gave me a null refence error... so i used index instead... which worked...

Code:

lblJobName.Text = ds.Tables(0).Rows(0).Item(3)

The Tables and Item properties are overloaded, you can either access them by name, or index. In order to access the Table property by name, you would have to specify a name when you add the table. For the item, as long as the column you want is in your table, you should be able to reference by it's name as well.