GetValue

[Guest]

Is there any way to use GetValue on a sqldatareader.Read() by specifying
column names instead of column numbers (or another method)?

 

[William F. Robertson, Jr.]

I think you are looking for...

SqlDataReader reader;
....
if ( reader.Read() )
object value = reader["Column1"];
object value2 = reader["Column2"];


or VB style ( I think)

dim value as object = reader("Column1")
dim value2 as object = reader("Column2")

HTH,

bill

 

[Guest]

perfick! thanks

I think you are looking for...

SqlDataReader reader;
....
if ( reader.Read() )
object value = reader["Column1"];
object value2 = reader["Column2"];


or VB style ( I think)

dim value as object = reader("Column1")
dim value2 as object = reader("Column2")

HTH,

bill

Is there any way to use GetValue on a sqldatareader.Read() by specifying
column names instead of column numbers (or another method)?