Store checked checkbox in gridview in database ASP.NET C#

Question

I am able to retrieve out data from database to show which is Y and N using checkbox in gridview. However now i want to to able to store which checkbox is checked back into the database after editing.

What i did so far:

.aspx

    <asp:GridView ID="SiteGridView" runat="server" CssClass="datagrid" 
                  GridLines="Vertical" AutoGenerateColumns="False"
                  Width="100%" 
                  AllowPaging="True" AllowSorting="True" 
                  DataKeyNames="promoID"  OnRowCommand="GvPage_RowCommand" 
                  OnPageIndexChanging="GvPage_PageIndexChanging" 
                  OnSorting="GvPage_Sorting" 
                  OnRowDatabound="SiteGridView_RowDataBound"
                  OnRowEditing="SiteGridView_RowEditing">
      <Columns>       
        <asp:TemplateField HeaderText="Default">
          <ItemTemplate>
            <asp:CheckBox ID="process_flag" runat="server" 
              Checked='<%# bool.Parse(Eval("PROCESSED").ToString()) %>'
              Enable='<%# !bool.Parse(Eval("PROCESSED").ToString()) %>' />
          </ItemTemplate>
          <ItemStyle Width="20%" />
        </asp:TemplateField>
       </Columns>
     </asp:GridView>

CodeBehind:

     SqlCommand cmd = new SqlCommand("SELECT * , CAST(CASE defaults WHEN 'Y' THEN 1 ELSE 0 END AS BIT) AS PROCESSED FROM Promotions"); 
                SqlDataAdapter da = new SqlDataAdapter(); 
                DataTable dt = new DataTable(); 
                da.SelectCommand = cmd; 

                // Save results of select statement into a datatable 
                da.Fill(dt);

                SiteGridView.DataSource = dt;
                SiteGridView.DataBind(); 

        protected void SiteGridView_RowDataBound(object sender, GridViewRowEventArgs e)
        {
            if (e.Row.RowType == DataControlRowType.DataRow)
            {
                //check userrole & display accrodingly
                if (Session["ROLE"].ToString() != "SA")
                {
                    //ImageButton btnEdit = (ImageButton)e.Row.FindControl("btnDelete");
                    //btnEdit.Visible = false;
                    SiteGridView.Columns[4].Visible = false;
                }
            }
        }

Do you want to save the checkbox state on every click? or just once after the user acts on several rows? — fnostro
– fnostro, Commented Apr 29, 2016 at 19:44

Jason Gangwisch · Accepted Answer · 2016-04-29 04:35:46Z

1

Have you tried: Checked='<%# Eval("PROCESSED")%>'

If so, what error messages have you gotten?

answered Apr 29, 2016 at 4:35

Jason Gangwisch

564 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

fnostro · Accepted Answer · 2016-05-04 17:35:36Z

For some reason Checkboxes do not trigger GridView RowCommand events. It probably can be done with appropriate calls to ClientScript.GetPostBackEventReference(), but thats a whole other level of complexity. So, in order to act on a CheckBox click and handle events individually:

(NB: I've stripped out much of your coding to clarify my points.)

In your CheckBox set AutoPostBack="true"
Add a handler for OnCheckedChanged.

Make sure the DataKey contains the pk of the row you need to update with the CheckBox State

// Simplified version of your markup
<asp:GridView ID="SiteGridView" runat="server" 
              DataKeyNames="promoID" 
              OnRowDataBound="SiteGridView_RowDataBound">
  <Columns>
    <asp:TemplateField HeaderText="Default">
      <ItemTemplate>
        <asp:CheckBox ID="process_flag" runat="server" 
          Checked='<%# bool.Parse(Eval("PROCESSED").ToString()) %>'
          Enable='<%# !bool.Parse(Eval("PROCESSED").ToString()) %>'
          OnCheckedChanged="process_flag_CheckedChanged" />
      </ItemTemplate>
    </asp:TemplateField>
  </Columns>
</asp:GridView>

In the RowDataBound event, find the CheckBox and add the Row Index as an attribute

// Merge this with your `RowDataBound` event
protected void SiteGridView_RowDataBound( object sender, GridViewRowEventArgs e ) {
    if ( e.Row.RowType == DataControlRowType.DataRow ) {
        CheckBox cbx = ( CheckBox ) e.Row.FindControl( "CheckBox1" );
        cbx.Attributes[ "data-row-idx" ] = e.Row.RowIndex.ToString();
    }
}

Handle the CheckChanged event:

// Add this handler to your code
protected void process_flag_CheckedChanged( object sender, EventArgs e ) 
{
    CheckBox cbx = ( CheckBox ) sender;
    Int32 rowidx = Convert.ToInt32(cbx.Attributes["data-row-idx"]);
    Int32 pk = (Int32) GridView4.DataKeys[rowidx].Value;

    // simple way to see event arguments before actually touching the database
    GridView4.Caption = string.Format(
        "CheckChanged: Row {0}, State: {1}, RowPK: {2} ", rowidx , (cbx.Checked ? "Checked" : "Unchecked"), pk );

    // Save Data and rebind the gridview to reflect changes
    // Verify your parameters before attempting an actual update
    // YourDatabaseCallWithAppropriateParamaters( ... );
    GridView1.DataBind();
}

Chathuranga Ranasinghe · Accepted Answer · 2016-04-29 04:53:03Z

0

First of all use a foreach loop to findout which rows are checked. Then store ID of those rows in a List.

foreach (GridViewRow row in SiteGridView.Rows)
        {
            if (row.RowType == DataControlRowType.DataRow)
            {
                CheckBox chkRow = (row.Cells[0].FindControl("process_flag") as CheckBox);
                if (chkRow.Checked)
                {
                    string ID = row.Cells[columnID].Text;

answered Apr 29, 2016 at 4:53

Chathuranga Ranasinghe

5471 gold badge5 silver badges22 bronze badges

4 Comments

lel Over a year ago

sorry but the columnID is? because my other column are boundfield connected to database.

Chathuranga Ranasinghe Over a year ago

Show me your SiteGridView_RowDataBound event

lel Over a year ago

i paste the SiteGridView_RowDataBound event in codebehind

Chathuranga Ranasinghe Over a year ago

Pls share your save method to database

Collectives™ on Stack Overflow

Store checked checkbox in gridview in database ASP.NET C#

3 Answers 3

Comments

Comments

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related