SqlDataSource Input parameter
hi
I have created a sqlDataSource visually and would like to call the sqlDataSource with a button click event.
<asp:SqlDataSource ID="SqlDSExtract" runat="server" ConnectionString="<%$ ConnectionStrings:SUNDBSQL2005ConnectionString %>"
SelectCommand="spExtraction" SelectCommandType="StoredProcedure">
<SelectParameters>
<asp:ControlParameter ControlID="drpBeginDate" Name="BeginDate" PropertyName="SelectedValue"
Type="Int32" />
<asp:ControlParameter ControlID="drpEndDate" Name="EdnDate" PropertyName="SelectedValue"
Type="Int32" />
</SelectParameters>
</asp:SqlDataSource>
How do go about it? thanks
|