代码如下。程序运行无错误,但是数据库没有改变。我把生成的SQL语句输出了复制到MySQL的控制台中运行可以正常运行,排除SQL语句错误的问题。是不是我的C#语句写的有问题啊,应该怎么写啊?求解答!谢谢!~
string UpdataStr = null;
UpdataStr = "UPDATE `" + form + "` SET `" + table + "`='" + values + "' WHERE (`" + wherename + "`='" + wherevalues + "');";
MySQLConnection conn = null;
conn = new MySQLConnection(new MySQLConnectionString(server, database, uid, pwd).AsString);
conn.Open();
MySQLCommand cmd = new MySQLCommand(UpdataStr, conn);
conn.Close();
string UpdataStr = null;
UpdataStr = "UPDATE `" + form + "` SET `" + table + "`='" + values + "' WHERE (`" + wherename + "`='" + wherevalues + "');";
MySQLConnection conn = null;
conn = new MySQLConnection(new MySQLConnectionString(server, database, uid, pwd).AsString);
conn.Open();
MySQLCommand cmd = new MySQLCommand(UpdataStr, conn);
conn.Close();
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货