troubleshooting Question

Read a MySQL query in Visual Basic 2008

Avatar of MDWinter
MDWinter asked on
Microsoft DevelopmentMySQL Server
5 Comments2 Solutions1337 ViewsLast Modified:

I have downloaded visual basic express 2008.

We have a mysql database that contains the information I need.

I want my (console) app to connect to the database with the correct credentials and execute a query.

One of the columns in my query contains an email address - I want to 'loop' through the results and for each line send an email, addressed to "column1" beginning with "Dear column2"

Actually sending the email isn 't that difficult - but can anyone post some reasonably 'idiot-proof' instruction on how to handle the sql connection / send the query / use the data?

Daniel Wilson

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 2 Answers and 5 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 5 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros