0

hey,
im wondering what is the best way to go about creating queries...
my program.. i am creating a staff search program, i have craeted my databse and have included queries in access. but imnot sure how to call them in vb.net wondering if anyone can help me on that...
the alternative is i have made a query in vb.net
select Forname, surename, role, telephone, department
from Employees
Where (Forename=?) AND (Surname=?)
OR
(Forname=?) and (?=")
OR
(Surname=?) and (?=")
OR
(?=") and (?=")

and then im my code i have _search results=me.employees_tableAdapter.GetDataBy(me.forenameTextBox.Text, me.SurnameTextBox.Text)
i get this error message Argument not specified for Paramter 'Surname2' of 'Public Overridable Overloads Function GetDataBy (Forename as string, surname as string, forname1 as string, surname1 as string, surname2 as string) as companydataset.employeesdatatable

does anyone know where im going wrong and how to fix it?

3
Contributors
2
Replies
3
Views
7 Years
Discussion Span
Last Post by me655321
0

Looks like there's no overloaded version of the GetDataBy function that takes only 2 parameters(which is what you're trying to give it).

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.