string id=Request["articleid"].ToString();
string ddltypee = ddltype.SelectedValue.Trim();
string txttitle1 = txttitle.Text.ToString();
string cont = txtcontent.Text.Trim();
string writename = txtwritename.Text.Trim();
string sour = txtsource.Text.Trim();
string userClass = "管理员";
int check;
string sess = (string)Session["userclass"];
if (userClass == sess)
{
check = 1;
}
else
{
check = 0;
}
SqlConnection conn = new SqlConnection();
conn.ConnectionString = @"Data Source=.\sqlexpress;Initial Catalog=SunNews;Integrated Security=True";
conn.Open();
string up="update dn_Article set [content]="+cont+",title="+txttitle.Text.Trim()+",classname="+ddltypee+",writer="+writename+",source="+sour+",dateandtime="+DateTime.Now.ToString()+",checkup="+check+" where articleid="+id+"";
SqlDataAdapter da = new SqlDataAdapter(up,conn);
DataSet ds = new DataSet();
da.Fill(ds);
Response.Redirect("newmanage.aspx");
string ddltypee = ddltype.SelectedValue.Trim();
string txttitle1 = txttitle.Text.ToString();
string cont = txtcontent.Text.Trim();
string writename = txtwritename.Text.Trim();
string sour = txtsource.Text.Trim();
string userClass = "管理员";
int check;
string sess = (string)Session["userclass"];
if (userClass == sess)
{
check = 1;
}
else
{
check = 0;
}
SqlConnection conn = new SqlConnection();
conn.ConnectionString = @"Data Source=.\sqlexpress;Initial Catalog=SunNews;Integrated Security=True";
conn.Open();
string up="update dn_Article set [content]="+cont+",title="+txttitle.Text.Trim()+",classname="+ddltypee+",writer="+writename+",source="+sour+",dateandtime="+DateTime.Now.ToString()+",checkup="+check+" where articleid="+id+"";
SqlDataAdapter da = new SqlDataAdapter(up,conn);
DataSet ds = new DataSet();
da.Fill(ds);
Response.Redirect("newmanage.aspx");
cmd.ExecuteNonQuery()呢?
conn.Open();
sqlcom = new SqlCommand(up, conn);
sqlcom.ExecuteNonQuery();//更新
conn.Close();
SqlConnection conn = new SqlConnection();
conn.ConnectionString = @"Data Source=.\sqlexpress;Initial Catalog=SunNews;Integrated Security=True";
conn.Open();
SqlCommand cmd = New SqlCommand(up,conn)
if(cmd.ExecuteNonQuery()==1)
Response.Redirect();
else
response.write("出错")
string sess = (string)Session["userclass"];
if (userClass == sess)
这是你原代码字符串是不能用 "==" ,改成 Equals()
如 set content = 'aaaa'
那么你的 set [content]='"+cont+"',
数据适配器对象.Update(数据集对象,"临时数据库名称");