Search Panel

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Ali Rizwan
    Banned
    Contributor
    • Aug 2007
    • 931

    Search Panel

    Hi all,
    I want to make my search engine for my database system which will looks like as the windows.
    And i have done but i have don't know how can i make the detail view for that searches.

    For this purpose i have plot some listboxes indicating one for Name, second for the class, third for Phone No and last for his Roll No.
    How can i search for all contents in my databases for which starts with the word Muhammad or any string inputed by user.
    ANd one thing more
    When i click on the second item in list1 second item of list2 and 3 will also selected.

    Thanx
    Its urgent i have to do this in a few hours because i have just know that we have to submit our project tommorrow.
    And a lot of work is still pending.
    So please be quick.
    And a big
    Thanxxxxxxxxxxx xxxxxxxxxxxxxxx xxxxxxxxxxxxxxx xxxxxxxxxxxxxxx xxxxxxxxxxx
  • Killer42
    Recognized Expert Expert
    • Oct 2006
    • 8429

    #2
    Hi Ali.

    Sorry, it looks as though you didn't get the urgent response you were hoping for.

    If it's any help now, I think what you're looking for is the SQL Like operator. For example, the SQL syntax to search for all surnames starting with "RIZ" might be something like...

    SELECT * FROM MYTABLE WHERE SURNAME LIKE 'RIZ*'

    Comment

    Working...