Data Type Equivalents

Data Type Equivalents

am 12.01.2008 19:56:39 von Elmo Watson

I know that Varchar in SQL Server is String in VB.Net, and INT is
Integer - - but I'm not sure I'm aware of all of them

Does anyone know of a good list which shows the equivalent data types from
SQL Server to VB.Net?

Re: Data Type Equivalents

am 12.01.2008 21:53:25 von Ian Semmel

If you have VS, you can look up SqlDbType in Help

"Elmo Watson" wrote in message
news:#N65ezUVIHA.1208@TK2MSFTNGP03.phx.gbl:

> I know that Varchar in SQL Server is String in VB.Net, and INT is
> Integer - - but I'm not sure I'm aware of all of them
>
> Does anyone know of a good list which shows the equivalent data types
> from
> SQL Server to VB.Net?

Re: Data Type Equivalents

am 12.01.2008 22:59:00 von Jonathan Wood

http://msdn2.microsoft.com/en-us/library/ms187752.aspx

--
Jonathan Wood
SoftCircuits Programming
http://www.softcircuits.com

"Elmo Watson" wrote in message
news:%23N65ezUVIHA.1208@TK2MSFTNGP03.phx.gbl...
>I know that Varchar in SQL Server is String in VB.Net, and INT is
>Integer - - but I'm not sure I'm aware of all of them
>
> Does anyone know of a good list which shows the equivalent data types from
> SQL Server to VB.Net?
>
>
>

Re: Data Type Equivalents

am 13.01.2008 07:04:35 von Elmo Watson

I just need a website or url that lists all of them on a page
searching for SqlDbType gives me 282 possibilities
clicking on the MSDN link just gives me a list of SQL data types

I need a list that gives the .Net equivalents to the SQL data types (or vice
versa), like:
varchar -- string
int -- Integer

........etc

"Elmo Watson" wrote in message
news:%23N65ezUVIHA.1208@TK2MSFTNGP03.phx.gbl...
>I know that Varchar in SQL Server is String in VB.Net, and INT is
>Integer - - but I'm not sure I'm aware of all of them
>
> Does anyone know of a good list which shows the equivalent data types from
> SQL Server to VB.Net?
>
>
>

Re: Data Type Equivalents

am 13.01.2008 08:16:26 von Ian Semmel

Look up SqlDbType Enumeration.

"Elmo Watson" wrote in message
news:eV91uoaVIHA.1204@TK2MSFTNGP03.phx.gbl:

> I just need a website or url that lists all of them on a page
> searching for SqlDbType gives me 282 possibilities
> clicking on the MSDN link just gives me a list of SQL data types
>
> I need a list that gives the .Net equivalents to the SQL data types (or
> vice
> versa), like:
> varchar -- string
> int -- Integer
>
> .......etc
>
> "Elmo Watson" wrote in message
> news:%23N65ezUVIHA.1208@TK2MSFTNGP03.phx.gbl...
>
> >I know that Varchar in SQL Server is String in VB.Net, and INT is
> >Integer - - but I'm not sure I'm aware of all of them
> >
> > Does anyone know of a good list which shows the equivalent data types
> from
> > SQL Server to VB.Net?
> >
> >
> >

Re: Data Type Equivalents

am 13.01.2008 13:36:04 von mark

"Elmo Watson" wrote in message
news:eV91uoaVIHA.1204@TK2MSFTNGP03.phx.gbl...

>I just need a website or url that lists all of them on a page

GIYF:
http://technet.microsoft.com/en-us/library/ms131092.aspx


--
Mark Rae
ASP.NET MVP
http://www.markrae.net