asp.net update 更新不了数据库 急急！！！

Question

            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");

Answer 1

没看到有执行语句= =
cmd.ExecuteNonQuery()呢？

Answer 2

.....
conn.Open();
                sqlcom = new SqlCommand(up, conn);
                sqlcom.ExecuteNonQuery();//更新
                conn.Close();

Answer 3

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("出错")

Answer 4

string userClass = "管理员";
 string sess = (string)Session["userclass"];
  if (userClass == sess)
 这是你原代码字符串是不能用 "==" ,改成 Equals() 

Answer 5

update dn_Article set [content]="+cont+",如果content是字符串 ，要加单引号 
如 set content = 'aaaa'
那么你的 set [content]='"+cont+"',

Answer 6

兄弟，加上一段代码 SqlCommandBuilder buider = new SqlCommandBuilder(已经创建好的数据适配器对象);
数据适配器对象.Update(数据集对象,"临时数据库名称");