G
Guest
Hi all,
I think I have data type problem when I tried to insert data into sql server
200.
The erroe message is like this:
system.invalidcastexception
data type DFlage char(1) in sql 2000,
DMI is depdent middile initial, char(1) in database
Sex is char(1) in database, but in web page, I have "choose", "F", "M" there
values.
Here is how I deal with in asp.net code which I don't know where I am wrong.
Public Function AddDependent(ByVal DFName As String, ByVal DMI As string,
ByVal DLName As String, _
ByVal Ssn As String, ByVal DSex As String, ByVal DSsn As String)
Dim pDFlag As SqlParameter = New SqlParameter("@DFlag", SqlDbType.Char, 1)
If DFlag Then
pDFlag.Value = "Y"
Else
pDFlag.Value = "N"
End If
myCommand.Parameters.Add(pDFlag)
Dim pDMI As SqlParameter = New SqlParameter("@MI", SqlDbType.Char, 1)
pDMI.Value = DMI
myCommand.Parameters.Add(pDMI)
Dim pDSex As SqlParameter = New SqlParameter("@sex", SqlDbType.VarChar, 5)
pDSex.Value = DSex
myCommand.Parameters.Add(pDSex)
I think I have data type problem when I tried to insert data into sql server
200.
The erroe message is like this:
system.invalidcastexception
data type DFlage char(1) in sql 2000,
DMI is depdent middile initial, char(1) in database
Sex is char(1) in database, but in web page, I have "choose", "F", "M" there
values.
Here is how I deal with in asp.net code which I don't know where I am wrong.
Public Function AddDependent(ByVal DFName As String, ByVal DMI As string,
ByVal DLName As String, _
ByVal Ssn As String, ByVal DSex As String, ByVal DSsn As String)
Dim pDFlag As SqlParameter = New SqlParameter("@DFlag", SqlDbType.Char, 1)
If DFlag Then
pDFlag.Value = "Y"
Else
pDFlag.Value = "N"
End If
myCommand.Parameters.Add(pDFlag)
Dim pDMI As SqlParameter = New SqlParameter("@MI", SqlDbType.Char, 1)
pDMI.Value = DMI
myCommand.Parameters.Add(pDMI)
Dim pDSex As SqlParameter = New SqlParameter("@sex", SqlDbType.VarChar, 5)
pDSex.Value = DSex
myCommand.Parameters.Add(pDSex)