I add connections in server explorors. Then,
I use AdventureWorks Person.Contact to set up a query by searching peter and mary
,but how to add it on form 1 ?
and I type part of their names and by the way
how to link a "VB label of text" or two "variables" to the two query parameter?
when the competer need me to put the parameter from "Me.form 1.label 1", I type "mar" and "pete".
I need the tools for up-date, re-edit and save.

(query:)
SELECT ContactID, NameStyle, Title, FirstName, MiddleName, LastName, Suffix, EmailAddress, EmailPromotion, Phone,
PasswordHash, PasswordSalt, AdditionalContactInfo, rowguid, ModifiedDate
FROM Person.Contact
WHERE (LastName LIKE @Last_name + '%') AND (LastName LIKE @Last_name2 + '%')


How do I add to data set , data grid view or sth in order to show the query in the form
Pls help me
pls use simple English as i am foreign student.

Edited 6 Years Ago by VB2008beginner: unclear

Attachments add_connection.jpg 204.75 KB form_1.jpg 193.82 KB

I add connections in server explorors. Then,
I use AdventureWorks Person.Contact to set up a query by searching peter and mary
,but how to add it on form 1 ?
and I type part of their names and by the way
how to link a "VB label of text" or two "variables" to the two query parameter?
when the competer need me to put the parameter from "Me.form 1.label 1", I type "mar" and "pete".
I need the tools for up-date, re-edit and save.

(query:)
SELECT ContactID, NameStyle, Title, FirstName, MiddleName, LastName, Suffix, EmailAddress, EmailPromotion, Phone,
PasswordHash, PasswordSalt, AdditionalContactInfo, rowguid, ModifiedDate
FROM Person.Contact
WHERE (LastName LIKE @Last_name + '%') AND (LastName LIKE @Last_name2 + '%')


How do I add to data set , data grid view or sth in order to show the query in the form
Pls help me
pls use simple English as i am foreign student.

DO I need to buy ADO.net software or ADO.net is embedded in VB.net?
Pls help me...

ADO is part of the Visual Studio runtime and you don't need to buy it separately

Hope this helps

Edited 6 Years Ago by lolafuertes: n/a

This question has already been answered. Start a new discussion instead.