I have a stored procedure in SQL server which when exectuated returns a table of results. I would like to be able to pass in the parameters from a form into the stored procedures and then view the table of results in a html table when the submit button is clicked.

The parameters for my SQL statement are: -
@weekenddate1, @weekenddate2, @txtpub, @txtprice and @txtDescription

Can anyone help me write the asp code to pass these values into a form and return a table of results on a new html page.

My html form looks like the following: -
<form name="form1" method="post" action="">
<table width="52%" border="0">
<tr>
<td width="43%">FROM DATE</td>
<td width="57%"><input name="fromdate" type="text" id="fromdate"></td>
</tr>
<tr>
<td>TO DATE</td>
<td><input name="todate" type="text" id="todate"></td>
</tr>
<tr>
<td>PUBLICATION</td>
<td><input name="publication" type="text" id="publication"></td>
</tr>
<tr>
<td>PRICE</td>
<td><input name="price" type="text" id="price"></td>
</tr>
<tr>
<td>DESCRIPTION</td>
<td><input name="description" type="text" id="description"></td>
</tr>
<tr>
<td> </td>
<td><input name="VIEW_REPORT" type="submit" id="VIEW_REPORT" value="Submit">
<input name="CLEAR" type="reset" id="CLEAR" value="Reset"></td>
</tr>
</table>
</form>

I will be so so so so pleased if anyone is able to help me. My asp knowledge is minimal

Have you looked at:

www.macromedia.com/support/ultradev/database/create_asp_commands/create_asp_commands03.html