System.Data.DataRow

[TheConeHead]

I am getting data via:

System.Data.DataRow tComment = commentsDS.Tables["table"].Rows[l];

but I only get "System.Data.DataRow" outputted - when I try to convert it to a string to output I get an error saying you cannot convert System.Data.DataRow to a string... any ideas?

 

[ca8msm]

Yes, it is correct that you can't convert a DataRow to a String - they are completely different objects. To get a value out of one of the Items in the DataRow, use:

commentsDS.Tables("table").Rows(0).Item(0).ToString

____________________________________________________________

Need help finding an answer?

Try the Search Facility or read FAQ222-2244 on how to get better results.

 

[TheConeHead]

ok - thanks for the reply - I tried:

System.Data.DataRow tComment = commentsDS.Tables["table"].Rows[l].ToString();

but I still get the error:

Cannot implicitly convert type 'string' to 'System.Data.DataRow'

any ideas?

 

[ca8msm]

Re-read my post and example again...


____________________________________________________________

Need help finding an answer?

Try the Search Facility or read FAQ222-2244 on how to get better results.

 

[TheConeHead]

ok - I see - now I tried:

commentsDS.Tables("table").Rows(l).Item("column").ToString;

and I get:

'System.Data.DataSet.Tables' denoted a property where a method was expected

 

[ca8msm]

That's because you are using C# not VB.NET - you'll have to use square brackets.


____________________________________________________________

Need help finding an answer?

Try the Search Facility or read FAQ222-2244 on how to get better results.

 

[TheConeHead]

I found the solution and it actually should be:

commentsDS.Tables["table"].Rows[l]["column"].ToString();

Thanks for your help...

 

[ca8msm]

Yes, that's another method that will work as does the method I provided


____________________________________________________________

Need help finding an answer?

Try the Search Facility or read FAQ222-2244 on how to get better results.