I want to do this in "ToString" c#

[trint]

Here is the vb.net version of what I need to do in c#:
myString = drSQL.Item("columnName").ToString()

Thanks,
Trint

 

[Marek]

I see no syntactic problem except missing ";" and undeclared variable

string myString = drSQL.Item("columnName").ToString();

 

[trint]

well, I get this error though:
(542): 'System.Data.SqlClient.SqlDataReader' does not contain a
definition for 'Item'

 

[Marek]

Have a look here then
http://msdn.microsoft.com/library/d...temdatasqlclientsqldatareadermemberstopic.asp
in C#, the properties are indexed like ProperyName[parameters] and in
SqlDataReader, what is .Item() in VB is SqlDataReader[] indexer

so, I guess

string myString = drSQL["columnName"].ToString();

should work

 

[Joakim Karlsson]

SqlDataReader.Item is what is known as an indexer in C#. The syntax
should be:

myString = drSQL["columnName"].ToString();

Indexers are supposed to make the code prettier, but most of the time
these kinds of syntactic sugar just makes the code more confusing.

Regards,
Joakim

 

[trint]

thanks...that was the fix!
trint

 

[Matthew Smith]

Here is the vb.net version of what I need to do in c#:
myString = drSQL.Item("columnName").ToString()

Perhaps you should be writing:
myString = drSQL["columnName"].ToString();

If drSQL is a DataRow.