PC Review


Reply
Thread Tools Rate Thread

Data Type Equivalents

 
 
Elmo Watson
Guest
Posts: n/a
 
      12th Jan 2008
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?



 
Reply With Quote
 
 
 
 
Ian Semmel
Guest
Posts: n/a
 
      12th Jan 2008
If you have VS, you can look up SqlDbType in Help

"Elmo Watson" <(E-Mail Removed)> wrote in message
news:#(E-Mail Removed):

> 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?


 
Reply With Quote
 
Jonathan Wood
Guest
Posts: n/a
 
      12th Jan 2008
http://msdn2.microsoft.com/en-us/library/ms187752.aspx

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

"Elmo Watson" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
>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?
>
>
>


 
Reply With Quote
 
Elmo Watson
Guest
Posts: n/a
 
      13th Jan 2008
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" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
>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?
>
>
>



 
Reply With Quote
 
Ian Semmel
Guest
Posts: n/a
 
      13th Jan 2008
Look up SqlDbType Enumeration.

"Elmo Watson" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed):

> 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" <(E-Mail Removed)> wrote in message
> news:%(E-Mail Removed)...
>
> >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?
> >
> >
> >


 
Reply With Quote
 
Mark Rae [MVP]
Guest
Posts: n/a
 
      13th Jan 2008
"Elmo Watson" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...

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


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


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

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Convert a Number data type to a Text data type TKM Microsoft Access Queries 9 6th Nov 2008 09:59 PM
Data Type Mismatch in Expression - can I force a query to read as a diferent data type? S Davis Microsoft Access Queries 1 7th Jun 2007 11:33 PM
Append Data Type Text Y/N to Data Type Y/N in Query HELP! =?Utf-8?B?dHJveQ==?= Microsoft Access Queries 1 25th Apr 2006 01:11 AM
Change Memo data type to Text data type DS Microsoft Access Getting Started 1 26th Jan 2005 04:56 PM
Convert String Data Type to UniqueIdentifier data type =?Utf-8?B?YW5n?= Microsoft ADO .NET 4 26th Jan 2004 10:58 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 10:29 AM.