how to map role with permissions

how can you give some example i am not able to understand

ya understood your point but i am not able to see the checkboxes checked . i an writing my code please check it.

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)
{

try
{

if (!Page.IsPostBack)
{
BindGrid();

}
}
catch (Exception ex)
{
}

//



}

protected void Button2_Click(object sender, EventArgs e)
{


DropDownList1.Items.Remove(DropDownList1.SelectedItem);
con.Open();
string query = "Delete from Role2 Where Role_Name <> 'Administrator' ";
SqlCommand cmd = new SqlCommand(query, con);
cmd.ExecuteNonQuery();
con.Close();

}




protected void Button1_Click1(object sender, EventArgs e)
{
string fruit = TextBox1.Text.Trim();
if (!string.IsNullOrEmpty(fruit))
{
DropDownList1.Items.Add(new ListItem(fruit, fruit));

}


string role = TextBox1.Text;
con.Open();
string str = "insert into [Role2] (Role_Name) values(@Role_Name)";
using (SqlCommand insertuser = new SqlCommand(str, con))
try
{
insertuser.Parameters.AddWithValue("@Role_Name", TextBox1.Text);

insertuser.ExecuteNonQuery();

}
catch (Exception ex)
{
}
con.Close();


}
private void BindGrid()
{
string qry = "select distinct * from Role1";
DataSet ds = dut.GetDataSet(qry);
GridView1.DataSource = ds;
GridView1.DataBind();

}


protected void Button3_Click(object sender, EventArgs e)
{



//for (int i = 0; i < GridView1.Rows.Count; i++)
//{
// CheckBox chk = (CheckBox)GridView1.Rows[i].Cells[2].FindControl("CheckBox1");
// if (chk != null)
// {
foreach (GridViewRow row in GridView1.Rows)
{

if (row.RowType == DataControlRowType.DataRow)
{
CheckBox chkRow = (row.Cells[2].FindControl("CheckBox1") as CheckBox);
if (chkRow.Checked)
{



string strID = row.Cells[0].Text;
string Pages = row.Cells[1].Text;
string status = "Y";


con.Open();
string query = "Update Role1 set [Add] ='" + status + "' where ID= '" + strID + "' and Pages= '" + Pages + "'";
SqlCommand cmd = new SqlCommand(query, con);
cmd.ExecuteNonQuery();

BindGrid();
con.Close();
}


else
{

string strID = row.Cells[0].Text;
string Pages = row.Cells[1].Text;
string status = "N";



//cmd = new SqlCommand("insert into Role1(Checkin_Add) values(" + status + " where ID= '" + strID + "' and Role_Name='" + strName + "')", con);
string query = "Update Role1 set [Add] ='" + status + "' where ID= '" + strID + "' and Pages= '" + Pages + "'";
SqlCommand cmd = new SqlCommand(query, con);
con.Open();
cmd.ExecuteNonQuery();

BindGrid();
con.Close();
}
CheckBox chk = (row.Cells[2].FindControl("CheckBox2") as CheckBox);
if (chk.Checked)
{



string strID = row.Cells[0].Text;
string Pages = row.Cells[1].Text;

how the roles i am selecting will be associate with my gridview. Checkboxes are also not maintaining their state. I tried with using session and viewstate but failed to do that. Hope you will help me

Cannot insert explicit value for identity column in table 'Role1' when IDENTITY_INSERT is set to OFF. this error is coming.by the way i have used datatype of Role_Id is int but the drop downlist contains strings. how it will be done.

or without mapping with Role_Id i have to map with Role_Name. Is it Possible if i will map with Role_Name.Kindly suggest.

I made the Role_Id to varchar but problem is when i am checking the text boxes and click the save button each time 8 rows are inserting.I had 8 row.I select a role from drom down list and click on save button. Now i have 16rows in my database and gridview. how will 1 get only one roles gridview a time

Hi Dinesh,
Instead of inserting when i wrote code for update it comes.but my problem is if i select user role then only that role's permission is storing in database and checkboxes are also unchecking when i am clicking the save button.kindly help