Error: Cast From String to type Integer not valid

[Michael]

I need some help. I have the following code:
cmSQL = New SqlCommand("nf_ AddPurchaseOrde r", cnSQL)
cmsql.CommandTy pe = CommandType.Sto redProcedure
cmsql.Parameter s.Add("@Purchas eOrderId", sqldbtype.varch ar, 10,
"OrderNo").Valu e = txtPONum.Text
cmsql.Parameter s.Add("@OrderDe sc", sqldbtype.VarCh ar , 50 ,
"OrderDesc").Va lue = txtOrderDescrip tion.text
cmsql.Parameter s.Add("@Supplie rId", sqldbtype.Int , "SupplierId").V alue =
s.SupplierId
Dim b as Program
b = cmbPrograms.Sel ectedItem
cmsql.Parameter s.Add("@Program Id", sqldbtype.Int , "ProgramId").Va lue =
b.ProgramId

When the code hits either the SupplierId or the ProgramId line I get the
following error:
Cast from String "SupplierId " to type 'Integer' is not valid
My problem is that the stored procedures parameters are Int, the values I'm
passing in are also Integers. So not sure where the heck this error is coming
from. Thanks for any help.
Michael Lee

[Cor Ligthert]

Michael,

VBNet has those nice conversions methods.

dim a as integer = Cint("1") is all you have to do to make from a string
containing only numbers and by instance decimal points a nice integer.

I hope this helps,

Corn

[Michael]

Hi Cor,
Thanks for the reply. I just found the problem, it was my mistake. If I
change the following code:
cmsql.Parameter s.Add("@Supplie rId", sqldbtype.Int , "SupplierId").V alue =
s.SupplierId
TO:
cmsql.Parameter s.Add("@Supplie rId", sqldbtype.Int). Value = s.SupplierId

It works fine. I had gotten the wrong overloaded method.
Thanks for the reply.
Michael

"Cor Ligthert" wrote:

Michael,

VBNet has those nice conversions methods.

dim a as integer = Cint("1") is all you have to do to make from a string
containing only numbers and by instance decimal points a nice integer.

I hope this helps,

Corn