OleDbConnection conn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;data source=E:\\web\\BargainSystem\\App_Data\\BargainDB.mdb");
conn.Open();
string strSQL = "INSERT INTO [UserInfo](Tel,UserName,Password,Email) VALUES ('" + UserName.Text + "','" + Password.Text + "','" + Tel.Text + "' ,'" + Email.Text + "')";
OleDbCommand cmd = new OleDbCommand(strSQL, conn);
cmd.ExecuteNonQuery();
搞不明白
conn.Open();
string strSQL = "INSERT INTO [UserInfo](Tel,UserName,Password,Email) VALUES ('" + UserName.Text + "','" + Password.Text + "','" + Tel.Text + "' ,'" + Email.Text + "')";
OleDbCommand cmd = new OleDbCommand(strSQL, conn);
cmd.ExecuteNonQuery();
搞不明白
[UserInfo] 不用加括号。UserInfo就可以
换成这样看看!
还是有错呀,不是这个问题
一个一个排除,先只做一个字段添加,INSERT INTO UserInfo(UserName) VALUES ('" + UserName.Text + "');如果没错,就再加个字段INSERT INTO UserInfo(UserName,Password) VALUES ('" + UserName.Text + "','" + Password.Text + "');