I am using a list view inside that in item template i am using a label and a checkbox. I want that whenever user clicks on the check box the value should be updated in a table.i am using a datakeys in listview.on the basis of datakey value should be updated in the table query is string updateQuery = "UPDATE [TABLE] SET [COLUMN] = " + Convert.ToInt32(chk.Checked) + " WHERE PK_ID =" + dataKey + " ";

also i want some help in displaying the result as it is inside the table.means if the value for column in table for a particular pkid is 1 then the checkbox shoul be checked.

here is the code snippet

        <asp:ListView ID="lvFocusArea" runat="server" 
        DataKeyNames="PK_ID" onitemdatabound="lvFocusArea_ItemDataBound" >
        <LayoutTemplate>
            <table border="0" cellpadding="1" width="400px">
                <tr style="background-color: #E5E5FE">
                    <th align="left">
                        Focus Area
                    </th>
                    <th>
                        Is Current Focused
                    </th>
                </tr>
                <tr id="itemPlaceholder" runat="server">
                </tr>
            </table>
        </LayoutTemplate>
        <ItemTemplate>
            <tr>
                <td width="80%">
                    <asp:Label ID="lblFocusArea" runat="server" Text=""><%#Eval("FOCUS_AREA_NAME") %></asp:Label>
                </td>
                <td align="center" width="20%">
                    <asp:CheckBox ID="chkFocusArea" runat="server" OnCheckedChanged="chkFocusArea_CheckedChanged" 
                        AutoPostBack="true"/>
                </td>
            </tr>
        </ItemTemplate>
        <AlternatingItemTemplate>
            <tr style="background-color: #EFEFEF">
                <td>
                    <asp:Label ID="lblFocusArea" runat="server" Text=""><%#Eval("FOCUS_AREA_NAME") %></asp:Label>
                </td>
                <td align="center">
                    <asp:CheckBox ID="chkFocusArea" runat="server" oncheckedchanged="chkFocusArea_CheckedChanged" AutoPostBack="true" />
                </td>
            </tr>
        </AlternatingItemTemplate>
        <SelectedItemTemplate>
            <td> item selected</td>
        </SelectedItemTemplate>
    </asp:ListView>

help me.