Tim Tutten

Tim Tutten

  • NA
  • 1
  • 940

Changing SQL Datasource stored procedure on button press

Dec 9 2014 9:07 AM

 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?
<asp:SqlDataSource ID="sqlDevRequestHistory" runat="server" ConnectionString="<%$ ConnectionStrings:TrackIt %>"
SelectCommand="DevRequestHistory_SEL2" SelectCommandType="StoredProcedure" />
<asp:SqlDataSource ID="SqlDevReqestHistory" runat="server" ConnectionString="<%$ ConnectionStrings:TrackIt %>"
SelectCommand="DevRequestHistory_SEL" SelectCommandType="StoredProcedure" />

Answers (1)