<div>
<asp:GridView runat="server" ID="gridEmp" DataKeyNames="empid" AutoGenerateColumns="false" OnRowEditing="GridviewEmpEditing" OnRowUpdating="GridviewEmpUpdating" OnRowCancelingEdit="GridviewEmpCanceling" >
<Columns>
<asp:TemplateField HeaderText="Edit">
<ItemTemplate>
<asp:LinkButton runat="server" ID="linkEdit" Text="Edit" CommandName="Edit"></asp:LinkButton>
</ItemTemplate>
<EditItemTemplate>
<asp:LinkButton runat="server" ID="linkUpdate" Text="Update" CommandName="Update"> </asp:LinkButton>
<asp:LinkButton runat="server" ID="linkCancel" Text="Cancel" CommandName="Cancel"> </asp:LinkButton>
</EditItemTemplate>
</asp:TemplateField >
<asp:TemplateField HeaderText="EmpId">
<ItemTemplate>
<%# Eval("empid")%>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox runat="server" ID="txtEmpid" Text='<%# Eval("empid")%>'></asp:TextBox>
</EditItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="EmpNo">
<ItemTemplate>
<%# Eval("empno")%>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox runat="server" ID="txtEmpNo" Text='<%# Eval("empno")%>'></asp:TextBox>
</EditItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="EmpName">
<ItemTemplate>
<%# Eval("empname")%>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox runat="server" ID="txtEmpName" Text='<%# Eval("empname")%>'></asp:TextBox>
</EditItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
<asp:Label runat="server" ID="lblError"></asp:Label>
</div>
In the griviewupdating event while you are updating the empno check whether entered empno is 20 or 21 like below then write the code for updating
int Empid = int.Parse(gridEmp.DataKeys[e.RowIndex].Value.ToString());
GridViewRow row = gridEmp.Rows[e.RowIndex] as GridViewRow;
TextBox txtEno = row.FindControl("txtEmpNo") as TextBox;
TextBox txtEname = row.FindControl("txtEmpName") as TextBox;
if (txtEno.Text == "20" || txtEno.Text == "21")
{
string updateCommand = "update empcode set empno=@empno, empname=@empname where empid=@empid";
SqlConnection con = new SqlConnection(Connstr);
{
SqlCommand cmd = new SqlCommand(updateCommand, con);
{
cmd.Parameters.AddWithValue("@empid", Empid);
cmd.Parameters.AddWithValue("@empno", txtEno.Text);
cmd.Parameters.AddWithValue("@empname", txtEname.Text);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
}
gridEmp.EditIndex = -1;
this.GetData();
}
else
{
lblError.Text = "Error occured please enter 20 or 21";
}