Often see many Web sites have a search function within the station, this is how to achieve?    If the ASP, Dreamweaver that soon will be realized.    It is ASP.NET, in part to a slight hand. 

  11.1 SELECT advanced search techniques 

  After the above sections of the study, the SELECT how many will get to know.    SELECT advanced search techniques, in fact nothing mysterious, pattern matching and the main use of the operator.    So here mainly on pattern-matching operator use. 

  Pattern matching operator LIKE, NOT LIKE commonly used in the fuzzy find, in its judgement of whether the format specified string matching.    LIKE View matching certain conditions for the record, NOT LIKE used to locate specific conditions does not match the record.    Can be used to string, text, date, etc. type enquiries. 

  1.    Percent%: to match any type and length of the characters. 

  For example: SELECT study notes FROM table WHERE study notes heading LIKE "Network%" 

  Enquiries of this study is to check notes to the table heading "network" notes the beginning of all learning, such as: network database ASP is passed, the development of mobile communications and network research. 

  For example: SELECT study notes FROM table WHERE study notes LIKE heading "%% ASP.NET" 
  For enquiries this is all heading includes "ASP.NET" the study notes. 

  2.    _ Underlined: single match any of the characters, used to restrict expression of the characters in length. 

  For example: SELECT study notes FROM table WHERE study notes heading LIKE "V_ Development Featured" 
  This query is similar to that for "Featured VB development", "Featured VC development," the title of this study notes. 

  3.    In [brackets]: designated characters, or strings of the matching requirements for their object of one. 

  11.2 points in the realization of search functions 

  SELECT introduced advanced search techniques, will be on station search function can be achieved.    Here Percent% only been in use for pattern matching operators. 

  (1) Open dkblog.dwt.aspx template, insert forms for id = "gofrm" action ".. / dkgo.aspx" method "POST"; insert text box, located ID = "dkgotxt"; Insert the button "search" with the result shown in Figure 11-1. 
  (2) preserving template dkblog.dwt.aspx update all pages. 
  (3) Create a dynamic ASP.NET VB blank page, and save it as a dkgo.aspx.    Ztre added data sets, and its settings shown in Figure 11-2. 

  Figure 11-1 add the form controls 

  Figure 11-2 add data sets Ztre 

  (4) Click on the "Advanced" button, the SQL command: 

  SELECT * FROM ZT ORDER BY ZITIME DESC 

  Read: 

  SELECT * FROM ZT WHERE ZTNAME LIKE '% "Request.Form (" dkgotxt ")"%' ORDER BY ZITIME DESC 

  The results shown in Figure 11-3. 

  Figure 11-3 on the revised data sets Ztre 

  (5) dkgo.aspx page design, bind text to the dynamic pages, design important region, the results shown in Figure 11-4. 

  Figure 11-4 on the Page Setup dkgo.aspx 

  Setting up details can refer to the relevant settings index.aspx.