access and grindview

Question

User1850860713 posted

What is the simpliest way to make a search engine to rearch 3 or 4 fields in a grind view --  there are so many toturials  but i alwasy get lost

i want a simple  search engine -  the database is access and is in vb.net

this is the grindview

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"  AllowSorting="True"
        DataKeyNames="Photo_ID" DataSourceID="SqlDataSource1">
        <Columns>
            <asp:BoundField DataField="Photo_Title" HeaderText="Title"
                SortExpression="Photo_Title" />
            <asp:BoundField DataField="Photo_Category" HeaderText="Category"
                SortExpression="Photo_Category" />
            <asp:ImageField DataImageUrlField="Photo_Image" HeaderText="Thumbnail">
                <ControlStyle Height="100px" Width="100px" />
            </asp:ImageField>
            <asp:HyperLinkField DataNavigateUrlFields="Photo_ID"
                DataNavigateUrlFormatString="details.aspx?Photo_ID={0}" Text="more details" />
        </Columns>
    </asp:GridView>
    <asp:SqlDataSource ID="SqlDataSource1" runat="server"
        ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
        ProviderName="<%$ ConnectionStrings:ConnectionString.ProviderName %>"
        SelectCommand="SELECT * FROM [Photo]"></asp:SqlDataSource>

Answer 1

User-821857111 posted

Like this: http://www.mikesdotnetting.com/Article/68/An-ASP.NET-Search-Engine-with-MS-Access-for-optional-search-criteria

Answer 2

User3866881 posted

What is the simpliest way to make a search engine to rearch 3 or 4 fields in a grind view

Hi：）

Do you mean you want to dynamially create filtering condition by dynamically adding fields？Or something else？

Sorry I didn't catch you well……