Pages

Thursday, September 6, 2012

For Auto ShutDown And Building Web Applications

http://www.codeproject.com/Articles/374194/AutoShut-my-first-program-in-Csharp

http://dabbu-csharphelp.blogspot.in/2012_04_01_archive.html

For Building Web Applications
http://imar.spaanjaars.com/416/building-layered-web-applications-with-microsoft-aspnet-20-part-1

Data Type Mapping
Mapping data types into different environments like .Net and SQL server.
http://www.frentonline.com/Knowledgebase/MSSQLServer/Datatype/tabid/362/Default.aspx
 ASP.NET ControlDNN KickStart Field type.NET
Framework
SQL
Server 
ADO
DataType
Enum
ADO
DataType
Enum
Value
SizeAccessOracleVisual
Basic
6.0
Int64
SqlDbType.BigInt
OleDbType.BigInt
 bigintadBigInt208Variant
Byte[]
SqlDbType.VarBinary
OleDbType.Binary
 binary
timestamp
adBinary12850
8
RawVariant
Yes/No Boolean
SqlDbType.Bit
OleDbType.Boolean
bit adBoolean11
1
2
  YesNoBoolean
String
OleDbType.BSTR
adBSTR8
(DataReader)adChapter136
 Text
Document
String
SqlDbType.Char
OleDbType.Char
 charadChar129XCharString
 MoneyDecimal
SqlDbType.Money
OleDbType.Currency
money
smallmoney 
adCurrency68
4
0
 CurrencyCurrency
DateTime
OleDbType.DBDate
adDate7
0
 DateTimeDate
DateTime
OleDbType.DBDate
adDBDate133
DBFileTimeadDBFileTime137
DateTime
OleDbType.DBTime
adDBTime134
Date
Time 
DateTime
SqlDbType.DateTime
OleDbType.DBTimeStamp
 datetime
 smalldatetime
adDBTimeStamp1358
4
0
 DateTimeDateDate
Decimal
OleDbType.Decimal
adDecimal14DecimalVariant 6
Double
SqlDbType.Float
OleDbType.Double
 floatadDouble5
8
0
 DoubleFloatDouble
EmptyadEmpty0
External-Exception
OleDbType.Error
adError10
DateTime
OleDbType.Filetime
adFileTime64
Guid
SqlDbType.UniqueIdentifier
OleDbType.Guid
 uniqueidentifieradGUID7216 ReplicationIDVariant
Object
OleDbType.IDispatch
adIDispatch9
 Identifier
Number
Int32
SqlDbType.Int
OleDbType.Integer
 identity
int
adInteger34
4
 AutoNumber
Long Integer
IntLong
Object
OleDbType.IUnknown
adIUnknown13
Byte[]
SqlDbType.VarBinary
OleDbType.LongVarBinary
 imageadLongVarBinary2052147483647 OLEObjectLong Raw
Blob
Variant
String
SqlDbType.VarChar
OleDbType.LongVarChar
 textadLongVarChar2012147483647 Memo
Hyperlink
Long
Clob
String
String
SqlDbType.NText
OleDbType.VarWChar
 ntextadLongVarWChar2031073741823 Memo
Hyperlink
NClobString
Decimal
SqlDbType.Decimal
OleDbType.Decimal
 decimal
numeric
adNumeric1319
 DecimalDecimal
Integer
Number
SmallInt
Variant
Object
OleDbType.PropVariant
adPropVariant 138
Single
SqlDbType.Real
OleDbType.Single
 realadSingle 44 SingleSingle
Int16,
SqlDbType.SmallInt
OleDbType.SmallInt
 smallIntadSmallInt 22 IntegerInteger
Byte
OleDbType.TinyInt
adTinyInt 16
UInt64
OleDbType.UnsignedBigInt
 adUnsignedBigInt21
UInt32
OleDbType.UnsignedInt
adUnsignedInt 19
UInt16
OleDbType.UnsignedSmallInt
adUnsignedSmallInt 18
Byte
SqlDbType.TinyInt
OleDbType.UnsignedTinyInt
 tinyIntadUnsignedTinyInt 171
 Byte
Byte
adUserDefined 132
Byte[]
SqlDbType.VarBinary
OleDbType.VarBinary
 varbinaryadVarBinary 20450  ReplicationIDVariant
String
SqlDbType.VarChar
OleDbType.VarChar
 varcharadVarChar 200X TextVarCharString
Object
SqlDbType.Variant
OleDbType.Variant
 sql_variantadVariant 128016VarChar2Variant
OleDbType.VarNumericadVarNumeric 139
String
SqlDbType.NVarChar
OleDbType.VarWChar
 nvarcharadVarWChar 202X TextNVarChar2String
String
SqlDbType.NChar
OleDbType.WChar
 ncharadWChar 130XString

No comments:

Post a Comment