สร้าง GridView เพื่อแสดงข้อมูลจาก database ค่ะ แล้วมีสองช่อง ที่เป็น checkbox และ textbox ที่รับค่าจาก db มาแสดง

 protected void grdSearch_RowDataBound(object sender, GridViewRowEventArgs e)
    {
       if (e.Row.RowType == DataControlRowType.DataRow)
        {

            CheckBox chkClubg = new CheckBox();
            chkClubg = e.Row.FindControl("chkClubg") as CheckBox;

            if (e.Row.Cells[19].Text == "Y")
            {
                chkClubg.Checked = true;
            }
       }
}

 private DataTable UpdateRoomtype(int RoomTypeID)
    {

        using (SqlConnection cn = new SqlConnection(Globals.Settings.Hotels.ConnectionString))
        {

            string sql = "UPDATE  tbx_RoomType";
            sql = sql + " SET FlagClub = 'Y' , RoomUnit = '1' ";
           sql = sql + " , UpdateBy = @UpdateBy ,UpdateTime = @UpdateTime ";
            sql = sql + " WHERE (tbx_RoomType.RoomTypeID =" + Request.QueryString["rID"].ToDecimal() + ") ";

            SqlCommand cmd = new SqlCommand(sql, cn);
            cmd.CommandType = CommandType.Text;
            cn.Open();

            DataTable dt = new DataTable();


            System.Data.Common.DbDataReader dr;
            dr = cmd.ExecuteReader();

            dt.Load(dr);


            return dt;

        }

    }
    protected void cmdSaveAll_Click(object sender, EventArgs e)
    {

        for (int i = 0; i < grdSearch.Rows.Count; i++)
        {
            TextBox txtRoomUnit = new TextBox();
            txtRoomUnit = grdSearch.Rows[i].FindControl("txtRoomUnit") as TextBox;

            CheckBox chkClubg = new CheckBox();
            chkClubg = new CheckBox();
            chkClubg = grdSearch.Rows[i].FindControl("chkClubg") as CheckBox;


            UpdateRoomtype(grdSearch.Rows[i].Cells[1].Text.ToInt());
            

        }

        Alert(MsgType.FinishUpdate);
      
    
        }