Member Avatar for 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.

add_connection.jpg 204.75 KB form_1.jpg 193.82 KB
Edited by VB2008beginner because: unclear
  • 4 Contributors
  • 5 Replies
  • 207 Views
  • 2 Days Discussion Span
  • Latest Post Latest Post by lolafuertes
Member Avatar for 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

Member Avatar for 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...

Member Avatar for lolafuertes

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

Hope this helps

Edited by lolafuertes because: n/a
Be a part of the DaniWeb community

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