Monthly Archives: June 2008

Calling postback event from Javascript

SOURCE : http://www.dotnetspider.com/resources/1521-How-call-Postback-from-Javascript.aspx
Introduction
Postback is a concept introduced in ASP.NET and is a very handy method. Postback is built into the ASP.NET and most of the web controls support it without writing any code.
Calling postback event from Javascript
There may be some scenario where you may want to explicitly postback to the server using some clientside javascript. [...]

Correlated Joins Using ‘Apply’

SOURCE: http://www.sqlservercentral.com/articles/T-SQL/63115/

One of my cohorts came to me a while back with a SQL Query challenge. He was creating a report for our Live Voice call center application in which he needed to list all Live Voice Transactions within a given date range (easy stuff so far).
The business rules, however, dictate that a Live Voice [...]

Data Type Mapping

Mapping data types into different environments like .Net and SQL server.

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

and the Managed Extensions for C++. The table also includes entries for the Object and String classes, for which many languages have corresponding keywords.

Category
Class name
Description
Visual Basic data type
C# data type
Managed Extensions for C++ data type
JScript data type

Integer
Byte
An [...]