{"id":3879,"date":"2022-12-15T12:14:12","date_gmt":"2022-12-15T12:14:12","guid":{"rendered":"https:\/\/isophal.com\/?p=3879"},"modified":"2022-12-15T12:15:08","modified_gmt":"2022-12-15T12:15:08","slug":"crud-operations-using-entity-framework-in-asp-net","status":"publish","type":"post","link":"https:\/\/isophal.com\/news\/2022\/12\/15\/3879.html\/","title":{"rendered":"CRUD Operations Using Entity Framework in ASP.NET"},"content":{"rendered":"\n

Here in this application I will use an Item template, Edit Item template and Footer Template to do CRUD operations.

The following is my Data Table in design mode:

\"emp
                                      Image 1.

Data in my Data Table:

\"My
                                                                              Image 2.

To create the new application go to Solution Explorer in your application then select Add New Item.

Add an ADO.NET Entity Data Model.

\"Entity
                                                                              Image 3.

\"generate
                                                                        Image 4.

\"new
                                                                              Image 5.

Enter your server information and select your database:

\"select
                                                   Image 6.

\"select
                                                                        Image 7.

\"table\"
                                                                             Image 8.

\"property\"
                                                                        Image 9.

Now open Default.aspx and do the following code:<\/p>\n\n\n\n

    \n
  1. <%@ Page Language=”C#” AutoEventWireup=”true” CodeBehind=”Default.aspx.cs” Inherits=”CRUDUsingEntityFramework.Default” %>  <\/li>\n\n\n\n
  2. <!DOCTYPE html>  <\/li>\n\n\n\n
  3. <html xmlns=”http:\/\/www.w3.org\/1999\/xhtml”>  <\/li>\n\n\n\n
  4. <head runat=”server”>  <\/li>\n\n\n\n
  5.     <title>CRUD Operation Using Entity Framework In ASP.NET Grid View<\/title>  <\/li>\n\n\n\n
  6. <\/head>  <\/li>\n\n\n\n
  7. <body>  <\/li>\n\n\n\n
  8.     <form id=”form1″ runat=”server”>  <\/li>\n\n\n\n
  9.         <div>  <\/li>\n\n\n\n
  10.             <table style=”border: solid 15px blue; width: 100%; vertical-align: central;”>  <\/li>\n\n\n\n
  11.                 <tr>  <\/li>\n\n\n\n
  12.                     <td style=”padding-left: 20px; padding-top: 20px; padding-bottom: 20px;   <\/li>\n\n\n\n
  13.                         background-color: skyblue; font-family: ‘Times New Roman’;   <\/li>\n\n\n\n
  14.                             font-size: 20pt; color: red;”>CRUD Operation Using Entity Framework In ASP.NET Grid View  <\/li>\n\n\n\n
  15.                     <\/td>  <\/li>\n\n\n\n
  16.                 <\/tr>  <\/li>\n\n\n\n
  17.                 <tr>  <\/li>\n\n\n\n
  18.                     <td style=”text-align: left;”>  <\/li>\n\n\n\n
  19.   <\/li>\n\n\n\n
  20.                         <asp:GridView ID=”GVEmployee” runat=”server”   <\/li>\n\n\n\n
  21.                             AutoGenerateColumns=”False” ShowFooter=”True”   <\/li>\n\n\n\n
  22.                             PageSize=”10″ AllowPaging=”true”  <\/li>\n\n\n\n
  23.                             OnRowCommand=”GVEmployee_RowCommand”  <\/li>\n\n\n\n
  24.                             DataKeyNames=”Emp_ID” CellPadding=”4″ ForeColor=”#333333″  <\/li>\n\n\n\n
  25.                             GridLines=”None” OnRowCancelingEdit=”GVEmployee_RowCancelingEdit”  <\/li>\n\n\n\n
  26.                             OnRowEditing=”GVEmployee_RowEditing”  <\/li>\n\n\n\n
  27.                             OnRowUpdating=”GVEmployee_RowUpdating”  <\/li>\n\n\n\n
  28.                             OnRowDeleting=”GVEmployee_RowDeleting”  <\/li>\n\n\n\n
  29.                             OnPageIndexChanging=”GVEmployee_OnPageIndexChanging”>  <\/li>\n\n\n\n
  30.                             <AlternatingRowStyle BackColor=”White” \/>  <\/li>\n\n\n\n
  31.                             <Columns>  <\/li>\n\n\n\n
  32.                                 <asp:TemplateField HeaderText=”Employee Name” HeaderStyle-HorizontalAlign=”Left”>  <\/li>\n\n\n\n
  33.                                     <EditItemTemplate>  <\/li>\n\n\n\n
  34.                                         <asp:TextBox ID=”txtEmpName” runat=”server” Text='<%# Bind(“Name”) %>’><\/asp:TextBox>  <\/li>\n\n\n\n
  35.                                         <asp:RequiredFieldValidator ID=”valEmpName” runat=”server” ControlToValidate=”txtEmpName”  <\/li>\n\n\n\n
  36.                                             Display=”Dynamic” ErrorMessage=”Employee Name is required.” ForeColor=”Red” SetFocusOnError=”True”  <\/li>\n\n\n\n
  37.                                             ValidationGroup=”vldEditRecord”>*<\/asp:RequiredFieldValidator>  <\/li>\n\n\n\n
  38.                                     <\/EditItemTemplate>  <\/li>\n\n\n\n
  39.                                     <ItemTemplate>  <\/li>\n\n\n\n
  40.                                         <asp:Label ID=”lblEmpName” runat=”server” Text='<%# Bind(“Name”) %>’><\/asp:Label>  <\/li>\n\n\n\n
  41.                                     <\/ItemTemplate>  <\/li>\n\n\n\n
  42.                                     <FooterTemplate>  <\/li>\n\n\n\n
  43.                                         <asp:TextBox ID=”txtEmpNameNew” runat=”server”><\/asp:TextBox>  <\/li>\n\n\n\n
  44.                                         <asp:RequiredFieldValidator ID=”valEmpNameNew” runat=”server” ControlToValidate=”txtEmpNameNew”  <\/li>\n\n\n\n
  45.                                             Display=”Dynamic” ErrorMessage=”Employee Name is required.” ForeColor=”Red” SetFocusOnError=”True”  <\/li>\n\n\n\n
  46.                                             ValidationGroup=”vldNewRecord”>*<\/asp:RequiredFieldValidator>  <\/li>\n\n\n\n
  47.                                     <\/FooterTemplate>  <\/li>\n\n\n\n
  48.                                 <\/asp:TemplateField>  <\/li>\n\n\n\n
  49.                                 <asp:TemplateField HeaderText=”Designation” HeaderStyle-HorizontalAlign=”Left”>  <\/li>\n\n\n\n
  50.                                     <EditItemTemplate>  <\/li>\n\n\n\n
  51.                                         <asp:TextBox ID=”txtDesignation” runat=”server” Text='<%# Bind(“Designation”) %>’><\/asp:TextBox>  <\/li>\n\n\n\n
  52.                                         <asp:RequiredFieldValidator ID=”valDesignation” runat=”server” ControlToValidate=”txtDesignation”  <\/li>\n\n\n\n
  53.                                             Display=”Dynamic” ErrorMessage=”Designation is required.” ForeColor=”Red” SetFocusOnError=”True”  <\/li>\n\n\n\n
  54.                                             ValidationGroup=”vldEditRecord”>*<\/asp:RequiredFieldValidator>  <\/li>\n\n\n\n
  55.                                     <\/EditItemTemplate>  <\/li>\n\n\n\n
  56.                                     <ItemTemplate>  <\/li>\n\n\n\n
  57.                                         <asp:Label ID=”lblDesignation” runat=”server” Text='<%# Bind(“Designation”) %>’><\/asp:Label>  <\/li>\n\n\n\n
  58.                                     <\/ItemTemplate>  <\/li>\n\n\n\n
  59.                                     <FooterTemplate>  <\/li>\n\n\n\n
  60.                                         <asp:TextBox ID=”txtDesignationNew” runat=”server”><\/asp:TextBox>  <\/li>\n\n\n\n
  61.                                         <asp:RequiredFieldValidator ID=”valDesignationNew” runat=”server” ControlToValidate=”txtDesignationNew”  <\/li>\n\n\n\n
  62.                                             Display=”Dynamic” ErrorMessage=”Designation is required.” ForeColor=”Red” SetFocusOnError=”True”  <\/li>\n\n\n\n
  63.                                             ValidationGroup=”vldNewRecord”>*<\/asp:RequiredFieldValidator>  <\/li>\n\n\n\n
  64.                                     <\/FooterTemplate>  <\/li>\n\n\n\n
  65.                                 <\/asp:TemplateField>  <\/li>\n\n\n\n
  66.                                 <asp:TemplateField HeaderText=”City” HeaderStyle-HorizontalAlign=”Left”>  <\/li>\n\n\n\n
  67.                                     <EditItemTemplate>  <\/li>\n\n\n\n
  68.                                         <asp:TextBox ID=”txtCity” runat=”server” Text='<%# Bind(“City”) %>’><\/asp:TextBox>  <\/li>\n\n\n\n
  69.                                         <asp:RequiredFieldValidator ID=”valCity” runat=”server” ControlToValidate=”txtCity”  <\/li>\n\n\n\n
  70.                                             Display=”Dynamic” ErrorMessage=”City is required.” ForeColor=”Red” SetFocusOnError=”True”  <\/li>\n\n\n\n
  71.                                             ValidationGroup=”vldEditRecord”>*<\/asp:RequiredFieldValidator>  <\/li>\n\n\n\n
  72.                                     <\/EditItemTemplate>  <\/li>\n\n\n\n
  73.                                     <ItemTemplate>  <\/li>\n\n\n\n
  74.                                         <asp:Label ID=”lblCity” runat=”server” Text='<%# Bind(“City”) %>’><\/asp:Label>  <\/li>\n\n\n\n
  75.                                     <\/ItemTemplate>  <\/li>\n\n\n\n
  76.                                     <FooterTemplate>  <\/li>\n\n\n\n
  77.                                         <asp:TextBox ID=”txtCityNew” runat=”server”><\/asp:TextBox>  <\/li>\n\n\n\n
  78.                                         <asp:RequiredFieldValidator ID=”valCityNew” runat=”server” ControlToValidate=”txtCityNew”  <\/li>\n\n\n\n
  79.                                             Display=”Dynamic” ErrorMessage=”City is required.” ForeColor=”Red” SetFocusOnError=”True”  <\/li>\n\n\n\n
  80.                                             ValidationGroup=”vldNewRecord”>*<\/asp:RequiredFieldValidator>  <\/li>\n\n\n\n
  81.                                     <\/FooterTemplate>  <\/li>\n\n\n\n
  82.                                 <\/asp:TemplateField>  <\/li>\n\n\n\n
  83.                                 <asp:TemplateField HeaderText=”State” HeaderStyle-HorizontalAlign=”Left”>  <\/li>\n\n\n\n
  84.                                     <EditItemTemplate>  <\/li>\n\n\n\n
  85.                                         <asp:TextBox ID=”txtState” runat=”server” Text='<%# Bind(“State”) %>’><\/asp:TextBox>  <\/li>\n\n\n\n
  86.                                         <asp:RequiredFieldValidator ID=”valState” runat=”server” ControlToValidate=”txtState”  <\/li>\n\n\n\n
  87.                                             Display=”Dynamic” ErrorMessage=”State is required.” ForeColor=”Red” SetFocusOnError=”True”  <\/li>\n\n\n\n
  88.                                             ValidationGroup=”vldEditRecord”>*<\/asp:RequiredFieldValidator>  <\/li>\n\n\n\n
  89.                                     <\/EditItemTemplate>  <\/li>\n\n\n\n
  90.                                     <ItemTemplate>  <\/li>\n\n\n\n
  91.                                         <asp:Label ID=”lblState” runat=”server” Text='<%# Bind(“State”) %>’><\/asp:Label>  <\/li>\n\n\n\n
  92.                                     <\/ItemTemplate>  <\/li>\n\n\n\n
  93.                                     <FooterTemplate>  <\/li>\n\n\n\n
  94.                                         <asp:TextBox ID=”txtStateNew” runat=”server”><\/asp:TextBox>  <\/li>\n\n\n\n
  95.                                         <asp:RequiredFieldValidator ID=”valStateNew” runat=”server” ControlToValidate=”txtStateNew”  <\/li>\n\n\n\n
  96.                                             Display=”Dynamic” ErrorMessage=”State is required.” ForeColor=”Red” SetFocusOnError=”True”  <\/li>\n\n\n\n
  97.                                             ValidationGroup=”vldNewRecord”>*<\/asp:RequiredFieldValidator>  <\/li>\n\n\n\n
  98.                                     <\/FooterTemplate>  <\/li>\n\n\n\n
  99.                                 <\/asp:TemplateField>  <\/li>\n\n\n\n
  100.   <\/li>\n\n\n\n
  101.                                 <asp:TemplateField HeaderText=”Country” HeaderStyle-HorizontalAlign=”Left”>  <\/li>\n\n\n\n
  102.                                     <EditItemTemplate>  <\/li>\n\n\n\n
  103.                                         <asp:TextBox ID=”txtCountry” runat=”server” Text='<%# Bind(“Country”) %>’><\/asp:TextBox>  <\/li>\n\n\n\n
  104.                                         <asp:RequiredFieldValidator ID=”valCountry” runat=”server” ControlToValidate=”txtCountry”  <\/li>\n\n\n\n
  105.                                             Display=”Dynamic” ErrorMessage=”Country is required.” ForeColor=”Red” SetFocusOnError=”True”  <\/li>\n\n\n\n
  106.                                             ValidationGroup=”vldEditRecord”>*<\/asp:RequiredFieldValidator>  <\/li>\n\n\n\n
  107.                                     <\/EditItemTemplate>  <\/li>\n\n\n\n
  108.   <\/li>\n\n\n\n
  109.                                     <ItemTemplate>  <\/li>\n\n\n\n
  110.                                         <asp:Label ID=”lblCountry” runat=”server” Text='<%# Bind(“Country”) %>’><\/asp:Label>  <\/li>\n\n\n\n
  111.                                     <\/ItemTemplate>  <\/li>\n\n\n\n
  112.   <\/li>\n\n\n\n
  113.                                     <FooterTemplate>  <\/li>\n\n\n\n
  114.                                         <asp:TextBox ID=”txtCountryNew” runat=”server”><\/asp:TextBox>  <\/li>\n\n\n\n
  115.                                         <asp:RequiredFieldValidator ID=”valCountryNew” runat=”server” ControlToValidate=”txtCountryNew”  <\/li>\n\n\n\n
  116.                                             Display=”Dynamic” ErrorMessage=”Country is required.” ForeColor=”Red” SetFocusOnError=”True”  <\/li>\n\n\n\n
  117.                                             ValidationGroup=”vldNewRecord”>*<\/asp:RequiredFieldValidator>  <\/li>\n\n\n\n
  118.                                     <\/FooterTemplate>  <\/li>\n\n\n\n
  119.                                 <\/asp:TemplateField>  <\/li>\n\n\n\n
  120.   <\/li>\n\n\n\n
  121.                                 <asp:TemplateField HeaderText=””>  <\/li>\n\n\n\n
  122.                                     <ItemTemplate>  <\/li>\n\n\n\n
  123.                                         <asp:LinkButton ID=”lnkEdit” runat=”server” Text=”” CommandName=”Edit” ToolTip=”Edit”>  <\/li>\n\n\n\n
  124.                                             <img src=”..\/Images\/Edit.png” width=”30px” \/>  <\/li>\n\n\n\n
  125.                                         <\/asp:LinkButton>  <\/li>\n\n\n\n
  126.                                         <asp:LinkButton ID=”lnkDelete” runat=”server” Text=”Delete” CommandName=”Delete”  <\/li>\n\n\n\n
  127.                                             ToolTip=”Delete” OnClientClick=’return confirm(“Are you sure you want to delete employee record?”);’>  <\/li>\n\n\n\n
  128.                                             <img src=”..\/Images\/Delete.jpg”  width=”30px” \/>  <\/li>\n\n\n\n
  129.                                         <\/asp:LinkButton>  <\/li>\n\n\n\n
  130.                                     <\/ItemTemplate>  <\/li>\n\n\n\n
  131.   <\/li>\n\n\n\n
  132.                                     <EditItemTemplate>  <\/li>\n\n\n\n
  133.                                         <asp:LinkButton ID=”lnkInsert” runat=”server” Text=”” ValidationGroup=”vldEditRecord”   <\/li>\n\n\n\n
  134.                                             CommandName=”Update” ToolTip=”Save”  <\/li>\n\n\n\n
  135.                                             OnClientClick=’return confirm(“Employee Record Saved Successfully.”);’>  <\/li>\n\n\n\n
  136.                                                  <img src=”..\/Images\/Save2.jpg”  width=”30px” \/>  <\/li>\n\n\n\n
  137.                                         <\/asp:LinkButton>  <\/li>\n\n\n\n
  138.                                         <asp:LinkButton ID=”lnkCancel” runat=”server” Text=”” CommandName=”Cancel” ToolTip=”Cancel”>  <\/li>\n\n\n\n
  139.                                             <img src=”..\/Images\/Cancel.jpg”  width=”30px” \/>  <\/li>\n\n\n\n
  140.                                         <\/asp:LinkButton>  <\/li>\n\n\n\n
  141.                                     <\/EditItemTemplate>  <\/li>\n\n\n\n
  142.   <\/li>\n\n\n\n
  143.                                     <FooterTemplate>  <\/li>\n\n\n\n
  144.                                         <asp:LinkButton ID=”lnkInsert” runat=”server” Text=”” ValidationGroup=”vldNewRecord”   <\/li>\n\n\n\n
  145.                                             CommandName=”InsertNew” ToolTip=”Add New Employee”  <\/li>\n\n\n\n
  146.                                             OnClientClick=’return confirm(“Employee Record addedd Successfully.”);’>  <\/li>\n\n\n\n
  147.                                                  <img src=”..\/Images\/Insert.jpg”  width=”30px” \/>  <\/li>\n\n\n\n
  148.                                         <\/asp:LinkButton>  <\/li>\n\n\n\n
  149.                                         <asp:LinkButton ID=”lnkCancel” runat=”server” Text=”” CommandName=”CancelNew” ToolTip=”Cancel”>  <\/li>\n\n\n\n
  150.                                             <img src=”..\/Images\/Cancel.jpg”  width=”30px” \/>  <\/li>\n\n\n\n
  151.                                         <\/asp:LinkButton>  <\/li>\n\n\n\n
  152.                                     <\/FooterTemplate>  <\/li>\n\n\n\n
  153.   <\/li>\n\n\n\n
  154.                                 <\/asp:TemplateField>  <\/li>\n\n\n\n
  155.                             <\/Columns>  <\/li>\n\n\n\n
  156.                             <EditRowStyle BackColor=”#2461BF” \/>  <\/li>\n\n\n\n
  157.                             <FooterStyle BackColor=”#507CD1″ Font-Bold=”True” ForeColor=”White” \/>  <\/li>\n\n\n\n
  158.                             <HeaderStyle BackColor=”#507CD1″ Font-Bold=”True” ForeColor=”White” \/>  <\/li>\n\n\n\n
  159.                             <PagerStyle BackColor=”#2461BF” ForeColor=”White” HorizontalAlign=”Center” \/>  <\/li>\n\n\n\n
  160.                             <RowStyle BackColor=”#EFF3FB” \/>  <\/li>\n\n\n\n
  161.                             <SelectedRowStyle BackColor=”#D1DDF1″ Font-Bold=”True” ForeColor=”#333333″ \/>  <\/li>\n\n\n\n
  162.                             <SortedAscendingCellStyle BackColor=”#F5F7FB” \/>  <\/li>\n\n\n\n
  163.                             <SortedAscendingHeaderStyle BackColor=”#6D95E1″ \/>  <\/li>\n\n\n\n
  164.                             <SortedDescendingCellStyle BackColor=”#E9EBEF” \/>  <\/li>\n\n\n\n
  165.                             <SortedDescendingHeaderStyle BackColor=”#4870BE” \/>  <\/li>\n\n\n\n
  166.                         <\/asp:GridView>  <\/li>\n\n\n\n
  167.                     <\/td>  <\/li>\n\n\n\n
  168.                 <\/tr>  <\/li>\n\n\n\n
  169.             <\/table>  <\/li>\n\n\n\n
  170.         <\/div>  <\/li>\n\n\n\n
  171.     <\/form>  <\/li>\n\n\n\n
  172. <\/body>  <\/li>\n\n\n\n
  173. <\/html>  <\/li>\n<\/ol>\n\n\n\n

    Now my aspx.cs code is:<\/strong><\/p>\n\n\n\n

      \n
    1. using<\/strong> System;  <\/li>\n\n\n\n
    2. using<\/strong> System.Collections.Generic;  <\/li>\n\n\n\n
    3. using<\/strong> System.Linq;  <\/li>\n\n\n\n
    4. using<\/strong> System.Web;  <\/li>\n\n\n\n
    5. using<\/strong> System.Web.UI;  <\/li>\n\n\n\n
    6. using<\/strong> System.Web.UI.WebControls;  <\/li>\n\n\n\n
    7.   <\/li>\n\n\n\n
    8. namespace<\/strong> CRUDUsingEntityFramework  <\/li>\n\n\n\n
    9. {  <\/li>\n\n\n\n
    10.     public<\/strong> partial class<\/strong> Default : System.Web.UI.Page  <\/li>\n\n\n\n
    11.     {  <\/li>\n\n\n\n
    12.         protected<\/strong> void<\/strong> Page_Load(object<\/strong> sender, EventArgs e)  <\/li>\n\n\n\n
    13.         {  <\/li>\n\n\n\n
    14.             if<\/strong> (!IsPostBack)  <\/li>\n\n\n\n
    15.             {  <\/li>\n\n\n\n
    16.                 BindGrid();  <\/li>\n\n\n\n
    17.             }  <\/li>\n\n\n\n
    18.              <\/li>\n\n\n\n
    19.         }  <\/li>\n\n\n\n
    20.   <\/li>\n\n\n\n
    21.         void<\/strong> BindGrid()  <\/li>\n\n\n\n
    22.         {  <\/li>\n\n\n\n
    23.             using<\/strong> (EmployeeManagementEntities context = new<\/strong> EmployeeManagementEntities())  <\/li>\n\n\n\n
    24.             {  <\/li>\n\n\n\n
    25.                 if<\/strong> (context.Employee.Count() > 0)  <\/li>\n\n\n\n
    26.                 {  <\/li>\n\n\n\n
    27.                     GVEmployee.DataSource = (from em in<\/strong> context.Employee  <\/li>\n\n\n\n
    28.                                              select new<\/strong> { em.Emp_ID, em.Name, em.Designation, em.City, em.Country, em.State }).ToList();  <\/li>\n\n\n\n
    29.                     GVEmployee.DataBind();  <\/li>\n\n\n\n
    30.                 }  <\/li>\n\n\n\n
    31.                 else<\/strong>  <\/li>\n\n\n\n
    32.                 {  <\/li>\n\n\n\n
    33.                     GVEmployee.DataSource = null<\/strong>;  <\/li>\n\n\n\n
    34.                     GVEmployee.DataBind();  <\/li>\n\n\n\n
    35.                 }  <\/li>\n\n\n\n
    36.             }  <\/li>\n\n\n\n
    37.         }  <\/li>\n\n\n\n
    38.   <\/li>\n\n\n\n
    39.         protected<\/strong> void<\/strong> GVEmployee_OnPageIndexChanging(object<\/strong> sender, GridViewPageEventArgs e)  <\/li>\n\n\n\n
    40.         {  <\/li>\n\n\n\n
    41.             GVEmployee.PageIndex = e.NewPageIndex;  <\/li>\n\n\n\n
    42.             BindGrid();  <\/li>\n\n\n\n
    43.         }  <\/li>\n\n\n\n
    44.   <\/li>\n\n\n\n
    45.         protected<\/strong> void<\/strong> GVEmployee_RowCommand(object<\/strong> sender, GridViewCommandEventArgs e)  <\/li>\n\n\n\n
    46.         {  <\/li>\n\n\n\n
    47.             if<\/strong> (e.CommandName == “InsertNew”)  <\/li>\n\n\n\n
    48.             {  <\/li>\n\n\n\n
    49.                 GridViewRow row = GVEmployee.FooterRow;  <\/li>\n\n\n\n
    50.   <\/li>\n\n\n\n
    51.                 TextBox txtName = row.FindControl(“txtEmpNameNew”) as<\/strong> TextBox;  <\/li>\n\n\n\n
    52.                 TextBox txtDesignation = row.FindControl(“txtDesignationNew”) as<\/strong> TextBox;  <\/li>\n\n\n\n
    53.                 TextBox txtCity = row.FindControl(“txtCityNew”) as<\/strong> TextBox;  <\/li>\n\n\n\n
    54.                 TextBox txtState = row.FindControl(“txtStateNew”) as<\/strong> TextBox;  <\/li>\n\n\n\n
    55.                 TextBox txtCountry = row.FindControl(“txtCountryNew”) as<\/strong> TextBox;  <\/li>\n\n\n\n
    56.   <\/li>\n\n\n\n
    57.                 using<\/strong> (EmployeeManagementEntities context = new<\/strong> EmployeeManagementEntities())  <\/li>\n\n\n\n
    58.                 {  <\/li>\n\n\n\n
    59.                     Employee obj = new<\/strong> Employee();  <\/li>\n\n\n\n
    60.                     obj.Name = txtName.Text;  <\/li>\n\n\n\n
    61.                     obj.Designation = txtDesignation.Text;  <\/li>\n\n\n\n
    62.                     obj.City = txtCity.Text;  <\/li>\n\n\n\n
    63.                     obj.State = txtState.Text;  <\/li>\n\n\n\n
    64.                     obj.Country = txtCountry.Text;  <\/li>\n\n\n\n
    65.                     context.Employee.Add(obj);  <\/li>\n\n\n\n
    66.                     context.SaveChanges();   <\/li>\n\n\n\n
    67.                     BindGrid();  <\/li>\n\n\n\n
    68.                 }  <\/li>\n\n\n\n
    69.   <\/li>\n\n\n\n
    70.             }  <\/li>\n\n\n\n
    71.         }  <\/li>\n\n\n\n
    72.         protected<\/strong> void<\/strong> GVEmployee_RowEditing(object<\/strong> sender, GridViewEditEventArgs e)  <\/li>\n\n\n\n
    73.         {  <\/li>\n\n\n\n
    74.             GVEmployee.EditIndex = e.NewEditIndex;  <\/li>\n\n\n\n
    75.             BindGrid();  <\/li>\n\n\n\n
    76.         }  <\/li>\n\n\n\n
    77.         protected<\/strong> void<\/strong> GVEmployee_RowCancelingEdit(object<\/strong> sender, GridViewCancelEditEventArgs e)  <\/li>\n\n\n\n
    78.         {  <\/li>\n\n\n\n
    79.             GVEmployee.EditIndex = -1;  <\/li>\n\n\n\n
    80.             BindGrid();  <\/li>\n\n\n\n
    81.         }  <\/li>\n\n\n\n
    82.         protected<\/strong> void<\/strong> GVEmployee_RowUpdating(object<\/strong> sender, GridViewUpdateEventArgs e)  <\/li>\n\n\n\n
    83.         {  <\/li>\n\n\n\n
    84.             GridViewRow row = GVEmployee.Rows[e.RowIndex];  <\/li>\n\n\n\n
    85.   <\/li>\n\n\n\n
    86.             TextBox txtName = row.FindControl(“txtEmpName”) as<\/strong> TextBox;  <\/li>\n\n\n\n
    87.             TextBox txtDesignation = row.FindControl(“txtDesignation”) as<\/strong> TextBox;  <\/li>\n\n\n\n
    88.             TextBox txtCity = row.FindControl(“txtCity”) as<\/strong> TextBox;  <\/li>\n\n\n\n
    89.             TextBox txtState = row.FindControl(“txtState”) as<\/strong> TextBox;  <\/li>\n\n\n\n
    90.             TextBox txtCountry = row.FindControl(“txtCountry”) as<\/strong> TextBox;  <\/li>\n\n\n\n
    91.   <\/li>\n\n\n\n
    92.   <\/li>\n\n\n\n
    93.             using<\/strong> (EmployeeManagementEntities context = new<\/strong> EmployeeManagementEntities())  <\/li>\n\n\n\n
    94.             {  <\/li>\n\n\n\n
    95.                 int<\/strong> employeeID = Convert.ToInt32(GVEmployee.DataKeys[e.RowIndex].Value);  <\/li>\n\n\n\n
    96.                 Employee obj = context.Employee.First(x => x.Emp_ID == employeeID);  <\/li>\n\n\n\n
    97.                 obj.Name = txtName.Text;  <\/li>\n\n\n\n
    98.                 obj.Designation = txtDesignation.Text;  <\/li>\n\n\n\n
    99.                 obj.City = txtCity.Text;  <\/li>\n\n\n\n
    100.                 obj.State = txtState.Text;  <\/li>\n\n\n\n
    101.                 obj.Country = txtCountry.Text;  <\/li>\n\n\n\n
    102.                 context.SaveChanges();  <\/li>\n\n\n\n
    103.                  <\/li>\n\n\n\n
    104.                 GVEmployee.EditIndex = -1;  <\/li>\n\n\n\n
    105.                 BindGrid();  <\/li>\n\n\n\n
    106.             }  <\/li>\n\n\n\n
    107.   <\/li>\n\n\n\n
    108.         }  <\/li>\n\n\n\n
    109.   <\/li>\n\n\n\n
    110.         protected<\/strong> void<\/strong> GVEmployee_RowDeleting(object<\/strong> sender, GridViewDeleteEventArgs e)  <\/li>\n\n\n\n
    111.         {  <\/li>\n\n\n\n
    112.             int<\/strong> employeeID = Convert.ToInt32(GVEmployee.DataKeys[e.RowIndex].Value);  <\/li>\n\n\n\n
    113.             using<\/strong> (EmployeeManagementEntities context = new<\/strong> EmployeeManagementEntities())  <\/li>\n\n\n\n
    114.             {  <\/li>\n\n\n\n
    115.                 Employee obj = context.Employee.First(x => x.Emp_ID == employeeID);  <\/li>\n\n\n\n
    116.                 context.Employee.Remove(obj);  <\/li>\n\n\n\n
    117.                 context.SaveChanges();  <\/li>\n\n\n\n
    118.                 BindGrid();   <\/li>\n\n\n\n
    119.             }  <\/li>\n\n\n\n
    120.         }  <\/li>\n\n\n\n
    121.     }  <\/li>\n\n\n\n
    122. }  <\/li>\n<\/ol>\n\n\n\n

      Now run your application: All Record<\/p>\n\n\n\n

      \"crud<\/figure>\n\n\n\n

                                                                                 Image 10.<\/p>\n\n\n\n

      Add a new record:<\/p>\n\n\n\n

      \"record\"\/<\/figure>\n\n\n\n

                                                                              Image 11.<\/p>\n\n\n\n

      Go to Page 2 as I have Page Size 10 here.<\/p>\n\n\n\n

      \"entity<\/figure>\n\n\n\n

                                                                                 Image 12.<\/p>\n\n\n\n

      Now edit any record:<\/p>\n\n\n\n

      \"edit<\/figure>\n\n\n\n

                                                                              Image 13.<\/p>\n\n\n\n

      \"page<\/figure>\n\n\n\n

                                                                           Image 14.<\/p>\n\n\n\n

      Now delete any record:<\/p>\n\n\n\n

      \"delete<\/figure>\n\n\n\n

                                                                           Image 15.<\/p>\n","protected":false},"excerpt":{"rendered":"

      Here in this application I will use…<\/p>\n","protected":false},"author":1,"featured_media":3880,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[189],"tags":[],"class_list":["post-3879","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-asp-net"],"_links":{"self":[{"href":"https:\/\/isophal.com\/news\/wp-json\/wp\/v2\/posts\/3879","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/isophal.com\/news\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/isophal.com\/news\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/isophal.com\/news\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/isophal.com\/news\/wp-json\/wp\/v2\/comments?post=3879"}],"version-history":[{"count":1,"href":"https:\/\/isophal.com\/news\/wp-json\/wp\/v2\/posts\/3879\/revisions"}],"predecessor-version":[{"id":3881,"href":"https:\/\/isophal.com\/news\/wp-json\/wp\/v2\/posts\/3879\/revisions\/3881"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/isophal.com\/news\/wp-json\/wp\/v2\/media\/3880"}],"wp:attachment":[{"href":"https:\/\/isophal.com\/news\/wp-json\/wp\/v2\/media?parent=3879"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/isophal.com\/news\/wp-json\/wp\/v2\/categories?post=3879"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/isophal.com\/news\/wp-json\/wp\/v2\/tags?post=3879"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}