新手!
从网上找了写代码,拼凑了一下,如下: protected void Button1_Click(object sender, EventArgs e)
{
string NewsContent=content.Text.ToString();
Response.Write(NewsContent);
string CSmallClass="走进NowIT";
string CBigClass="集团简介";
if (NewsContent.Trim() != "") {
string CommTex = "Update Content set CContent=@CContent Where CSmallClass=@CSmallClass and CBigClass=@CBigClass";
string strConn = @"Provider=Microsoft.Jet.OLEDB.4.0 ;Data Source=" + Server.MapPath("~\\DataBase\\#wulong.mdb");
OleDbConnection myConn = new OleDbConnection(strConn);
myConn.Open();
OleDbCommand oldConn = new OleDbCommand(CommTex, myConn);
oldConn.Parameters.Add("@CSmallClass", OleDbType.BSTR, 1000).Value = CSmallClass;
oldConn.Parameters.Add("@CBigClass", OleDbType.BSTR, 1000).Value = CBigClass;
oldConn.Parameters.Add("@CContent", OleDbType.VarChar, 8000).Value = "123";
oldConn.ExecuteNonQuery();
myConn.Close();
Response.Write("<script>alert(\"更新成功\");</script>");
Response.Redirect("JumpRight-jtjj.aspx");
}
}没有错误出现。update语句能不能精简一些,用command这样写太麻烦了。
从网上找了写代码,拼凑了一下,如下: protected void Button1_Click(object sender, EventArgs e)
{
string NewsContent=content.Text.ToString();
Response.Write(NewsContent);
string CSmallClass="走进NowIT";
string CBigClass="集团简介";
if (NewsContent.Trim() != "") {
string CommTex = "Update Content set CContent=@CContent Where CSmallClass=@CSmallClass and CBigClass=@CBigClass";
string strConn = @"Provider=Microsoft.Jet.OLEDB.4.0 ;Data Source=" + Server.MapPath("~\\DataBase\\#wulong.mdb");
OleDbConnection myConn = new OleDbConnection(strConn);
myConn.Open();
OleDbCommand oldConn = new OleDbCommand(CommTex, myConn);
oldConn.Parameters.Add("@CSmallClass", OleDbType.BSTR, 1000).Value = CSmallClass;
oldConn.Parameters.Add("@CBigClass", OleDbType.BSTR, 1000).Value = CBigClass;
oldConn.Parameters.Add("@CContent", OleDbType.VarChar, 8000).Value = "123";
oldConn.ExecuteNonQuery();
myConn.Close();
Response.Write("<script>alert(\"更新成功\");</script>");
Response.Redirect("JumpRight-jtjj.aspx");
}
}没有错误出现。update语句能不能精简一些,用command这样写太麻烦了。
数据库里的数据没有更新成功?我不知道该怎么调试,asp可用response.write sql,这个用什么?