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
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 Control | DNN KickStart Field type | .NET Framework | SQL Server | ADO DataType Enum | ADO DataType Enum Value | Size | Access | Oracle | Visual Basic 6.0 |
---|---|---|---|---|---|---|---|---|---|
Int64 SqlDbType.BigInt OleDbType.BigInt | bigint | adBigInt | 20 | 8 | Variant | ||||
Byte[] SqlDbType.VarBinary OleDbType.Binary | binary timestamp | adBinary | 128 | 50 8 | Raw | Variant | |||
Yes/No | Boolean SqlDbType.Bit OleDbType.Boolean | bit | adBoolean | 11 | 1 2 | YesNo | Boolean | ||
String OleDbType.BSTR | adBSTR | 8 | |||||||
(DataReader) | adChapter | 136 | |||||||
Text Document | String SqlDbType.Char OleDbType.Char | char | adChar | 129 | X | Char | String | ||
Money | Decimal SqlDbType.Money OleDbType.Currency | money smallmoney | adCurrency | 6 | 8 4 0 | Currency | Currency | ||
DateTime OleDbType.DBDate | adDate | 7 | 0 | DateTime | Date | ||||
DateTime OleDbType.DBDate | adDBDate | 133 | |||||||
DBFileTime | adDBFileTime | 137 | |||||||
DateTime OleDbType.DBTime | adDBTime | 134 | |||||||
Date Time | DateTime SqlDbType.DateTime OleDbType.DBTimeStamp | datetime smalldatetime | adDBTimeStamp | 135 | 8 4 0 | DateTime | Date | Date | |
Decimal OleDbType.Decimal | adDecimal | 14 | Decimal | Variant 6 | |||||
Double SqlDbType.Float OleDbType.Double | float | adDouble | 5 | 8 0 | Double | Float | Double | ||
Empty | adEmpty | 0 | |||||||
External-Exception OleDbType.Error | adError | 10 | |||||||
DateTime OleDbType.Filetime | adFileTime | 64 | |||||||
Guid SqlDbType.UniqueIdentifier OleDbType.Guid | uniqueidentifier | adGUID | 72 | 16 | ReplicationID | Variant | |||
Object OleDbType.IDispatch | adIDispatch | 9 | |||||||
Identifier Number | Int32 SqlDbType.Int OleDbType.Integer | identity int | adInteger | 3 | 4 4 | AutoNumber Long Integer | Int | Long | |
Object OleDbType.IUnknown | adIUnknown | 13 | |||||||
Byte[] SqlDbType.VarBinary OleDbType.LongVarBinary | image | adLongVarBinary | 205 | 2147483647 | OLEObject | Long Raw Blob | Variant | ||
String SqlDbType.VarChar OleDbType.LongVarChar | text | adLongVarChar | 201 | 2147483647 | Memo Hyperlink | Long Clob | String | ||
String SqlDbType.NText OleDbType.VarWChar | ntext | adLongVarWChar | 203 | 1073741823 | Memo Hyperlink | NClob | String | ||
Decimal SqlDbType.Decimal OleDbType.Decimal | decimal numeric | adNumeric | 131 | 9 | Decimal | Decimal Integer Number SmallInt | Variant | ||
Object OleDbType.PropVariant | adPropVariant | 138 | |||||||
Single SqlDbType.Real OleDbType.Single | real | adSingle | 4 | 4 | Single | Single | |||
Int16, SqlDbType.SmallInt OleDbType.SmallInt | smallInt | adSmallInt | 2 | 2 | Integer | Integer | |||
Byte OleDbType.TinyInt | adTinyInt | 16 | |||||||
UInt64 OleDbType.UnsignedBigInt | adUnsignedBigInt | 21 | |||||||
UInt32 OleDbType.UnsignedInt | adUnsignedInt | 19 | |||||||
UInt16 OleDbType.UnsignedSmallInt | adUnsignedSmallInt | 18 | |||||||
Byte SqlDbType.TinyInt OleDbType.UnsignedTinyInt | tinyInt | adUnsignedTinyInt | 17 | 1 | Byte | Byte | |||
adUserDefined | 132 | ||||||||
Byte[] SqlDbType.VarBinary OleDbType.VarBinary | varbinary | adVarBinary | 204 | 50 | ReplicationID | Variant | |||
String SqlDbType.VarChar OleDbType.VarChar | varchar | adVarChar | 200 | X | Text | VarChar | String | ||
Object SqlDbType.Variant OleDbType.Variant | sql_variant | adVariant | 12 | 8016 | VarChar2 | Variant | |||
OleDbType.VarNumeric | adVarNumeric | 139 | |||||||
String SqlDbType.NVarChar OleDbType.VarWChar | nvarchar | adVarWChar | 202 | X | Text | NVarChar2 | String | ||
String SqlDbType.NChar OleDbType.WChar | nchar | adWChar | 130 | X | String |
No comments:
Post a Comment