Programming in Technology and Computer problems Posted January 4, 2012 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 TableYun lang
Programming
in Technology and Computer problems
Posted
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