Link to home
Start Free TrialLog in
Avatar of pointeman
pointemanFlag for United States of America

asked on

GridView CheckBox OnCheckChanged Save To DataTable?

I need to save ALL GridView CheckBoxes values to a dataset/datatable. This gets more interesting using a DataKey for col_ID. I have this much code:

foreach(GridViewRow gvr in GridView1.Rows)
{
      CheckBox cb = (CheckBox)gvr.FindControl("checkbox1");
      bool value = cb.Checked;
       

}
Avatar of BuggyCoder
BuggyCoder
Flag of India image

DataTable dt=new DataTable();
dt.Columns.Add(new DataColumn("Status",typeof(bool));
DataRow dr=null;
foreach(GridViewRow gvr in GridView1.Rows)
{
      CheckBox cb = (CheckBox)gvr.FindControl("checkbox1");
      if(cb!=null)
      {
      dr=dt.NewRow();
      bool value = cb.Checked;
      dr[0]=value;
      dt.Rows.Add(dr);
      }
}
dt.AcceptChanges();

Open in new window

Avatar of pointeman

ASKER

Need to add 2 items in the same row very simply. The Gridview datakey is col_ID.

row = "ID"  "Value"

The need a foreach to check the data. thx
bind the id with gridviewrow using label then search for this label and add its value to another column in datatable..
DataTable dt=new DataTable();
dt.Columns.Add(new DataColumn("Status",typeof(bool));
dt.Columns.Add(new DataColumn("ID",typeof(string));
DataRow dr=null;
foreach(GridViewRow gvr in GridView1.Rows)
{
      CheckBox cb = (CheckBox)gvr.FindControl("checkbox1");
      Label lb = (Label)gvr.FindControl("lblId");
      if(cb!=null && lb!=null)
      {
      dr=dt.NewRow();
      bool value = cb.Checked;
      dr[0]=value;
      dr[1]=lb.Text;
      dt.Rows.Add(dr);
      }
}
dt.AcceptChanges();

Open in new window


Table Will Have:-
Status    ID
Geting incorrect results like below, although the col_active is correct, the col_id should read 1-9

col_id= 9 col_active= True
col_id= 9 col_active= True
col_id= 9 col_active= True
col_id= 9 col_active = True
col_id= 9 col_active = True

[code so far]
 DataTable dt = new DataTable();
            dt.Columns.Add("col_id");
            dt.Columns.Add("col_active");
            DataRow dr = null;
            CheckBox cbSelectedHeader = (CheckBox)GridView1.HeaderRow.FindControl("ckbxheader");

            foreach (GridViewRow row in GridView1.Rows)
            {
                CheckBox ckbx = (CheckBox)row.FindControl("checkbox1");

                if (cbSelectedHeader.Checked == true)
                    ckbx.Checked = true;
                else
                    ckbx.Checked = false;

                dr = dt.NewRow();
                dr[0] = GridView1.DataKeys[row.RowIndex].Value.ToString();
                dr[1] = ckbx.Checked.ToString();
                dt.Rows.Add(dr);
            }
            dt.AcceptChanges();
ASKER CERTIFIED SOLUTION
Avatar of BuggyCoder
BuggyCoder
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
The problem is with the datatable add row because the datakeys return nicely like so:

foreach (GridViewRow row in GridView1.Rows)
{
     System.Web.HttpContext.Current.Response.Write(GridView1.DataKeys[row.RowIndex]["col_id"].ToString() + "<br/>");
}
glad you got the answer, please close the question....
thx a million