pls teach me how to add a SQL query in the form

[VB2008beginner]

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.

[pritesh2010]

see this link which gives the full tutorial of ADO.NET
http://www.java2s.com/Tutorial/VB/0480__Database-ADO.net/Catalog0480__Database-ADO.net.htm

[VB2008beginner]

see this link which gives the full tutorial of ADO.NET
http://www.java2s.com/Tutorial/VB/0480__Database-ADO.net/Catalog0480__Database-ADO.net.htm

I don't understand after visiting the site
Pls help me
Does it mean that I need to use ADO.net?
But, my textbook doesn't mention ADO.net

[kvprajapati]

>Does it mean that I need to use ADO.net?

ADO.NET is the core database integration class library and you must have to learn.

>my textbook doesn't mention ADO.net

That's true. Many text books uses simple, code less approach.

Take at look at this articles/blog posts :

1. http://msdn.microsoft.com/en-us/library/ms973824.aspx
2. http://www.startvbdotnet.com/ado/simplebinding.aspx
3. http://msdn.microsoft.com/en-us/library/h43ks021(VS.71).aspx

[VB2008beginner]

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

[lolafuertes]

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

Hope this helps