Data Type of sqldatareader column

[NevG]

Hi Gang

Can someone tell me the easiest way to determine and access a sqldatareader column. I am returning an unknown set of data and so I cannot specifically use GetInt32 or GetString etc... so Whats the easiest way for me to determine the data type of the column and then use it.

I would like to keep coding to amininum if possible.

Thanks

Nev G

 

[theoxyde]

Use the GetFieldType method.

if ( reader.GetFieldType( 0 ) == Type.GetType( "System.Int32" ) )
{
  // do something here
}