Dim conn As MySql.Data.MySqlClient.MySqlConnection
Dim cmd As MySql.Data.MySqlClient.MySqlCommand
Dim connStr As String = "server=192.168.3.11; port=3302; user id=root; password=root; database=default;CharSet=utf8"
conn = New MySql.Data.MySqlClient.MySqlConnection(connStr)
conn.Open
For Each dr As Row In Tables("修改_Table1").rows
If dr("修改后") = "" Then
Else
cmd = new MySql.Data.MySqlClient.MySqlCommand("up date ps set ed = '"& dr("修改后") &"' where pn = '"& dr("编号") &"'", conn)
cmd.ExecuteNonQuery()
End If
Next
conn.close
目前出现dr("修改后") 含有特殊引用字符" ’ " 报错，请问这段如何处理？
加好友 
发短信
Post By：2018/6/13 11:35:00 [只看该作者]
