使用按钮更改SqlDataSource SelectCommand和SelectParameter

<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:YourConnectionString %>"
    SelectCommand="SELECT * FROM YourTable WHERE Column1 = @Param1">
    <SelectParameters>
        <asp:Parameter Name="Param1" Type="String" DefaultValue="InitialValue" />
    </SelectParameters>
</asp:SqlDataSource>

<asp:Button ID="Button1" runat="server" Text="Change Query" OnClick="Button1_Click" />

<script runat="server">
    protected void Button1_Click(object sender, EventArgs e)
    {
        SqlDataSource1.SelectCommand = "SELECT * FROM YourTable WHERE Column2 = @Param2";
        SqlDataSource1.SelectParameters["Param2"].DefaultValue = "NewValue";
    }
</script>