Problems with extracting Data from DataRow

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

Philip
Wed Aug 18 11:33:58 CDT 2004

Update!

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

Phil

"Philip Poole" <philip@dontreply.org> wrote in message
news:41236946$0$196$db0fefd9@news.zen.co.uk...
> 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
>
>