Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
chobo
Starting Member
11 Posts |
 Posted - 2004-04-09 : 17:05:37
|
| I have created a form that contains a textbox (txtState), button (cmdRun), and listbox (lstResults). I want to use the txtState textbox to supply a parameter to a stored procedure named (test), and then execute the stored procedure by clicking the (cmdRun) button which will display the results in the lstResults listbox. I have looked around everywhere for a nice simple answer, but only seem to find complex answers. Could someone please provide a nice simple solution. Here is the code for my stored procedure. It's the ADO code that I am having a great deal of trouble with.create procedure "test" @s nvarchar(2)asselect states from customerswhere states = @s |
|
|
KnooKie
Aged Yak Warrior
623 Posts |
|
|
|
|
|
Passing Parameters to Stored Procedure using ADO