Hi Friends... Thank u So Much to all...
in my aspx page me add another one gridview like below
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
Width="100%">
<Columns>
<asp:TemplateField HeaderText="Master">
<EditItemTemplate>
<asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="Label1" runat="server" Text='<%#Eval("Master") %>' />
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Can Add">
<EditItemTemplate>
<asp:CheckBox ID="CheckBox1" runat="server" />
</EditItemTemplate>
<ItemTemplate>
<asp:CheckBox ID="CheckBox1" runat="server" />
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Can Update">
<EditItemTemplate>
<asp:CheckBox ID="CheckBox2" runat="server" />
</EditItemTemplate>
<ItemTemplate>
<asp:CheckBox ID="CheckBox2" runat="server" />
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="User Level">
<EditItemTemplate>
<asp:TextBox ID="TextBox2" runat="server"></asp:TextBox>
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="Label2" runat="server"></asp:Label>
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
<asp:GridView ID="GridView2" runat="server" AutoGenerateColumns="False" Width="100%">
<Columns>
<asp:TemplateField HeaderText="Master">
<EditItemTemplate>
<asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="Label1" runat="server" Text='<%#Eval("Master") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Can Add">
<EditItemTemplate>
<asp:CheckBox ID="CheckBox1" runat="server" />
</EditItemTemplate>
<ItemTemplate>
<asp:CheckBox ID="CheckBox1" runat="server" Checked='<%# Eval("CanAdd").ToString() == "1" ? true : false %>' />
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Can Update">
<EditItemTemplate>
<asp:CheckBox ID="CheckBox2" runat="server" />
</EditItemTemplate>
<ItemTemplate>
<asp:CheckBox ID="CheckBox2" runat="server" Checked='<%# Eval("CanUpdate").ToString() == "1" ? true : false %>' />
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="User Level">
<EditItemTemplate>
<asp:TextBox ID="TextBox2" runat="server"></asp:TextBox>
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="Label2" runat="server" Text='<%#Eval("UserLevel") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
in my aspx.cs page i wrote the below code
protected void Button2_Click(object sender, EventArgs e)
{
con.Open();
kk = GridView1.Rows.Count;
string HH = "select count(*) from Tbl_Com_UserRights where userlevel='" + DDUserLvl.Text + "'";
cmd = new SqlCommand(HH, con);
reccont = (Int32)cmd.ExecuteScalar();
if (reccont == 0)
{
for (int i = 0; i < kk; i++)
{
mas = ((Label)(GridView1.Rows[i].Cells[0].FindControl("Label1"))).Text;
if (((CheckBox)(GridView1.Rows[i].Cells[0].FindControl("CheckBox1"))).Checked == true)
{
aa = 1;
}
else
{
aa = 0;
}
if (((CheckBox)(GridView1.Rows[i].Cells[0].FindControl("CheckBox2"))).Checked == true)
{
bb = 1;
}
else
{
bb = 0;
}
if (bb == 1)
{
aa = 1;
}
level = Convert.ToDouble(DDUserLvl.Text);
if (mas == "" && aa == 0 && bb == 0)
{
return;
}
else
{
cmd = new SqlCommand("insert into Tbl_Com_UserRights(master,canadd,canupdate,userlevel) values('" + mas + "','" + aa + "','" + bb + "','" + level + "')", con);
Int32 CC = (Int32)cmd.ExecuteNonQuery();
}
}
}
else
{
Int32 KK = GridView2.Rows.Count;
for (int i = 0; i < KK; i++)
{
mas = ((Label)(GridView2.Rows[i].Cells[0].FindControl("Label1"))).Text;
if (((CheckBox)(GridView2.Rows[i].Cells[0].FindControl("CheckBox1"))).Checked == true)
{
aa = 1;
}
else
{
aa = 0;
}
if (((CheckBox)(GridView2.Rows[i].Cells[0].FindControl("CheckBox2"))).Checked == true)
{
bb = 1;
}
else
{
bb = 0;
}
level = Convert.ToDouble(DDUserLvl.Text);
if (mas == "" && aa == 0 && bb == 0)
{
return;
}
else
{
cmd = new SqlCommand("Update Tbl_Com_UserRights Set canadd='" + aa + "',canupdate='" + bb + "' WHERE master='" + mas + "' and userlevel='" + level + "'", con);
Int32 CC = (Int32)cmd.ExecuteNonQuery();
}
}
}
DDUserLvl.Text = "Select Level";
if (kk != 0)
{
ClientScript.RegisterStartupScript(this.GetType(), "myalert", "alert('Configration Saved');", true);
}
else
{
ClientScript.RegisterStartupScript(this.GetType(), "myalert", "alert('Configration Updated');", true);
}
Btn_Save.Text = "Save";
GridView2.DataSource = null;
GridView2.DataBind();
GridView1.DataSource = null;
GridView1.DataBind();
con.Close();
}