Stored Procedure

[Kev]

Can anyone help me determine why I am getting the error "Object must
implement IConvertible" when I execute the stored procedure? The
exception is InvalidCastExce ption. Below is the code. I have checked
the stored procedure, database table column datatype and the sqldbtype
and they are identical. The only thing that is not the same is the
datatype of the @col1 and @col2 parameter in the server explorer where
it is shown as "adnumeric" , not sure if that is a problem or not. So I
am a little lost here. Any assistance is greatly appreciated.:

objConn.open
objCom = New SqlCommand("UPL OAD_A", objConn)
objCom.CommandT ype = CommandType.Sto redProcedure

With objCom.Paramete rs
..Add("@col1", SqlDbType.Decim al, 9)
..Add("@col2", SqlDbType.Decim al, 5)
..Add("@col3", SqlDbType.VarCh ar, 6)
..Add("@Count", SqlDbType.Int)
End With

With objCom
..Parameters("@ col1").Value = dt.Columns(0)
..Parameters("@ col1").Precisio n = 11
..Parameters("@ col1").Scale = 2
..Parameters("@ col2").Value = dt.Columns(1)
..Parameters("@ col2").Precisio n = 5
..Parameters("@ col2").Scale = 4
..Parameters("@ col3").Value = dt.Columns(2)
..Parameters("@ Count").Directi on = ParameterDirect ion.Output
End With

If objCom.ExecuteN onQuery() > 0 Then
'uploaded records
Dim iCount As Integer
iCount = objCom.Paramete rs("@Count").Va lue
Console.WriteLi ne(iCount)
Console.ReadLin e()
Return True
Else
Return False
End If

[Bill Borg]

Kev, you are assigning *datacolumns* to your parameter values, when what you
need is the *data* in those datacolumns, converted to your decimal, string,
etc. Because the parameters collection takes only generic objects, the system
can't catch this till you run it.

Bill

"Kev" wrote:

Can anyone help me determine why I am getting the error "Object must
implement IConvertible" when I execute the stored procedure? The
exception is InvalidCastExce ption. Below is the code. I have checked
the stored procedure, database table column datatype and the sqldbtype
and they are identical. The only thing that is not the same is the
datatype of the @col1 and @col2 parameter in the server explorer where
it is shown as "adnumeric" , not sure if that is a problem or not. So I
am a little lost here. Any assistance is greatly appreciated.:

objConn.open
objCom = New SqlCommand("UPL OAD_A", objConn)
objCom.CommandT ype = CommandType.Sto redProcedure

With objCom.Paramete rs
..Add("@col1", SqlDbType.Decim al, 9)
..Add("@col2", SqlDbType.Decim al, 5)
..Add("@col3", SqlDbType.VarCh ar, 6)
..Add("@Count", SqlDbType.Int)
End With

With objCom
..Parameters("@ col1").Value = dt.Columns(0)
..Parameters("@ col1").Precisio n = 11
..Parameters("@ col1").Scale = 2
..Parameters("@ col2").Value = dt.Columns(1)
..Parameters("@ col2").Precisio n = 5
..Parameters("@ col2").Scale = 4
..Parameters("@ col3").Value = dt.Columns(2)
..Parameters("@ Count").Directi on = ParameterDirect ion.Output
End With

If objCom.ExecuteN onQuery() > 0 Then
'uploaded records
Dim iCount As Integer
iCount = objCom.Paramete rs("@Count").Va lue
Console.WriteLi ne(iCount)
Console.ReadLin e()
Return True
Else
Return False
End If