Example
Source
Run as client-side object
A simplifed search interface can be created using the
simpleSearchFilter
property which allows search criteria to be applied to multiple columns to give the best possible chance of finding a match
Register the component libraries
<%@ Register TagPrefix="DNL" Namespace="DbNetLink.Web.UI" Assembly="DbNetLink.DbNetGrid" %> <%@ Register TagPrefix="DNC" Namespace="DbNetLink.Web.UI" Assembly="DbNetLink.Common" %>
Server Control
<form id="Form1" name="Form1" method="post" runat="server"> <table> <tr> <td> <DNL:DbNetGrid id="customers" runat="server" ConnectionString = "samples" FromPart = "customers" SearchType="simple" > <SimpleSearchFilters> <DNC:SearchFilter Label="Contact Information" Filter="companyname like '%{token}%' or contactname like '%{token}%' or contacttitle like '%{token}%'"></DNC:SearchFilter> <DNC:SearchFilter Label="Phone/Fax Number" Filter="phone like '%{token}%' or fax like '%{token}%'"></DNC:SearchFilter> <DNC:SearchFilter Label="Address Information" Filter="address like '%{token}%' or city like '%{token}%' or region like '%{token}%' or country like '%{token}%'"></DNC:SearchFilter> </SimpleSearchFilters> </DNL:DbNetGrid> </td> </tr> </table> </form>