主题：sql与mysql 数据 同步问题

 方法一：用软件同步 http://www.foxtable.com/bbs/dispbbs.asp?BoardID=2&ID=35184&skin=0

 方法二：在foxtable里面，引用mysql.dll，通过写代码的方式，往msyql同步数据

Dim conn As MySql.Data.MySqlClient.MySqlConnection
Dim cmd As MySql.Data.MySqlClient.MySqlCommand
Dim sdr As MySql.Data.MySqlClient.MySqlDataReader

Dim connStr As String = "server=localhost; port=3306; user id=root; password=root; database=dbexhibitionprinter"
conn = New MySql.Data.MySqlClient.MySqlConnection(connStr)
conn.Open

Dim dt As new System.Data.DataTable
cmd = new MySql.Data.MySqlClient.MySqlCommand("select * f rom usersInfo", conn)
sdr = cmd.ExecuteReader()

conn.close

下载信息  [文件大小：89.2 KB  下载次数：9]

点击浏览该文件:mysql.data.rar