解决方案 »

  1.   

    设置DropDownList实现商品是否销售
      protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
        {
            int ID=int.Parse(GridView1.DataKeys[e.RowIndex].Value.ToString());
            bool PaperState = bool.Parse(((DropDownList)GridView1.Rows[e.RowIndex].FindControl("ddlSellState")).SelectedValue);
            string strsql = "UPDATE tb_OrderForm SET 是否停售 = @SellState WHERE 产品编号= @ID";
            SqlConnection conn = new SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"]);
            conn.Open();
            SqlCommand comm = new SqlCommand(strsql, conn);
            comm.Parameters.Add(new SqlParameter("@ID", SqlDbType.Int, 4));
            comm.Parameters["@ID"].Value = ID;
            comm.Parameters.Add(new SqlParameter("@SellState", SqlDbType.Bit, 1));
            comm.Parameters["@SellState"].Value = PaperState;
            if (Convert.ToInt32(comm.ExecuteNonQuery()) > 0)
            {
                Response.Write("<script language=javascript>alert('设置成功!');location='Default.aspx'</script>");
            }
            else
            {
                Response.Write("<script language=javascript>alert('设置失败!');location='Default.aspx'</script>");
            }
            //取消编辑操作
            GridView1.EditIndex = -1;
            //调用自定义方法DbBind()重新绑定GridView控件中信息
            DbBind();
        }