Converting VB.NET to C#.NET

[zacks]

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#?

 

[Alberto Poblacion]

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").

 

[sloan]

this is helpful for me
http://www.developerfusion.co.uk/utilities/convertvbtocsharp.aspx

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

 

[Marc Gravell]

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

Marc