displaying records from SQL SERVER database by typing a letter in text field

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Manzi
    New Member
    • Dec 2012
    • 3

    displaying records from SQL SERVER database by typing a letter in text field

    I want to display records beginning by a specif letter by typing it in the textbox but I don't know the codes
    Some one can help me?
  • debasisdas
    Recognized Expert Expert
    • Dec 2006
    • 8119

    #2
    you need to implement the pattern matching in the search code using LIKE operator and call the same in the textbox_change( ) event.

    for search code
    1. connect to database.
    2. open the record set.
    3. then implement the search using dynamic SQL and display the result in some control like list box or grid.

    Comment

    Working...