Parametrise stored procedure
-
:confused:Hi guys can you please help me My problem is i made an parameterise stored procedure (Select Query) i want to use it in vb to show the data of that stored procedure(Select Query)on ListView control using Adodb.RecordSet can any one help me regarding this My Stored Procedure is as follow on Table1 Procedure Name "Test" Syntex "Select @PN as PN ,@VA As VA, Table1.* FROM dbo.Table1" Parameters are @PA and @VA i am trying it by using recordset if you have any other idea please give me. Thanks Sasmi
-
:confused:Hi guys can you please help me My problem is i made an parameterise stored procedure (Select Query) i want to use it in vb to show the data of that stored procedure(Select Query)on ListView control using Adodb.RecordSet can any one help me regarding this My Stored Procedure is as follow on Table1 Procedure Name "Test" Syntex "Select @PN as PN ,@VA As VA, Table1.* FROM dbo.Table1" Parameters are @PA and @VA i am trying it by using recordset if you have any other idea please give me. Thanks Sasmi
The SELECT statement won't work, if I uderstand what your trying to do. There's isn't enough detail in your question to determine this! If you're looking to return a record or filtered set of records, it might look something like this
SELECT PN, VA FROM Table1 WHERE PN=@PN AND VA=@VA
If you're looking to return all the data in those two columns in Table1, then no parameters are necessary:
SELECT PN, VA FROM Table1
Dave Kreskowiak Microsoft MVP - Visual Basic