searching in ms-access using visual basic

Discussion in 'Programming' started by titan497, Apr 15, 2008.

  1. #1
    hi,
    i am trying to write an application which will get the details of employees from an access database. im using vb as front end. can somebody help me with the code to search the access database using vb. if i give the employee number in the search box then all the details about that particular employee should come. i am using adodc for database connectivity. can somebody help me with the code???
     
    titan497, Apr 15, 2008 IP
  2. it career

    it career Notable Member

    Messages:
    3,562
    Likes Received:
    155
    Best Answers:
    0
    Trophy Points:
    270
    #2
    Who has coded database scripts? it would be as simple as "select * from employee where employeeid='<id>';
     
    it career, Apr 16, 2008 IP
  3. titan497

    titan497 Peon

    Messages:
    15
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    but im not using sql server. im using access. will select * ... work for access??
     
    titan497, Apr 16, 2008 IP
  4. it career

    it career Notable Member

    Messages:
    3,562
    Likes Received:
    155
    Best Answers:
    0
    Trophy Points:
    270
    #4
    Yes the syntax is quite simmilar.
     
    it career, Apr 16, 2008 IP