是不是这儿出了问题: OleDbCommand cm = new OleDbCommand("insert into userinfo1 (name) value (?name)",cn);用 OleDbCommand cm = new OleDbCommand("insert into userinfo1 (name) value ('"+ name +"')",cn); cn.Open(); cm.Parameters.Add(new OleDbParameter("name",OleDbType.Char,10)); cm.ExecuteNonQuery(); cn.Close(); 试试
我把你的试了试 你把他还原 SqlConnection cn = new SqlConnection("server=localhost;database=linpcontract;uid=sa;pwd=;"); SqlCommand cm = new SqlCommand("insert into userinfo1 (name) values (@name)",cn); cn.Open(); cm.Parameters.Add("@name", SqlDbType.Char).Value = "你的值"; cm.ExecuteNonQuery(); cn.Close(); //好了
谢谢大家,我本来有赋值的,忘写上了; SQL的我懂啊!!我问的是Access的啊!! ----------------------------------------- OleDbConnection conn = new OleDbConnection("Provider = Microsoft.Jet.OLEDB.4.0;Data Source = "+Server.MapPath("db2.mdb")); OleDbCommand cmm = new OleDbCommand("insert into userinfo (username,password) values (?username,?password)",conn); conn.Open(); cmm.Parameters.Add(new OleDbParameter("?username",OleDbType.Char,20)).Value = username.Text; cmm.Parameters.Add(new OleDbParameter("?password",OleDbType.Char,20)).Value = password.Text; cmm.ExecuteNonQuery(); conn.Close(); ----------------------------------------- 提示:INSERT INTO 语句的语法错误。 我看不出INSERT INTO哪里错了啊??大家帮帮忙啊???
OleDbCommand cm = new OleDbCommand("insert into userinfo1 (name) value (?name)",cn);用
OleDbCommand cm = new OleDbCommand("insert into userinfo1 (name) value ('"+ name +"')",cn);
cn.Open();
cm.Parameters.Add(new OleDbParameter("name",OleDbType.Char,10));
cm.ExecuteNonQuery();
cn.Close();
试试
你把他还原
SqlConnection cn = new SqlConnection("server=localhost;database=linpcontract;uid=sa;pwd=;"); SqlCommand cm = new SqlCommand("insert into userinfo1 (name) values (@name)",cn); cn.Open();
cm.Parameters.Add("@name", SqlDbType.Char).Value = "你的值";
cm.ExecuteNonQuery();
cn.Close();
//好了
SQL的我懂啊!!我问的是Access的啊!!
-----------------------------------------
OleDbConnection conn = new OleDbConnection("Provider = Microsoft.Jet.OLEDB.4.0;Data Source = "+Server.MapPath("db2.mdb"));
OleDbCommand cmm = new OleDbCommand("insert into userinfo (username,password) values (?username,?password)",conn);
conn.Open();
cmm.Parameters.Add(new OleDbParameter("?username",OleDbType.Char,20)).Value = username.Text;
cmm.Parameters.Add(new OleDbParameter("?password",OleDbType.Char,20)).Value = password.Text;
cmm.ExecuteNonQuery();
conn.Close();
-----------------------------------------
提示:INSERT INTO 语句的语法错误。
我看不出INSERT INTO哪里错了啊??大家帮帮忙啊???