PreviousNext

Dynamically Create ASP Form from SQL Stored Procedure

by bill-s, 2013-07-20T08:15:09.000Z

The purpose of this small .aspx web app is to allow users to execute SQL Stored Procedures. It will build an input form to gather parameter information and return the results generated by the stored proc to a simple gridview or as an .xlsx file downloaded directly to the user’s PC. It allows developers to exclusively work in SQL. When the stored proc is complete, it can be made available for users to call by just calling the .aspx page and passing it the name of the Stored Proc. It was designed mainly to allow developers to create parameter-based queries in the form of SQL Stored Procedures and turn them directly over to users without any additional coding.

Read More