Storing CheckBoxList values to database

See more:

C#

ASP.NET

SQL-Server

, +

Hi,

I am trying to use checkbox list for the first time in gridview
here is my asp code

<asp:GridView ID="gdvPermissions" runat="server" AutoGenerateColumns="False" OnRowCommand="gdvPermissions_RowCommand" OnRowDataBound="gdvPermissions_RowDataBound" DataKeyNames="Module_Name">
    <Columns>
        <asp:TemplateField>
            <HeaderTemplate>Module Name</HeaderTemplate>
            <ItemTemplate>
                <asp:Label runat="server" ID="lblPageName" Text='<%# Eval("Module_Name") %>'></asp:Label>
            </ItemTemplate>
        </asp:TemplateField>
        <asp:TemplateField>
            <HeaderTemplate>Read Permission</HeaderTemplate>
            <ItemTemplate>
                <asp:CheckBox runat="server" ID="cbxRead"></asp:CheckBox>
            </ItemTemplate>
        </asp:TemplateField>
        <asp:TemplateField>
            <HeaderTemplate>Write Permission</HeaderTemplate>
            <ItemTemplate>
                <asp:CheckBox runat="server" ID="cbxWrite"></asp:CheckBox>
            </ItemTemplate>
        </asp:TemplateField>
        <asp:TemplateField>
            <HeaderTemplate>None</HeaderTemplate>
            <ItemTemplate>
                <asp:CheckBox runat="server" ID="cbxEdit"></asp:CheckBox>
            </ItemTemplate>
        </asp:TemplateField>
        <asp:TemplateField>
            <ItemTemplate>
                <asp:Button ID="btnSave" runat="server" CommandName="Save" Text="Save" ToolTip="Add Permissions" />
            </ItemTemplate>
        </asp:TemplateField>
    </Columns>
</asp:GridView>

And in the row data bound i am trying to access the grid values to store to database

protected void gdvPermissions_RowCommand(object sender, GridViewCommandEventArgs e)
{
    if (e.CommandName == "Save")
    {
        GridViewRow row = (GridViewRow)((Control)e.CommandSource).NamingContainer;
        string PageID = Convert.ToString(gdvPermissions.DataKeys[row.RowIndex].Value);
        CheckBox cbxRead = new CheckBox();
        cbxRead = (CheckBox)row.FindControl("cbxRead");
        CheckBox cbxWrite = new CheckBox();
        cbxWrite = (CheckBox)row.FindControl("cbxWrite"); 
        CheckBox cbxEdit = new CheckBox();
        cbxEdit = (CheckBox)row.FindControl("cbxEdit");
        string val = objBal.InsertPermissions(ddlRoles.SelectedValue.ToString(), PageID, cbxRead.Checked.ToString(), cbxWrite.Checked.ToString(), cbxEdit.Checked.ToString(), User);
        if (val == "9990")
        {
            lblError.Text = "Right Updated Successfully";
        }
        else if (val == "9991")
        {
            lblError.Text = "Right Inserted Successfully";
        }
        else
        {
            lblError.Text = "Error Occured while Assigning User the Rights";
        }
    }
}

so i have 5 modules which will be displayed in the grid along with read write none check box beside it and save button at end of every column

when i click on save button i want the check box values of the particular module to be saved in database.

Please help me.

Thanks in Advance.