Problems with extracting Data from DataRow

  • Thread starter Thread starter Philip Poole
  • Start date Start date
P

Philip Poole

Hello everyone,



I have a DataSet in which I have extracted a row, within the row there is a
column called "Text". This is taken from a table within SQL 2000 whose
column has a data type of "text".



When I try to retrieve the value using

row["Text"].ToString()



It retrieves a blank string.



However when I use row[3].ToString() the command works.



I cannot understand why using row["Text"] does not, I have looked at the row
variable through the watch and column 3 has a "_columnName" equal to "Text".
When I try the other columns using the field name to extract the value
works. However it does not with the column named "Text", does anyone have
any idea why as I am completely stumped.



Many Thanks in advance for your answers



Phil
 
Update!

The row I was trying to access did not actually have any value for Text, so
I was getting expected behaviour!

Phil
 
Back
Top