im trying to retrieve all the email address's from my db ad put them into a array, for ms access i always used a object reader, not as simple on mysql!!!
VB.NET:
Public Sub retrieveAddress()
Dim address As String
Dim myCommand As New MySqlCommand
Dim myReader As MySqlDataReader
Dim strSQL As String
strSQL = "SELECT EmailAddress FROM tblmember"
'conn.ConnectionString = strSQL
conn.Open()
myCommand.Connection = conn
myCommand.CommandText = strSQL
myReader = myCommand.ExecuteReader
While myReader.Read
address = myReader.GetName(2)
MsgBox(address)
End While
If conn.State <> ConnectionState.Closed Then conn.Close()
' SendEmailMerge()
End Sub