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
Where (Forename=?) AND (Surname=?)
(Forname=?) and (?=")
(Surname=?) and (?=")
(?=") 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?