'System.Data.Sq lDbType' cannot be converted

[patrick]

I have tried using 2 type systems to get this to compile but it still gets
the same error:

Public MustInherit Class _Applications
Private _AppID As System.Decimal
Private _AppPosition As System.Decimal
Private _AppCompany As System.Decimal
Private _AppWhen As System.DateTime
Private _AppType As System.String
Private _AppNotes As System.String
Private _RowVersion As System.Byte()
Private _isNew As Boolean

#Region " Constructors "
Public Sub New()
_AppID = SqlDbType.Decim al
* _AppWhen = SqlDbType.Small DateTime (this line)
_AppType = SqlDbType.VarCh ar
_AppNotes = SqlDbType.VarCh ar
* _RowVersion = SqlDbType.Times tamp (and this line)
End Sub
.....
end Class

ERROR:
_Applications.v b(50): Value of type 'System.Data.Sq lDbType' cannot be
converted to 'Date'.

In the SQL Server database they are both smalldatetime fields.

[Bob]

Hi,
_AppWhen is declared as a date,
_AppWhen = SqlDbType.Small DateTime is trying to assign an integer ( the
enum 'SmallDateTime' ) to the date.
If you try _AppWhen = 15 (The 'value' of SmallDateTime) you will get the
same error.
Hope this helps
regards
Bob

"patrick" <pa*****@discus sions.microsoft .com> wrote in message
news:4A******** *************** ***********@mic rosoft.com...

I have tried using 2 type systems to get this to compile but it still gets
the same error:

Public MustInherit Class _Applications
Private _AppID As System.Decimal
Private _AppPosition As System.Decimal
Private _AppCompany As System.Decimal
Private _AppWhen As System.DateTime
Private _AppType As System.String
Private _AppNotes As System.String
Private _RowVersion As System.Byte()
Private _isNew As Boolean

#Region " Constructors "
Public Sub New()
_AppID = SqlDbType.Decim al
* _AppWhen = SqlDbType.Small DateTime (this line)
_AppType = SqlDbType.VarCh ar
_AppNotes = SqlDbType.VarCh ar
* _RowVersion = SqlDbType.Times tamp (and this line)
End Sub
....
end Class

ERROR:
_Applications.v b(50): Value of type 'System.Data.Sq lDbType' cannot be
converted to 'Date'.

In the SQL Server database they are both smalldatetime fields.