0

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 by VB2008beginner: unclear

Attachments add_connection.jpg 204.75 KB form_1.jpg 193.82 KB
4
Contributors
5
Replies
6
Views
6 Years
Discussion Span
Last Post by lolafuertes
0

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...

0

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

Hope this helps

Edited by lolafuertes: n/a

This question has already been answered. 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.