Changing SQL Datasource stored procedure on button press
I have two different stored procedures i'd like to run to populate a datagrid. The first one as listed will run on start up and display all entries in a database. The 2nd one i want to only run on a button press, which shows only specific entries. Running them both like this may not be the best idea, but I've tried a few different things and no luck so far. Any advice?
SelectCommand="DevRequestHistory_SEL2" SelectCommandType="StoredProcedure" />
SelectCommand="DevRequestHistory_SEL" SelectCommandType="StoredProcedure" />
Khargesh RajputPosted Dec 12, 2014, 6:37 AM
or pass the parameteres in stored procedure
when populate datagrid on button press