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
<<<