How to automatic store value in database when checkbox is checked in web forms

Question

How to automatic store value in database when checkbox is checked and refresh my To do list. Here is my code:

This is my HTML:

<asp:Repeater ID="rpTodos" runat="server">
    <ItemTemplate>
           <tr>
                <td><%# Eval("TodosID", "{0:d}") %></td>             
                <td><%# Eval("TaskName", "{0:d}") %></td>
                <td><asp:CheckBox ID="cbisdone" runat="server" AutoPostBack="true" checked='<%#Eval("IsDone")%>'></asp:CheckBox></td>                                                                                                       
               <td><%# Eval("TaskDate", "{0:d}") %></td>                                        
            </tr>                                            
    </ItemTemplate>                                        
</asp:Repeater>

This is code behind:

var todos2 = ctx.Todos.ToList().Where(t=> t.IsDone == false).ToList();
rpTodos.DataSource = todos2;
rpTodos.DataBind();

You need a "checked" event on the server if you enable the autopostback on the checkbox. It's called "OnCheckedChanged" msdn.microsoft.com/de-de/library/… — Schadensbegrenzer
– Schadensbegrenzer, Commented Aug 3, 2018 at 11:54

Federico Navarrete · Accepted Answer · 2018-08-03 12:10:50Z

1

Add a OnCheckedChanged event in your aspx page.

<asp:CheckBox ID="cbisdone" runat="server" AutoPostBack="true" checked='<%#Eval("IsDone")%>' OnCheckedChanged="cbisdone_changed"></asp:CheckBox>

Create a new event that would listen to raised event and cast the sender object back to Checkbox.

protected void cbisdone_changed(object sender, EventArgs e)
{
    if (sender != null)
    {
        if (((CheckBox)sender).Checked)
        {
              // Update the status in DB.
        }
    }
}

edited Aug 3, 2018 at 12:10

Federico Navarrete

3,3045 gold badges52 silver badges87 bronze badges

answered Aug 3, 2018 at 11:55

Suprabhat Biswal

3,2561 gold badge23 silver badges30 bronze badges

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

Collectives™ on Stack Overflow

How to automatic store value in database when checkbox is checked in web forms

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related