ASP.net Populating the GridView from data from a Stored Procedure
I am programming in ASP.Net and my form is just a search in the database that returns data to a gridview. I am using a stored procedure that that assembles the sql statemnet based on the parameters and excutes that SQL. The last line of the Stored Procedure is EXEC(@SQL). @SQL is just a varaible that contains the full select statement based on user options. The problem that I am having is that I donot know how to populate the gridview with the data from the stored procedure.