update语句无法更新数据
.CS代码如下:可是当点击链接后数据却无法更新(querystring["update"]和querystring["id"]都是通过点击链接传来的)数据库是access 2003
if (Request.QueryString["action"]!=null && Request.QueryString["action"].ToString() == "update")
{
//int pid = Convert.ToInt32(Request.QueryString["id"]);
con = new OleDbConnection();
con.ConnectionString = "Provider=Microsoft.jet.Oledb.4.0;data source=" + Server.MapPath("~/app_data/#data.mdb");
con.Open();
sql = "update list set title='" + txtSongName.Text + "',singer='" + txtSinger.Text + "',content='" + txtReason.Text + "',username='" + txtAuthor.Text + "' where id= " + Convert.ToInt32(Request.QueryString["id"]); //(sql语句在一行内)
cmd = new OleDbCommand(sql, con);
cmd.ExecuteNonQuery();
}
.ASPX代码如下:
<a href="AjaxShowDetailEdit.aspx?action=update&id=<%=Request.QueryString["id"] %>">更新</a>