SqlDataSource 多条件或查询

Question

单个条件可以，多条件AND也可以执行，多条件或就没有数据显示。我需要的是两文本框一个按钮，哪个有输入条件查那个结果显示在“GridView1"。或许应该在按钮事件中写个IF ELSE，请教
<asp:GridView ID="GridView1" runat="server" DataSourceID="SqlDataSource1">
                    </asp:GridView>
                    <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:zlsConnectionString %>" SelectCommand="SELECT UserID, UserName, Address, WaterTabID FROM UserInfo WHERE ( UserID =@userid ) or ( WaterTabID = @WaterTabID )">
                        <SelectParameters>
                            <asp:ControlParameter ControlID="TextBox1" Name="UserID" PropertyName="Text" Type="string " />
                            <asp:ControlParameter ControlID="TextBox2" Name="WaterTabID" PropertyName="Text" Type="string "/>
                        </SelectParameters>
                    </asp:SqlDataSource>

Answer 1

SELECT   UserID,   UserName,   Address,   WaterTabID   FROM   UserInfo   WHERE   (   UserID   =@userid or   @userid =0)   or   (   WaterTabID   =   @WaterTabID   or @WaterTabID= 0)<SelectParameters> 
                                                        <asp:ControlParameter ..........  defaultValue="0"  /> 
                                                </SelectParameters>