"INSERT INTO S_user(userName,passWord) values('" + txt_AdminName.Text.Trim() + "','" + txt_AdminPass.Text.Trim() + "')";数据库里的字段:userName,passWord多是字符串。Exception Details: System.Data.OleDb.OleDbException: INSERT INTO 语句的语法错误。string Select_name = "select * from S_user where userName='" + txt_AdminName.Text.Trim()+"'";
string Add_user = "INSERT INTO S_user(userName,passWord) values('" + txt_AdminName.Text.Trim() + "','" + txt_AdminPass.Text.Trim() + "')";
ComClass GetData = new ComClass();
OleDbCommand Cmdexe = new OleDbCommand(Add_user,GetData.Getcon());
Cmdexe.ExecuteNonQuery();
string Add_user = "INSERT INTO S_user(userName,passWord) values('" + txt_AdminName.Text.Trim() + "','" + txt_AdminPass.Text.Trim() + "')";
ComClass GetData = new ComClass();
OleDbCommand Cmdexe = new OleDbCommand(Add_user,GetData.Getcon());
Cmdexe.ExecuteNonQuery();
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货