SqlConnection mySqlConnection = new Conn().GetConn();
SqlCommand cmd = mySqlConnection.CreateCommand(); cmd.CommandText = "INSERT INTO User(CustomerNumber,CustomerJC,CustomerQC,Telephone,Fax,Address,Code,CompanySite,Corporate,Accounts,TaxNumber,Re,Prouduct) VALUES ('"+CustomerNumber2+"','"+CustomerJC2+"','"+CustomerQC2+"','"+Telephone2+"','"+Fax2+"','"+Address2+"','"+Code2+"','"+CompanySite2+"','"+Corporate2+"','"+Accounts2+"','"+TaxNumber2+"','"+Re2+"','"+Prouduct2+"')";
cmd.ExecuteNonQuery();
SqlCommand cmd = mySqlConnection.CreateCommand(); cmd.CommandText = "INSERT INTO User(CustomerNumber,CustomerJC,CustomerQC,Telephone,Fax,Address,Code,CompanySite,Corporate,Accounts,TaxNumber,Re,Prouduct) VALUES ('"+CustomerNumber2+"','"+CustomerJC2+"','"+CustomerQC2+"','"+Telephone2+"','"+Fax2+"','"+Address2+"','"+Code2+"','"+CompanySite2+"','"+Corporate2+"','"+Accounts2+"','"+TaxNumber2+"','"+Re2+"','"+Prouduct2+"')";
cmd.ExecuteNonQuery();
应该是[User]才对。
2.语法改一下,把SQL语句打印出来,拿到数据库中试一下,看是否正确.
sql = ".........";
response.write sql;
response.end;
cmd.CommandText = sql;
但是可能真的因为“user”是关键词才不让发的。
你就用[user]吧,这样应该可以的。