Finding Matching Records in Data Access Pages - Using a textbox to find matching records

(Page 2 of 4 )

Create a TestEmployees.htm DAP

The design view of the Employees table is shown in the following picture.

The DAP is created using the "Create data access page by using wizard" shortcut in the DapCntrls database which has just one table called "Employees." The fields listed below were chosen from among the various fields (Columns) present. There was no particular reason for this choice.

• EmployeeID
• LastName
• FirstName
• BirthDate
• Country

Design View of TestEmployees.htm

This created page, "TestEmployees.htm," is shown in design view together with its "FieldList" as shown in the next picture.

Now add a textbox control from the "Tools" to the "Section: HeaderEmployees" just below the Employee information as shown in the next picture. The picture also shows the textbox's ID being changed to "IdEmp." The textbox's label was changed to "Search by EmployeeID." Now when it is properly coded, when you view this page, type in a number and step out, the Employee information displayed should reflect the EmployeeID you typed into this box.

Next: The code page and the code to search the EmployeeID >>
 

More Database Code Articles
More By Jayaram Krishnaswamy

Comments On: Finding Matching Records in Data Access Pages

· Implementing parametric queries using DAPs as discussed in an earlier tutorial...    · I found the above article exactly what I was looking for. However on page 3 of the...    · thanks for your best articlebut what is your following source code? :-)    · if so, could you please pass it on?thanks,m    · did you ever find the code?    · I was also unable to find the code you referred to on page 3. Am I overlooking...    · No, I never heard from the author nor have I ever found the source code....    · This Topic does not provide stifaction for the reader. It's doesn't contain complete...    · Haha, the code is in the article without the html characters being escaped so it...    · Hopefully this works. You can also view source to see it.   >>> Post your comment now!