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.

Recommended Answers

>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

Jump to Post

All 5 Replies

>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

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.21 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.