Best practise for multiple inputs for SQL criteria

[SaturnSeven]

I'm just starting out with ASP.net
I managed to get a single text box, a SQLDataSource and Gridview working together i.e. enter a value and the Gridview reflects the input and the SQL

<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStringsBConnectionString %>"

SelectCommand="SELECT [field1] AS Field1, [field2] AS Field2, FROM

WHERE ([field1] = @Field1)">

<SelectParameters>
<asp:ControlParameter ControlID="txtInput" Name="Field1" PropertyName="Text" Type="String" />
</SelectParameters>
</asp:SqlDataSource>

But how do I set say 4 text boxes for various criteria? But so that the gridview works if any if the text boxes are entered and not all of them

Any guidence or examples would be great

 

[ca8msm]

You can use what I call optional parameters.


-------------------------------------------------------

Mark,
[URL unfurl="true"]http://aspnetlibrary.com[/url]
[URL unfurl="true"]http://mdssolutions.co.uk[/url] - Delivering professional ASP.NET solutions
[URL unfurl="true"]http://weblogs.asp.net/marksmith[/url]

 

[ca8msm]

SaturnSeven, did this help solve your problem?


-------------------------------------------------------

Mark,
[URL unfurl="true"]http://aspnetlibrary.com[/url]
[URL unfurl="true"]http://mdssolutions.co.uk[/url] - Delivering professional ASP.NET solutions
[URL unfurl="true"]http://weblogs.asp.net/marksmith[/url]