Hay all

i want to query some data from a database, but not sure how to do it.

i have a Form with data bound to textBoxes. To do this i Configured a oleDbDataAdapter with the following SQL statement:

SELECT Address, DateOfBirth, DateOfEmployment, EmployeesID, FirstName, LastName, Notes, PhoneNumber, PostCode, Title
FROM Employees

all the above does is select and display all the fields from the employee Database

After configuring the oleDbDataAdapter i then generated a DataSet called objdsEmployee

The textboxes are bount to fields in the database:

Employee Database fields:

  • EmployeesID
    FirstName
    LastName
    Title
    DateOfBirth
    Address
    PostCode
    PhoneNumber
    DateOfEmployment
    Notes


All the above works fine but... i want to SELECT data WHERE the membersID is equla to TextBox1

im not sure how to do this could any 1 help?

thanks