How to execute a stored procedure using ASP and passing a value to the stored proc
Posted on 2004-03-30
I'm really new to ASP and need to try to figure out how to do the following;
I have a stored procedure called "sp_intellisearch" located in SQL server. its basically a stored proc that joins mutliple tables and allow you to search using wildcard characters.
I need to make an ASP page that has
- one text box (search box)
- one search button (search button)
- one listbox (listed results)
- A user can type any character or string in the search box, lets say the user types character 'a' in the text box(search box) and then clicks on the search button. The 'a' gets passed to the stored procedure, the stored procedure ("sp_intellisearch") does its thing and all the returned results are listed in an listbox(listed results) on the ASP page.
can anyone provide a sample on how to do this?
again i have very knowledge in asp.
thanks in advance,