How to retrieve checkbox values from a database .

populateGridview();

public partial class _Default : System.Web.UI.Page
{
DataUtility dut = new DataUtility();
SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["Con"]);

protected void Page_Load(object sender, EventArgs e)
{


Label5.Text = (string)Session["Role_Name"];

if (!IsPostBack)
{

populateGridview();

}

}
public void populateGridview()
{
if (Session["Role_Name"] != null && !string.IsNullOrEmpty(Session["Role_Name"].ToString()))
{
string qry = "select ID,Pages,[Add],[View],Edit,[Delete] from Role1 where Role_Name= '" + Session["Role_Name"].ToString() + "'";

DataSet ds = dut.GetDataSet(qry);
GridView1.DataSource = ds;
GridView1.DataBind();
}
//string qry = "select Pages,[Add],[View],Edit,[Delete] from Role1 where Role_Name= '"+Label5.Text+"'";
//DataSet ds = dut.GetDataSet(qry);
//GridView1.DataSource = ds;
//GridView1.DataBind();
}

protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
{

}
protected void Button7_Click(object sender, EventArgs e)
{
foreach (GridViewRow row in GridView1.Rows)
{
if (row.RowType == DataControlRowType.DataRow)
{
if (Session["Role_Name"] != null && !string.IsNullOrEmpty(Session["Role_Name"].ToString()))
{
CheckBox chkAdd = (row.Cells[2].FindControl("CheckBox1") as CheckBox);

CheckBox chkEdit = (row.Cells[3].FindControl("CheckBox2") as CheckBox);

CheckBox chkView = (row.Cells[4].FindControl("CheckBox3") as CheckBox);

CheckBox chkDelete = (row.Cells[5].FindControl("CheckBox4") as CheckBox);

// string strID = row.Cells[0].Text;
string ID = row.Cells[0].Text;
string Pages = row.Cells[1].Text;
con.Open();



string query = "Update Role1 set [Add]='" + (chkAdd.Checked == true ? 'Y' : 'N') + "', [View]='" + (chkView.Checked == true ? 'Y' : 'N') + "' ,[Edit]='" + (chkEdit.Checked == true ? 'Y' : 'N') + "' ,[Delete]='" + (chkDelete.Checked == true ? 'Y' : 'N') + "' where Pages ='" + Pages + "' and Role_Name='" + Session["Role_Name"].ToString() + "'and ID='" + ID + "'";
SqlCommand cmd = new SqlCommand(query, con);
cmd.ExecuteNonQuery();

con.Close();

}
}
}
populateGridview();

GridView1.DataBind();
}

}