>The following are some of the various possibilities for .NET to recognize a data type from a database field:
>
>System.String
>System.Int32
>System.DateTime
>System.Boolean
>System.Decimal
>System.Byte[]
>System.TimeSpan
>
>I am trying to verify if the SQL Server field is a VarChar, will the recognized data type be "System.VarChar"?
The only way I know is to query SQL Sever.
use mydb
exec sp_columns mytable
returns the structure of the table.
You can fill a datatable, find the column in the datatable and you'll have the SQL datatype
Anyone who does not go overboard- deserves to.
Malcolm Forbes, Sr.