Member Avatar for student21

hi i was wondering if anyone could help me i have created a SELECT FROM WHERE query to perform a search here is my code

SELECT EmployeeID, DepartmentID, Forename, Surname, Role, Email, Telephone, Extension, Mobile, Photo FROM Employees
WHERE (Forename = ? or ? = '') and (Surname = ? or ? = '') and (Role = ? or ? = '')

i have then put the folllowing code to rung the query within my form

Me.EmployeesTableAdapter.FillByName(Me.myDataSet.Employees, Me.ForenameTextBox.Text, Me.ForenameTextBox.Text, Me.SurnameTextBox.Text, Me.SurnameTextBox.Text, Me.RoleTextBox.Text, Me.RoleTextBox.Text)

when i search by forename or surname it works fine but when i search by role i get this error..oledbException occured No value given for one or more required parameters.
i was wondering if anyone can see where im going wrong?

Edited by student21 because: n/a
  • 2 Contributors
  • 1 Reply
  • 100 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by culebrin
Member Avatar for culebrin

Uhmmmm well I don't see anything strange, maybe you can try with only one pair of parameters at a time

Edited by culebrin because: n/a
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.