Data Type Equivalents

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?

Jan 12 '08 #1

Subscribe Post Reply

1257

Ian Semmel

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

"Elmo Watson" <wh****@yahoo.comwrote in message
news:#N**************@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?

Jan 12 '08 #2

Jonathan Wood

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

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

"Elmo Watson" <wh****@yahoo.comwrote in message
news:%2****************@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?

Jan 12 '08 #3

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" <wh****@yahoo.comwrote in message
news:%2****************@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?

Jan 13 '08 #4

Ian Semmel

Look up SqlDbType Enumeration.

"Elmo Watson" <wh****@yahoo.comwrote in message
news:eV**************@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" <wh****@yahoo.comwrote in message
news:%2****************@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?

Jan 13 '08 #5

Mark Rae [MVP]

"Elmo Watson" <wh****@yahoo.comwrote in message
news:eV**************@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/l.../ms131092.aspx
--
Mark Rae
ASP.NET MVP
http://www.markrae.net

Jan 13 '08 #6

Similar topics

program surgery vs. type safety

by: Aaron Watters | last post by:

I'm doing a heart/lung bypass procedure on a largish Python program at the moment and it prompted the thought that the methodology I'm using would be absolutely impossible with a more "type safe"...

Python

C and only C language has a standard 64 bit integer type ?

by: Timothy Madden | last post by:

Hello I've read here that only C language has a standard 64bit integer. Can you please tell me what are the reasons for this ? What is special about C language ? Can you please show me some...

C / C++

Data Type VC++ <--> VB6

by: robert | last post by:

Hi All, I have a problem. I have written a COM DLL in VB6 to do some stuff. I need to call this DLL from a VC++ program for which I have the code. I have managed to get as far as creating the...

C / C++

Question on multiple forms and referencing data

by: J. Black | last post by:

Hello everyone - I've been developing an incident tracking and reporting system for an emergency services outfit that I work with part time. It's going well, except for one fly in the ointment....

Microsoft Access / VBA

SQL programming. Working with auto-generated data objects.

by: Viorel | last post by:

Working as a beginner with data objects in Visual Studio 2003 and C#, I use the "Generate Dataset" command in order to generate automatically the dataset objects based on data adapters. Generated...

C# / C Sharp

VB6 > BV.Net Equivalents

by: Harry Strybos | last post by:

Hi All Is there a book or web site that lists all the VB.Net equivalents for VB.6 methods? In other words, a list of all VB6 keywords and their equivalent in VB.Net. This would be of enormous...

Visual Basic .NET

DB2 Load Varchar for bit data

by: imam888 | last post by:

How do I load "varchar for bit" data in hexadecimal format into a DB2 table ? Table definition =========== create table test ( i integer, v varchar for bit data (16)) db2 "IMPORT FROM...

DB2 Database

Reading raw data and writing out in EBCDIC format

by: Ven | last post by:

Hi, I am reading a kind of below mentioned raw data into my C++ program and writing it out but I want this to be converted into EBCDIC format, how can I accomplish this ? Right now I am using...

C / C++

Is Class Synonymous with Type?

by: garyusenet | last post by:

I'm using an example piece of code: - namespace Wintellect.Interop.Sound{ using System; using System.Runtime.InteropServices; using System.ComponentModel; sealed class Sound{ public static...

C# / C Sharp

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice