none
Need Help with Web Expression and Access Query RRS feed

  • Question

  • I have a New Client Form

    which has a Text Box of

    Max House Price:<br />
            <asp:TextBox id="maxprice" runat="server" placeholder="House Price" autocomplete="off" Text='<%# Bind("propertyvalue2") %>' />

    And a Button that brings you into A Query Page that is done with Grid View with the following Query

    <asp:AccessDataSource ID="AccessDataSource1" runat="server"
            DataFile="~/estate.MDB.accdb"
            SelectCommand="SELECT * FROM [property] WHERE ([propertyvalue] &lt;= ?)">
            <SelectParameters>
                <asp:FormParameter FormField="maxprice" Name="propertyvalue2" Type="Int32" />
            </SelectParameters>
        </asp:AccessDataSource>
        <br />

    What i like to get done is if i Click on the Query Button it should give me a List of Houses with <= the Value i entered in..

    Thursday, March 22, 2012 8:55 PM

All replies

  • http://forums.asp.net

    Please remember to "Mark as Answer" the responses that resolved your issue. It is common courtesy to recognize those who have helped you, and it also makes it easier for visitors to find the resolution later.

    Thursday, March 22, 2012 10:37 PM