Link to home
Start Free TrialLog in
Avatar of TIC06
TIC06

asked on

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.
Avatar of TSmooth
TSmooth

Have you tried using a SQL Data Source that calls your stored procedure and then binding to that datasource?
ASKER CERTIFIED SOLUTION
Avatar of lunadl
lunadl
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial