Type info in ADO.NET

Rohit_Saksena

Member
Joined
Mar 3, 2005
Messages
14
Programming Experience
3-5
Hi All,

Is it possible for somebody to tell how to fetch the exact datatype of a column of a table in SQL Server 2000 into VB.NET. For Eg. a particular column is of type varchar in SQL Server and the type I am getting using ADO.NET is string.

Kindly help me in this regard.

Rohit Saksena
 
why you need this..string datatype is adequate for varchar type there is no need to change... can you tell me what prb u face if you have string datatype
 
Hi All,

Is it possible for somebody to tell how to fetch the exact datatype of a column of a table in SQL Server 2000 into VB.NET. For Eg. a particular column is of type varchar in SQL Server and the type I am getting using ADO.NET is string.

Kindly help me in this regard.

Rohit Saksena

.NET doesnt have any object of type VarChar. SQLServer doesnt have any type of string. The two are MAPPED to each other, they are not equal to each other
 
Back
Top