i'm creating a web browser using asp. This page has to have a link on it that grabs information from a database server on MS-SQL.
In the database I have created a stored procedure which i will call in the web page scripts. The stored procedure is a query where i have declared a start date and end date, and then i set both start and end dates to what i need and execute the stored procedure in SQL Query Analyzer. However, these dates have to now be changed by the user.
What the query does is give me a list of items in descending order from a specific date range. The user has to select (from the web page) what the start and end dates will be and how many items they want displayed.
QUESTION: How do I link this to the web browser so that when the user enters this criteria it will grab that particular query but only change the dates and how many items (i need a synatx for this to) are selected and then display the results?
i hope this is clear. thanks