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
 

alim

Well-known member
Joined
Dec 12, 2005
Messages
89
Location
bangladesh
Programming Experience
3-5
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
 

cjard

Well-known member
Joined
Apr 25, 2006
Messages
7,052
Programming Experience
10+
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
 
Top Bottom