CRUD operation using asp.net

-



CRUD  operation using asp.net

Write the below code in .aspx page

<head runat="server">
    <title></title>
     <style type="text/css">
        .WhiteBG {
            background-color: White;
       
        }

        .modalpopup {
            background-color: #ADADAD;
            filter: Alpha(Opacity=70);
            opacity: 0.70;
            -moz-opacity: 0.70;
        }
    </style>
</head>
<body>
    <form id="form1" runat="server">
    <div>
     <asp:ScriptManager ID="script1" runat="server"></asp:ScriptManager>
        <div>
            <asp:linkbutton id="btnAdd" runat="server" Text="add" onclick="btnAdd_Click"></asp:linkbutton>
            <asp:GridView ID="Grid1" runat="server" AutoGenerateColumns="false" OnRowCommand="Grid1_RowCommand">
                <Columns>
                    <asp:TemplateField HeaderText="id" Visible="true">
                        <ItemTemplate>
                            <asp:Label ID="lblId" runat="server" Text='<%#Bind("Emp_Id")%>'></asp:Label>
                        </ItemTemplate>
                    </asp:TemplateField>
                    <asp:TemplateField HeaderText="First Name" Visible="true">
                        <ItemTemplate>
                            <asp:Label ID="lblFName" runat="server" Text='<%#Bind("Emp_FName")%>'></asp:Label>
                        </ItemTemplate>
                    </asp:TemplateField>
                    <asp:TemplateField HeaderText="Last Name" Visible="true">
                        <ItemTemplate>
                            <asp:Label ID="lblLName" runat="server" Text='<%#Bind("Emp_LName")%>'></asp:Label>
                        </ItemTemplate>
                    </asp:TemplateField>
                   <asp:TemplateField HeaderText="Age" Visible="true">
                       <ItemTemplate>
                           <asp:Label ID="lblAge" runat="server" Text='<%#Bind("Age") %>'></asp:Label>
                       </ItemTemplate>
                   </asp:TemplateField>
                    <asp:TemplateField HeaderText="Gender" Visible="true">
                        <ItemTemplate>
                            <asp:Label ID="lblGender" runat="server" Text='<%#Bind("Gender") %>'></asp:Label>
                        </ItemTemplate>
                    </asp:TemplateField>
                    <asp:TemplateField HeaderText="View" Visible="true">
                        <ItemTemplate>
                            <asp:LinkButton ID="btnView" runat="server" CommandName="View">View</asp:LinkButton>
                        </ItemTemplate>
                    </asp:TemplateField>
                    <asp:TemplateField HeaderText="Delete" Visible="true">
                        <ItemTemplate>
                            <asp:LinkButton ID="btnDelete" runat="server" CommandName="Delete">Delete</asp:LinkButton>
                        </ItemTemplate>
                    </asp:TemplateField>
                    <asp:TemplateField HeaderText="Edi                                                                                                                                          bbb   t" Visible="true">
                        <ItemTemplate>                                                               
                            <asp:LinkButton ID="btnEdit" runat="server" CommandName="Editt">Edit</asp:LinkButton>
                        </ItemTemplate>
                    </asp:TemplateField>
                </Columns>
            </asp:GridView>
        <%--for Add--%>
            <asp:UpdatePanel ID="Add" runat="server" >
                <ContentTemplate>
                    <asp:Panel ID="AddPAnel" runat="server" CssClass="WhiteBG" Style="display:none; width: 455px; padding: 5px; min-height: 96px;">
                        <table>
                            <tr>
                                <td>
                                    Fisrt Name
                                </td>
                                <td>
                                    <asp:TextBox ID="txtFNAme" runat="server"></asp:TextBox>
                                   <%-- <asp:TextBox ID="AddFName" runat="server"></asp:TextBox>--%>
                                </td>
                            </tr>
                            <tr>
                                <td>
                                    Last Name
                                </td>
                                <td>
                                    <asp:TextBox ID="txtLName" runat="server"></asp:TextBox>
                                </td>
                            </tr>
                            <tr>
                                <td>
                                    Age
                                </td>
                                <td>
                                    <asp:TextBox ID="txtAge" runat="server"></asp:TextBox>
                                </td>
                            </tr>
                            <tr>
                                <td>
                                    Gender
                                </td>

                                <td>
                                    <asp:DropDownList ID="DrpGender" runat="server">
                                        <asp:ListItem Text="Pleas Select"></asp:ListItem>
                                        <asp:ListItem Text="Male" Value="Male"></asp:ListItem>
                                        <asp:ListItem Text="Female" Value="Female"></asp:ListItem>
                                    </asp:DropDownList>
                                </td>
                            </tr>
                            <tr>
                                <td>
                                    <asp:Button ID="AddEmployee" runat="server" Text="Save" OnClick="AddEmployee_Click"/>
                                </td>
                                <td>
                                    <asp:Button ID="CancelEmp" runat="server" Text="Cancel" />
                                </td>
                            </tr>
                        </table>
                    </asp:Panel>
                       <asp:LinkButton ID="LinkButton6" runat="server">
                </asp:LinkButton>
                  <cc1:ModalPopupExtender ID="ModalPopupExntendarAdd"  runat="server" PopupControlID="AddPAnel" CancelControlID="CancelEmp"
                      BehaviorID="AddEmployee" TargetControlID="LinkButton6"></cc1:ModalPopupExtender>
                </ContentTemplate>
                <Triggers>
                    <asp:AsyncPostBackTrigger ControlID="AddEmployee" EventName="Click" />
                </Triggers>
            </asp:UpdatePanel>
            <%--for View--%>
            <asp:UpdatePanel ID="UpdatePanelView" runat="server">
                <ContentTemplate>
                    <asp:Panel ID="PanelView" runat="server" CssClass="WhiteBG" Style="display:none; width: 455px; padding: 5px; min-height: 96px;">
                        <table>
                             <tr>
                               
                                <td>
                                    <asp:Label ID="VId" runat="server" Visible="false"></asp:Label>
                                   <%-- <asp:TextBox ID="AddFName" runat="server"></asp:TextBox>--%>
                                </td>
                            </tr>
                            <tr>
                                <td>
                                    Fisrt Name
                                </td>
                                <td>
                                    <asp:Label ID="VFName" runat="server"></asp:Label>
                                   <%-- <asp:TextBox ID="AddFName" runat="server"></asp:TextBox>--%>
                                </td>
                            </tr>
                            <tr>
                                <td>
                                    Last Name
                                </td>
                                <td>
                                    <asp:Label ID="VLName" runat="server"></asp:Label>
                                </td>
                            </tr>
                            <tr>
                                <td>
                                    Age
                                </td>
                                <td>
                                    <asp:Label ID="VAge" runat="server"></asp:Label>
                                </td>
                            </tr>
                            <tr>
                                <td>
                                    Gender
                                </td>

                                <td>
                                    <asp:Label ID="VGender" runat="server">
                                    </asp:Label>
                                </td>
                            </tr>
                            <tr>
                                
                                <td>
                                    <asp:Button ID="BtnCancelView" runat="server" Text="Cancel" />
                                </td>
                            </tr>
                        </table>
                    </asp:Panel>
                    <asp:LinkButton ID="linkbutton1" runat="server"></asp:LinkButton>
                    <cc1:ModalPopupExtender ID="ModalPopupExtenderView"
                         runat="server" TargetControlID="linkbutton1"
                         BehaviorID="BtnCancelView" PopupControlID="PanelView"
                        CancelControlID="BtnCancelView"></cc1:ModalPopupExtender>
                </ContentTemplate>
            </asp:UpdatePanel>

            <%--for edit--%>
            <asp:UpdatePanel ID="UpdatePanelEdit" runat="server" >
                <ContentTemplate>
                    <asp:Panel ID="PAnelEdit" runat="server" CssClass="WhiteBG" Style="display:none;s width: 455px; padding: 5px; min-height: 96px;">
                        <table>
                             <tr>                               
                                <td>
                                    <asp:Label ID="lblEditId" runat="server" Visible="false"></asp:Label>
                                   <%-- <asp:TextBox ID="AddFName" runat="server"></asp:TextBox>--%>
                                </td>
                            </tr>
                            <tr>
                                <td>
                                    Fisrt Name
                                </td>
                                <td>
                                    <asp:TextBox ID="EdFName" runat="server"></asp:TextBox>
                                   <%-- <asp:TextBox ID="AddFName" runat="server"></asp:TextBox>--%>
                                </td>
                            </tr>
                            <tr>
                                <td>
                                    Last Name
                                </td>
                                <td>
                                    <asp:TextBox ID="EdLName" runat="server"></asp:TextBox>
                                </td>
                            </tr>
                            <tr>
                                <td>
                                    Age
                                </td>
                                <td>
                                    <asp:TextBox ID="EdAge" runat="server"></asp:TextBox>
                                </td>
                            </tr>
                            <tr>
                                <td>
                                    Gender
                                </td>

                                <td>
                                    <asp:DropDownList ID="EdGender" runat="server">
                                        <asp:ListItem Text="Pleas Select"></asp:ListItem>
                                        <asp:ListItem Text="Male" Value="Male"></asp:ListItem>
                                        <asp:ListItem Text="Female" Value="Female"></asp:ListItem>
                                    </asp:DropDownList>
                                </td>
                            </tr>
                            <tr>
                                <td>
                                    <asp:Button ID="btnUpdate" runat="server" Text="Update" OnClick="btnUpdate_Click"/>
                                </td>
                                <td>
                                    <asp:Button ID="btnEditCanel" runat="server" Text="Cancel" />
                                </td>
                            </tr>
                        </table>
                    </asp:Panel>
                       <asp:LinkButton ID="LinkButton2" runat="server">
                </asp:LinkButton>
                  <cc1:ModalPopupExtender ID="ModalPopupExtenderEdit"  runat="server" PopupControlID="PAnelEdit" CancelControlID="btnEditCanel"
                      BehaviorID="btnUpdate" TargetControlID="LinkButton2"></cc1:ModalPopupExtender>
                </ContentTemplate>
                <Triggers>
                    <asp:AsyncPostBackTrigger ControlID="btnUpdate" EventName="Click" />
                </Triggers>
            </asp:UpdatePanel>
        </div>
    </div>
    </form>
</body>
Write the below code in aspx.cs page
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

namespace Grid_Crud_15_1_2019
{
    public partial class Grid : System.Web.UI.Page
    {
        CartDatabaseEntities entities = new CartDatabaseEntities();
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                bindGrid();
            }
            bindGrid();
        }
        private void bindGrid()
        {
            var data = entities.Employees.ToList();
            data = (from a in data
                    select new Employee
                    {
                        Age=a.Age,
                        Emp_FName=a.Emp_FName,
                        Emp_LName=a.Emp_LName,
                         Emp_Id=a.Emp_Id,
                         Gender=a.Gender
                    }).ToList();
            Grid1.DataSource = data;
            Grid1.DataBind();
        }
        protected void btnAdd_Click(object sender, EventArgs e)
        {
            ModalPopupExntendarAdd.Show();

        }

        protected void Grid1_RowCommand(object sender, GridViewCommandEventArgs e)
        {
            if (e.CommandName == "View")
            {
                LinkButton btn = (LinkButton)e.CommandSource as LinkButton;
                GridViewRow row = btn.NamingContainer as GridViewRow;
                VId.Text = ((Label)row.FindControl("lblId")).Text;
                VFName.Text = ((Label)row.FindControl("lblFName")).Text;
                VLName.Text = ((Label)row.FindControl("lblLName")).Text;
                VAge.Text = ((Label)row.FindControl("lblAge")).Text; 
                VGender.Text = ((Label)row.FindControl("lblGender")).Text;

                ModalPopupExtenderView.Show();
            }
            else if (e.CommandName == "Delete")
            {

            }
            else if (e.CommandName == "Editt")
            {


                ModalPopupExtenderEdit.Show();
                LinkButton btnEdit = (LinkButton)e.CommandSource as LinkButton;
                GridViewRow rowEdit = btnEdit.NamingContainer as GridViewRow;
                lblEditId.Text = ((Label)btnEdit.FindControl("lblId")).Text;
                EdFName.Text = ((Label)rowEdit.FindControl("lblFName")).Text;
                EdLName.Text = ((Label)rowEdit.FindControl("lblLName")).Text;
                EdAge.Text = ((Label)rowEdit.FindControl("lblAge")).Text;
                EdGender.Text = ((Label)rowEdit.FindControl("lblGender")).Text;

             
            }
            else { }
        }

        protected void AddEmployee_Click(object sender, EventArgs e)
        {
            Employee emp = new Employee();
            emp.Emp_FName = EdFName.Text.ToString();
            emp.Emp_LName = EdLName.Text.ToString();
            emp.Age = Convert.ToInt32(EdAge.Text);
            emp.Gender = EdGender.SelectedItem.Text.ToString();
            entities.Employees.Add(emp);
            entities.SaveChanges();
            bindGrid();
        }

        protected void btnUpdate_Click(object sender, EventArgs e)
            {
            int id = Convert.ToInt32(lblEditId.Text);
            Employee emp =entities.Employees.ToList().Where(a=>a.Emp_Id==id).FirstOrDefault();
            emp.Emp_Id = Convert.ToInt32(lblEditId.Text);
            emp.Emp_FName = EdFName.Text.ToString();
            emp.Emp_LName = EdLName.Text.ToString();
            emp.Age = Convert.ToInt32(EdAge.Text);
            emp.Gender = EdGender.SelectedItem.Text.ToString(); 
            entities.Entry(emp).State = System.Data.Entity.EntityState.Modified;
            entities.SaveChanges();
            bindGrid();
        }
    }
}

Comments

Post a Comment

Popular posts from this blog

Kendo Control(Dynamics)

-
Image
21. Kendo Button:             Write the below code in view                 <div>                     @( Html.Kendo().Button()    .Name( "btnShare" )   .Content( "Share" )   .HtmlAttributes( new  { type =  "button" , @class =  "btn btn-primary" ,      style =  "height:30px; width:120px; border-radius:0;padding: 3px;"  })                        .Events(e => e.Click( "btnShare_Click" ))                  ) </div> <script>      ...
Read more

Override Authorize Filters in MVC

-
Image
Override Authorize Filters in MVC Authorize Filter: It is to limit the access for a user or user specific to the role. Implementation of Override Authorize filters in MVC Step1: Add a controller and named it as HomeController Add [Authorize] attribute before an action or a controller based on the requirement. Suppose user want to restrict the access of particular controller but allow some of action of that controller. So just add [Authorize] before controller                using System; using System.Web.Mvc; using System.Web.Mvc.Filters; namespace WebApplication1.Controllers {     [ Authorize ]     public class HomeController : Controller     {     } } Step 2: Create a class and named it as OverrideAuthorizeAttribute which should inherit AuthorizeAttribute and Implements IOverrideFilter    public ...
Read more

Form Validation

-
Image
How to validate a form using Jquery Write the below code : < form action ="" id ="frmEnquiry" method ="post" novalidate ="novalidate">                 < p class ="your-para"> Your Name : </ p >                 < input type ="text" name ="Name" id ="Name" value ="" onfocus ="this .value= '' ; " onblur ="if ( this .value == '' ) { this .value = '' ;} ">                 < p class ="your-para"> Your Mail : </ p >                 < input type ="text" name ="Email" id ="Email" value ="" onfocus ="this .value= '' ; " onblur ="if ( this .value == '' ) { this .value = '' ;} ">        ...
Read more