Dim conn As My Sql.Data.MySq lClient.MyS qlConnection
Dim cmd As My Sql.Data.MySqlC lient.MyS qlCommand
Dim connStr As String = "server=1.1.1.1.1; port=3306; user id=root; password=1234; database=ipos;CharSet=utf8" '设置你的数据库连接字符串
conn = New MySql.Data.MyS qlClient.MySqlConne ction(connStr)
conn.Open
Dim dr As DataRow
For i As Integer = DataTables("ddyg").DataRows.Count - 1 To 0 Step -1
dr = DataTables("ddyg").DataRows(i)
If DataTables("DYDZM").Find("dzm='" & dr("gh") & "' and zd_id='" & dr("bmid") & "'") Is Nothing Then
cmd = new MySql.Data.MySql Client.MySqlC ommand("updat e ipos_dianyuan set zd_id = '" & dr("bmid") & "' where dzm = '" & dr("gh") & "'", conn) '这里写操作语句,跟sql一样
cmd.Exe cuteN onQuery()
End If
Next
conn.close
DataTables("DDYG").Save()
.NET Framework 版本：4.0.30319.42000
Foxtable 版本：2021.12.30.1
错误所在事件：自定义函数,同步员工店铺
详细错误信息：
调用的目标发生了异常。
Timeout in IO operation
加好友 
发短信
Post By：2022/1/21 21:32:00 [只看该作者]
