<div>
for the connection string see <a href="http://connectionstrings.com/sql-server-2008" rel="ugc">http://connectionstrings.com/sql-server-2008</a> 
I'm just putting in MyconnectionString below. 
 

<pre><code class="code-10 nolinks" id="code-275672">Dim conn as new SqlConnection (MyconnectionString)
conn.Open
 
dim cmd as new SqlCommand (&quot;Select Column1, Column2 from MyTable&quot;, conn)
dim R as SqlDataReader
R = cmd.ExecuteReader()
 
dim strCol1 as String, strCol2 as String
 
While R.Read()
 strCol1 = R.GetString(r.GetOrdinal(&quot;column1&quot;))
 strCol2 = R.GetString(r.GetOrdinal(&quot;column2&quot;))
 
 'Now do you email thing with them
Wend
 
r.Close
conn.Close
</code></pre>
</div>

<div>
I cannot tell if it works as there seems to be some problem with my connector string. Are you able to troubleshoot that, or must I start a separate question? 
 
I've put my code thusfar in - the error I get is: 
 
Unhandled Exception: System.ArgumentException: Requested value '{MySQL-API-QUOTE 
S}' was not found. 
&nbsp; &nbsp;at System.Enum.Parse(Type enumType, String value, Boolean ignoreCase) 
&nbsp; &nbsp;at MySql.Data.MySqlClient.MySqlConnectionStringBuilder.ConvertToDriverType(Ob 
ject value) 
&nbsp; &nbsp;at MySql.Data.MySqlClient.MySqlConnectionStringBuilder.SetValue(Keyword kw, O 
bject value) 
&nbsp; &nbsp;at MySql.Data.MySqlClient.MySqlConnectionStringBuilder.SetValue(String keywor 
d, Object value) 
&nbsp; &nbsp;at MySql.Data.MySqlClient.MySqlConnectionStringBuilder.set_Item(String keywor 
d, Object value) 
&nbsp; &nbsp;at System.Data.Common.DbConnectionStringBuilder.set_ConnectionString(String v 
alue) 
&nbsp; &nbsp;at MySql.Data.MySqlClient.MySqlConnectionStringBuilder..ctor(String connectio 
nString) 
&nbsp; &nbsp;at MySql.Data.MySqlClient.MySqlConnection.set_ConnectionString(String value) 
&nbsp; &nbsp;at MySql.Data.MySqlClient.MySqlConnection..ctor(String connectionString) 
&nbsp; &nbsp;at qrunner.Module1.Main() in C:\Documents and Settings\matthew.winter\My Docu 
ments\Visual Studio 2008\Projects\CSV Reader\qrunner\qrunner\Module1.vb:line 11 
 

<pre><code class="code-10 nolinks" id="code-275878">Imports MySql.Data.MySqlClient
 
Module Module1
 
 Sub Main()
 
 Dim conString As String = &quot;Driver={MySQL-API-QUOTES};Server=192.168.12.2;Database=quotes;User=***; Password=***;Option=3;&quot;
 Dim qryString As String = &quot;SELECT e_enquiry_no, e_salutation, e_email FROM removal WHERE ((e_enquiry_dt = DATE_SUB(CURDATE(), INTERVAL 1 MONTH)) or (e_enquiry_dt = DATE_SUB(CURDATE(), INTERVAL 2 MONTH)) or(e_enquiry_dt = DATE_SUB(CURDATE(), INTERVAL 3 MONTH)) or (e_enquiry_dt = DATE_SUB(CURDATE(), INTERVAL 4 MONTH)) or (e_enquiry_dt = DATE_SUB(CURDATE(), INTERVAL 5 MONTH)) or (e_enquiry_dt = DATE_SUB(CURDATE(), INTERVAL 6 MONTH)) or(e_enquiry_dt = DATE_SUB(CURDATE(), INTERVAL 7 MONTH)) or (e_enquiry_dt = DATE_SUB(CURDATE(), INTERVAL 8 MONTH)) or (e_enquiry_dt = DATE_SUB(CURDATE(), INTERVAL 9 MONTH)) or (e_enquiry_dt = DATE_SUB(CURDATE(), INTERVAL 10 MONTH)) or(e_enquiry_dt = DATE_SUB(CURDATE(), INTERVAL 11 MONTH)) or (e_enquiry_dt = DATE_SUB(CURDATE(), INTERVAL 12 MONTH))) AND e_h_quote_no = 0 AND e_estim_dt is NULL AND (e_move_dt &gt; CURDATE() OR e_move_dt is NULL)&quot;
 
 
 Dim conn As New MySql.Data.MySqlClient.MySqlConnection(conString)
 conn.Open()
 
 Dim cmd As New MySql.Data.MySqlClient.MySqlCommand(qryString, conn)
 Dim R As MySql.Data.MySqlClient.MySqlDataReader
 R = cmd.ExecuteReader()
 
 Dim strCol1 As String, strCol2 As String
 
 While R.Read()
 strCol1 = R.GetString(R.GetOrdinal(&quot;e_salutation&quot;))
 strCol2 = R.GetString(R.GetOrdinal(&quot;e_email&quot;))
 
 'Now do you email thing with them
 Dim message As System.Net.Mail.MailMessage
 Dim smtp As New System.Net.Mail.SmtpClient(&quot;smtp.anglopacific.co.uk&quot;, 25)
 Dim attach As System.Net.Mail.Attachment
 
 Dim sFrom As String, sTo As String, sSsub As String, sMsg As String
 
 Dim sFile As String
 
 sFrom = &quot;sender@ourdomain.co.uk&quot;
 
 sTo = &quot;me@myprivatedomain.co.uk&quot;
 
 sSsub = &quot;Your Enquiry for address &quot; &amp; strCol2 &amp; &quot; is overdue&quot;
 
 sMsg = &quot;This is a message about your enquiry &quot; &amp; strCol2
 
 message = New System.Net.Mail.MailMessage(sFrom, sTo, sSsub, sMsg)
 
 Try
 
 '
 
 'Send the mail message that was setup.
 
 smtp.Send(message)
 
 '
 
 'Usually it was successful in sending the message if it makes it to here
 
 'Otherwise it should throw a error message from the Catch exception below.
 
 'MessageBox.Show(&quot;Well, the mail message appears to have been a success!&quot;, &quot; Successful?&quot;, MessageBoxButtons.OK, MessageBoxIcon.Information)
 
 Console.WriteLine(&quot;ok&quot;)
 
 Catch exc As Net.Mail.SmtpException
 
 'MessageBox.Show(exc.StatusCode.ToString, &quot; Something Happened?&quot;, MessageBoxButtons.OK, MessageBoxIcon.Error)
 
 Console.WriteLine(exc.StatusCode.ToString)
 
 End Try
 
 End While
 
 R.Close()
 conn.Close()
 
 
 
 End Sub
 
End Module
</code></pre>
</div>

<div>
Thanks so much - awesome expert-ing :)
</div>

<div>
<div class="content wysiwyg-content">
Hi, 
 
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 &quot;column1&quot; beginning with &quot;Dear column2&quot; 
 
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? 
 
Thanks.
</div>
</div>

Hi,

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?

Thanks.

Read a MySQL query in Visual Basic 2008

Most development for the Microsoft platform is done utilizing the technologies supported by the.NET framework. Other development is done using Visual Basic for Applications (VBA) for programs like Access, Excel, Word and Outlook, with PowerShell for scripting, or with SQL for large databases.

Microsoft Development

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.