Solved

GridView CheckBox OnCheckChanged Save To DataTable?

Posted on 2012-03-19
8
389 Views
Last Modified: 2012-03-20
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;
       

}
0
Comment
Question by:pointeman
  • 4
  • 4
8 Comments
 
LVL 20

Expert Comment

by:BuggyCoder
Comment Utility
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

0
 

Author Comment

by:pointeman
Comment Utility
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
0
 
LVL 20

Expert Comment

by:BuggyCoder
Comment Utility
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
0
 

Author Comment

by:pointeman
Comment Utility
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();
0
Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

 
LVL 20

Accepted Solution

by:
BuggyCoder earned 500 total points
Comment Utility
Do This:-

for(int i=0;i<GridView1.Rows.Count;i++)
            {
                GridViewRow row = GridView1.Rows[i];
                CheckBox ckbx = (CheckBox)row.FindControl("checkbox1");

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

                dr = dt.NewRow();
                dr[0] = GridView1.DataKeys[i].Value.ToString();
                dr[1] = ckbx.Checked.ToString();
                dt.Rows.Add(dr);
            }

Open in new window


Also read here:-
http://msdn.microsoft.com/en-us/library/system.web.ui.webcontrols.gridview.datakeys.aspx
0
 

Author Comment

by:pointeman
Comment Utility
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/>");
}
0
 
LVL 20

Expert Comment

by:BuggyCoder
Comment Utility
glad you got the answer, please close the question....
0
 

Author Closing Comment

by:pointeman
Comment Utility
thx a million
0

Featured Post

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

AJAX ModalPopupExtender has a required property "TargetControlID" which may seem to be very confusing to new users. It means the server control that will be extended by the ModalPopup, for instance, if when you click a button, a ModalPopup displays,…
Just a quick little trick I learned recently.  Now that I'm using jQuery with abandon in my asp.net applications, I have grown tired of the following syntax:      (CODE) I suppose it just offends my sense of decency to put inline VBScript on a…
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now