SQL SERVER TYPES, COMPATIBLE Sql* TYPES, AND GetSql* METHODS : SQL Data Type « Database ADO.net « C# / C Sharp

Home
C# / C Sharp
1.2D Graphics
2.Class Interface
3.Collections Data Structure
4.Components
5.Data Types
6.Database ADO.net
7.Design Patterns
8.Development Class
9.Event
10.File Stream
11.Generics
12.GUI Windows Form
13.Language Basics
14.LINQ
15.Network
16.Office
17.Reflection
18.Regular Expressions
19.Security
20.Services Event
21.Thread
22.Web Services
23.Windows
24.Windows Presentation Foundation
25.XML
26.XML LINQ
C# / C Sharp by API
C# / CSharp Tutorial
C# / CSharp Open Source
C# / C Sharp » Database ADO.net » SQL Data TypeScreenshots 
SQL SERVER TYPES, COMPATIBLE Sql* TYPES, AND GetSql* METHODS


SQL SERVER TYPE    Sql* TYPE             GetSql* METHOD

bigint             SqlInt64              GetSqlInt64()

int                SqlInt32              GetSqlInt32()

smallint           SqlInt16              GetSqlInt16()

tinyint            SqlByte               GetSqlByte()

bit                SqlBoolean            GetSqlBoolean()

decimal            SqlDecimal            GetSqlDecimal()

numeric            SqlDecimal            GetSqlDecimal()

money              SqlMoney              GetSqlMoney()

smallmoney         SqlMoney              GetSqlMoney()

float              SqlDouble             GetSqlDouble()

real               SqlSingle             GetSqlSingle()

datetime           SqlDateTime           GetSqlDateTime()

smalldatetime      SqlDateTime           GetSqlDateTime()

char               SqlString             GetSqlString()

varchar            SqlString             GetSqlString()

text               SqlString             GetSqlString()

nchar              SqlString             GetSqlString()

nvarchar           SqlString             GetSqlString()

ntext              SqlString             GetSqlString()

binary             SqlBinary             GetSqlBinary()

varbinary          SqlBinary             GetSqlBinary()

image              SqlBinary             GetSqlBinary()

sql_varient        object                GetSqlValue()

timestamp          SqlBinary             GetSqlBinary()

uniqueidentifier   SqlGuid               GetSqlGuid() 
           
       
Related examples in the same category
1.Shows the SQL server types, the corresponding Sql types, and the GetSql*** methods used to read a column as the Sql type
www.java2java.com | Contact Us
Copyright 2009 - 12 Demo Source and Support. All rights reserved.
All other trademarks are property of their respective owners.