Sledgie

Dahil sa gumagamit ka ng ibang database (MySQL) kailangan mong idownload yung driver nya (Go to MySQL website for the free downloads)

Then major revision yan almost everything sa code mo.

imports System.Data.MySQLClient

public class SomeMethod

Dim conn as new MySQLConnection("connection string here")

Dim dt as new DataTable

Dim da as MySQLDataAdapter

conn.open

da = new sqlDataAdapter("SQL Synatx here")

da.fill(dt)

dim ctr as integer

For Each dr As DataRow in dt.Rows

Arr_Enrollees(ctr,0) = dr.item("Field_Name").toString()

Arr_Enrollees(ctr,1) = dr.item("Field_Name").toString()

Next

End Class

pag nagaadd ka naman kailangan mong gumamit ng sqlCommand tapos

SQL DML statements INSERT INTO Table

Yun lang