VB.NET

Moderators: seancampbell
Number of threads: 4020
Number of posts: 10026

This Forum Only
Post New Thread
Single Post View       Linear View       Threaded View      f

Report
procedure expect parameter which was not suplied Posted by jeff020590 on 29 Jun 2012 at 12:24 AM
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

<<<




 

Recent Jobs

Official Programmer's Heaven Blogs
Web Hosting | Browser and Social Games | Gadgets

Popular resources on Programmersheaven.com
Assembly | Basic | C | C# | C++ | Delphi | Flash | Java | JavaScript | Pascal | Perl | PHP | Python | Ruby | Visual Basic
© Copyright 2011 Programmersheaven.com - All rights reserved.
Reproduction in whole or in part, in any form or medium without express written permission is prohibited.
Violators of this policy may be subject to legal action. Please read our Terms Of Use and Privacy Statement for more information.
Operated by CommunityHeaven, a BootstrapLabs company.