I have a drop down list on an ASPX form
At the moment data source is from MyTable in MyDatabase where Field2 (in MyTable) is equal to the contents of an ASP text box called TextBox1
Like this
<asp:AccessDataSource ID="AccessDataSource1" runat="server" DataFile="../MyDatabase.mdb" SelectCommand="SELECT [Field1] FROM [MyTable] WHERE ([Field2] = ?) ORDER BY [Field2]">
<SelectParameters><asp:controlparameter ControlID="asp_TextBox1" Name="Field2" PropertyName="Text" Type="Int32" /></SelectParameters></asp:AccessDataSource>
Ho w can I change this so that I have TWO CRITERIAS.
So I would like to filter the data (for example) by: Feld2 (in the database) is equal to the ASP textbox (TextBox1) – it’s already doing this bit and Feld3 (in the database) is equal to the ASP textbox (TextBox2)
This is rea ...
Go to the complete details ...