Int32 and System.Data.SqlTypes.SqlInt32

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Meng Soon Chua - 12 Jul 2007 08:20 GMT

Hi all,

Is there any difference by declaring a variable to be Integer, Int32 or
System.Data.SqlTypes.SqlInt32 ?

Example
Dim intNumberOfTries As Integer
or
Dim intNumberOfTries As Int32
or
Dim System.Data.SqlTypes.SqlInt32

Thank you for your time.

Best regards,
Meng Soon Chua

Reply to this Message

Göran Andersson - 12 Jul 2007 09:55 GMT

> Hi all,
>
[quoted text clipped - 12 lines]
> Best regards,
> Meng Soon Chua

Integer is the exact same type as System.Int32.

The System.Data.SqlTypes.SqlInt32 type also can handle null values, so
that is pretty much like Nullable(Of Integer).

Signature

Göran Andersson
_____
http://www.guffa.com

Reply to this Message

Meng Soon Chua - 12 Jul 2007 12:56 GMT

Hi Göran

Thank you for your response. I learned something new today :-D

Best regards,
Meng Soon Chua

> > Hi all,
> >
[quoted text clipped - 17 lines]
> The System.Data.SqlTypes.SqlInt32 type also can handle null values, so
> that is pretty much like Nullable(Of Integer).

Reply to this Message

Göran Andersson - 12 Jul 2007 19:05 GMT

> Hi Göran
>
> Thank you for your response. I learned something new today :-D
>
> Best regards,
> Meng Soon Chua

Me too. I never really looked at the System.Data.SqlTypes.SqlInt32 data
type before. I don't really know if I ever will have any more use of
this knowledge, though... :)

Signature

Göran Andersson
_____
http://www.guffa.com

Reply to this Message

Int32 and System.Data.SqlTypes.SqlInt32

Free Magazines