I am converting a VB.NET application to C#.NET and I have ran into a
situation that I cannot so far find an answer to. Retrieving data with
an ODBCDataReader, I could issue a rdr.Read method call and then
refernce the columns with the rdr("columnname") function. Seems that
C# does not allow access to the resultset row data using the column
name. rdr.GetString(0) seems to work. Is this a limitation in C#?

<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>I am converting a VB.NET application to C#.NET and I have ran into a
> situation that I cannot so far find an answer to. Retrieving data with
> an ODBCDataReader, I could issue a rdr.Read method call and then
> refernce the columns with the rdr("columnname") function. Seems that
> C# does not allow access to the resultset row data using the column
> name. rdr.GetString(0) seems to work. Is this a limitation in C#?

In C# you have to use sqare brackets ["columnname"] instead of the round
parenthesis ("columnname").

this is helpful for me
http://www.developerfusion.co.uk/uti...btocsharp.aspx

however, you'll have to watch the () vs [], the converter will screw those
up sometimes.






<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> I am converting a VB.NET application to C#.NET and I have ran into a
> situation that I cannot so far find an answer to. Retrieving data with
> an ODBCDataReader, I could issue a rdr.Read method call and then
> refernce the columns with the rdr("columnname") function. Seems that
> C# does not allow access to the resultset row data using the column
> name. rdr.GetString(0) seems to work. Is this a limitation in C#?
>

In C# indexers use square brackets; try rdr["columnname"]

Marc