DataRow...Not getting it!

[jesus4u]

I have a dataset filled with 1 and only 1 row in a table called Broadcasts.

How do I read the value from the Title column? This errors out saying that there is no row at 0 or the same message if I change it to 1.

Waz up?!

dsCRH.Tables("Broadcasts").Rows(0)("Title")

[Pirate]

try this :

MessageBox.Show(dsCRH.Tables("Broadcasts").Rows(0).Item(0))

[jesus4u]

Originally posted by Pirate
try this :

MessageBox.Show(dsCRH.Tables("Broadcasts").Rows(0).Item(0))

cool got it thanks

[hellswraith]

Or you could do something like this:
Dim dr as DataRow
dr = dsCRH.Tables("Broadcasts").Rows(0)

MessageBox.Show(dr("ColumnName").ToString())

I am not one hundred percent sure on the syntax for VB.Net, but I think I got it right (To lazy to check it...lol).

Anyway, if you are only expecting one row back, why use the dataset object in the first place? You can just the DataRow object which holds only one row. Just a thought.