con.Open();
OleDbCommand com = new OleDbCommand("update SW_News set newscontent=@newscontent where newsid=@newsid", con);
com.Parameters.Add("@newsid", OleDbType.Integer);
com.Parameters.Add("@newscontent", OleDbType.LongVarChar);
com.Parameters["@newscontent"].Value = WebEditor1.Text;
com.Parameters["@newsid"].Value = Request["id"];
com.ExecuteNonQuery();
Response.Write("<script>alert('修改成功')</script>");
每次都可以顺利执行,并且弹出修改成功的对话框,但数据库内容就根本无改变!!!
OleDbCommand com = new OleDbCommand("update SW_News set newscontent=@newscontent where newsid=@newsid", con);
com.Parameters.Add("@newsid", OleDbType.Integer);
com.Parameters.Add("@newscontent", OleDbType.LongVarChar);
com.Parameters["@newscontent"].Value = WebEditor1.Text;
com.Parameters["@newsid"].Value = Request["id"];
com.ExecuteNonQuery();
Response.Write("<script>alert('修改成功')</script>");
每次都可以顺利执行,并且弹出修改成功的对话框,但数据库内容就根本无改变!!!
第二:
//代码改成
int i=com.ExecuteNonQuery();
//如果i=1,则修改成功,i=0,则修改失败.
第三:你是的代码是否还有加上事务?事务是否commit?
con.Open();
OleDbCommand com = new OleDbCommand("update SW_News set newscontent=@newscontent where newsid=@newsid", con);
com.Parameters.Add("@newscontent", OleDbType.LongVarChar);
com.Parameters["@newscontent"].Value = WebEditor1.Text;
com.Parameters.Add("@newsid", OleDbType.Integer);
com.Parameters["@newsid"].Value = Request["id"];
com.ExecuteNonQuery();
Response.Write("<script>alert('修改成功')</script>");
肯定可以,access在添加参数的时候要与sql的参数顺序一致
JF
con连接字符串也没有问题!
"update SW_News set newscontent=a where newsid=b"
com.Parameters.Add("@newscontent", OleDbType.LongVarChar);
com.Parameters["@newscontent"].Value = WebEditor1.Text;
com.Parameters.Add("@newsid", OleDbType.Integer);
com.Parameters["@newsid"].Value = Request["id"];