Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

procedure expect parameter which was not suplied

jeff020590jeff020590 Member Posts: 2
hello, is anyone can help me with this kind of error...!

here's my Procedure
>>
ALTER PROCEDURE procgetproduct_jc
(@ProductID INT)
As
BEGIN
SELECT *
FROM tblProducts
WHERE ProductID= @ProductID;
End;
<<

and here's my code in vb.net...

>>
Public Function GetProduct(ByVal ProductID As Integer) As DataSet
Dim ds As DataSet = Nothing
Dim cmd As IDbCommand
Dim strSQL As String

strSQL = "procgetproduct_jc"
ds = DataLayer.GetDataSet(strSQL, mstrConnectString)

Validate()
cmd = DataLayer.CreateCommand(strSQL, mstrConnectString)
ds = DataLayer.GetDataSet(strSQL, mstrConnectString)
cmd.CommandType = CommandType.StoredProcedure
FillInParameters(cmd)

Return DataLayer.GetDataSet(strSQL, mstrConnectString)
End Function

<<<

Sign In or Register to comment.