CRUD OPerations in Gridview control in asp.net C#

-
Open a Asp.Net empty web application
=> add one web Form
=>
WebForm1.Aspx

 <%@ Page Language="C#" AutoEventWireup="true" CodeBehind="WebForm1.aspx.cs" Inherits="WebApplication3.WebForm1" EnableEventValidation="true" %>

<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title>Grid</title>
    <style type="text/css">
        .cetner {
            padding-top: 13px;
            margin: auto;
            width: 60%;
            padding: 10px;
        }

        .Gridview {
            font-family: Verdana;
            font-size: 10pt;
            font-weight: normal;
            color: black;
        }
    </style>
    <script src="Scripts/jquery-2.1.4.js"></script>
    <script type="text/javascript">
     
           function Delete()
           {
               if (confirm("Are you sure you want to Delete")) {
                   return true;
               }
               else return false;
           }
           </script>

</head>
<body>
    <form id="form1" runat="server">
        <div>
            <asp:GridView ID="gvEmployee" DataKeyNames="ID,EmployeeName" runat="server"
                AutoGenerateColumns="false" CssClass="cetner Gridview" HeaderStyle-BackColor="#61A6F8"
                ShowFooter="true" HeaderStyle-Font-Bold="true" HeaderStyle-ForeColor="White"
                OnRowCancelingEdit="gvDetails_RowCancelingEdit"
                OnRowDeleting="gvDetails_RowDeleting" OnRowEditing="gvDetails_RowEditing"
                OnRowUpdating="gvDetails_RowUpdating"
                OnRowCommand="gvDetails_RowCommand">
                <Columns>
                    <asp:TemplateField HeaderText="Actions">
                        <EditItemTemplate>
                            <asp:ImageButton ID="imgbtnUpdate" CommandName="Update" runat="server" ImageUrl="~/Images/update.jpg" ToolTip="Update" Height="20px" Width="20px" />
                            <asp:ImageButton ID="imgbtnCancel" runat="server" CommandName="Cancel" ImageUrl="~/Images/Cancel.jpg" ToolTip="Cancel" Height="20px" Width="20px" />
                        </EditItemTemplate>
                        <ItemTemplate>
                            <asp:ImageButton ID="imgbtnEdit" CommandName="Edit" runat="server" ImageUrl="~/Images/Edit.jpg" ToolTip="Edit" Height="20px" Width="20px" />
                            <asp:ImageButton ID="imgbtnDelete" CommandName="Delete" Text="Edit" runat="server" ImageUrl="~/Images/delete.jpg" ToolTip="Delete" Height="20px" Width="20px" OnClientClick="return Delete()" />
                        </ItemTemplate>
                        <FooterTemplate>
                            <asp:ImageButton ID="imgbtnAdd" runat="server" ImageUrl="~/Images/AddNewitem.jpg" CommandName="AddNew" Width="30px" Height="30px" ToolTip="Add new User" ValidationGroup="validaiton" />
                        </FooterTemplate>
                    </asp:TemplateField>
                    <asp:TemplateField HeaderText="UserID">
                        <EditItemTemplate>
                            <asp:Label ID="lbleditusr" runat="server" Text='<%#Eval("EmployeeID") %>' />
                        </EditItemTemplate>
                        <ItemTemplate>
                            <asp:Label ID="lblitemUsr" runat="server" Text='<%#Eval("EmployeeID") %>' />
                        </ItemTemplate>
                        <FooterTemplate>
                            <asp:TextBox ID="txtEmployeeID" runat="server" />

                        </FooterTemplate>
                    </asp:TemplateField>
                    <asp:TemplateField HeaderText="Name">
                        <EditItemTemplate>
                            <asp:TextBox ID="txtName" runat="server" Text='<%#Eval("EmployeeName") %>' />
                        </EditItemTemplate>
                        <ItemTemplate>
                            <asp:Label ID="lblName" runat="server" Text='<%#Eval("EmployeeName") %>' />
                        </ItemTemplate>
                        <FooterTemplate>
                            <asp:TextBox ID="txtEmployeeName" runat="server" />
                        </FooterTemplate>
                    </asp:TemplateField>
                    <asp:TemplateField HeaderText="Address">
                        <EditItemTemplate>
                            <asp:TextBox ID="txtAddress" runat="server" Text='<%#Eval("EmployeeAddress") %>' />
                        </EditItemTemplate>
                        <ItemTemplate>
                            <asp:Label ID="lblAddress" runat="server" Text='<%#Eval("EmployeeAddress") %>' />
                        </ItemTemplate>
                        <FooterTemplate>
                            <asp:TextBox ID="txtEmployeeAddress" runat="server" />
                        </FooterTemplate>
                    </asp:TemplateField>
                </Columns>
            </asp:GridView>
        </div>
        <div class="cetner">
            <asp:Label ID="lblresult" runat="server"></asp:Label>
        </div>
    </form>
</body>
</html>


WebForm1.aspx.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
namespace WebApplication3
{
    public partial class WebForm1 : System.Web.UI.Page
    {
        SqlConnection con = new SqlConnection("Data Source=192.168.200.77;Initial Catalog=pluto;User ID=sa;Password=indi123;Connection Timeout=1500;Connection Lifetime=0;Min Pool Size=1;Max Pool Size=400;Pooling=true;");
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
                BindEmployeeDetails();
        }
        protected void BindEmployeeDetails()
        {

            try
            {



                con.Open();
                SqlCommand cmd = new SqlCommand("Select * from emp", con);
                SqlDataAdapter da = new SqlDataAdapter(cmd);
                DataSet ds = new DataSet();
                da.Fill(ds);
                con.Close();
                if (ds.Tables[0].Rows.Count < 0)
                {
                    gvEmployee.DataSource = ds;
                    gvEmployee.DataBind();
                }
                else
                {
                    ds.Tables[0].Rows.Add(ds.Tables[0].NewRow());
                    gvEmployee.DataSource = ds;
                    gvEmployee.DataBind();
                    int columncount = gvEmployee.Rows[0].Cells.Count;
                    gvEmployee.Rows[0].Cells.Clear();
                    gvEmployee.Rows[0].Cells.Add(new TableCell());
                    gvEmployee.Rows[0].Cells[0].ColumnSpan = columncount;
                    gvEmployee.Rows[0].Cells[0].Text = "No Records Found";
                }
            }
            catch
            {

            }
        }
        protected void gvDetails_RowEditing(object sender, GridViewEditEventArgs e)
        {
            try
            {
                gvEmployee.EditIndex = e.NewEditIndex;
                BindEmployeeDetails();
            }
            catch
            {

            }

        }
        protected void gvDetails_RowUpdating(object sender, GridViewUpdateEventArgs e)
        {
            try
            {


                int userid = Convert.ToInt32(gvEmployee.DataKeys[e.RowIndex].Value.ToString());
                string username = gvEmployee.DataKeys[e.RowIndex].Values["EmployeeName"].ToString();
                TextBox txtEmployeeName = (TextBox)gvEmployee.Rows[e.RowIndex].FindControl("txtName");



                TextBox txtEmployeeAddress = (TextBox)gvEmployee.Rows[e.RowIndex].FindControl("txtAddress");
                con.Open();
                SqlCommand cmd = new SqlCommand("update emp set EmployeeName='" + txtEmployeeName.Text + "',EmployeeAddress='" + txtEmployeeAddress.Text + "' where ID=" + userid, con);
                cmd.ExecuteNonQuery();
                con.Close();
                lblresult.ForeColor = Color.Green;
                lblresult.Text = username + " Details Updated successfully";
                gvEmployee.EditIndex = -1;
                BindEmployeeDetails();
            }
            catch
            {

            }
        }
        protected void gvDetails_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
        {
            try
            {
                gvEmployee.EditIndex = -1;
                BindEmployeeDetails();
            }
            catch
            {

            }
        }
        protected void gvDetails_RowDeleting(object sender, GridViewDeleteEventArgs e)
        {
            try
            {
                int EmployeeID = Convert.ToInt32(gvEmployee.DataKeys[e.RowIndex].Values["ID"].ToString());
                string EmployeeName = gvEmployee.DataKeys[e.RowIndex].Values["EmployeeName"].ToString();
                con.Open();
                SqlCommand cmd = new SqlCommand("delete from emp where ID=" + EmployeeID, con);
                int result = cmd.ExecuteNonQuery();
                con.Close();
                if (result == 1)
                {
                    BindEmployeeDetails();
                    lblresult.ForeColor = Color.Red;
                    lblresult.Text = EmployeeName + " details deleted successfully";
                }
            }
            catch
            {

            }
        }
        protected void gvDetails_RowCommand(object sender, GridViewCommandEventArgs e)
        {
            try
            {
                if (e.CommandName.Equals("AddNew"))
                {
                    TextBox txtEmployeeID = (TextBox)gvEmployee.FooterRow.FindControl("txtEmployeeID");
                    TextBox txtEmployeeName = (TextBox)gvEmployee.FooterRow.FindControl("txtEmployeeName");
                    TextBox txtEmployeeAddress = (TextBox)gvEmployee.FooterRow.FindControl("txtEmployeeAddress");

                    if (txtEmployeeID.Text != "" && txtEmployeeName.Text != "" && txtEmployeeAddress.Text != "")
                    {
                        con.Open();
                        SqlCommand cmd =
                        new SqlCommand(
                        "insert into emp(EmployeeID,EmployeeName,EmployeeAddress,RequestID) values('" + txtEmployeeID.Text + "','" +
                        txtEmployeeName.Text + "','" + txtEmployeeAddress.Text + "',1)", con);
                        int result = cmd.ExecuteNonQuery();
                        con.Close();
                        if (result == 1)
                        {
                            BindEmployeeDetails();
                            lblresult.ForeColor = Color.Green;
                            lblresult.Text = txtEmployeeName.Text + " Details inserted successfully";
                        }
                    }
                    else
                    {
                        lblresult.ForeColor = Color.Red;
                        lblresult.Text = "please fill Your details";
                    }
                }
            }
            catch
            {

            }
        }
    }
}


This Images 







Comments

Post a Comment

Popular posts from this blog

Wcf interview

-
Image
What is WCF? Windows Communication Foundation (WCF) is an SDK for developing and deploying services on Windows. WCF provides a runtime environment for services, enabling you to expose CLR types as services, and to consume other services as CLR types. WCF is part of .NET 3.0 and requires .NET 2.0, so it can only run on systems that support it.     What is service and client in perspective of data communication? A service is a unit of functionality exposed to the world.The client of a service is merely the party consuming the service.     What is address in WCF and how many types of transport schemas are there in WCF? Address is a way of letting client know that where a service is located. In WCF, every service is associated with a unique address. This contains the location of the service and transport schemas. WCF supports following transport schemas  HTTP TCP Peer network IPC (Inter-Process Communication over named pipes) MSMQ The sample addr...
Read more

Uses of all page notations in .Net like ASPX,ASMX,ASAX .................... in asp.net

-
.asax : Global.asax, used for application-level logic .ascx :  Web UserControls: custom controls to be placed onto web pages. .ashx :  custom HTTP handlers. .asmx :  web service pages. From version 2.0 a Code behind page of an asmx file is placed into the app_code folder. .axd :  when enabled in web.config requesting trace.axd outputs application-level tracing. Also used for the special webresource.axd handler which allows control/component developers to package a component/control complete with images, script, css etc. for deployment in a single file (an 'assembly') .config :  web.config is the only file in a specific Web application to use this extension by default (machine.config similarly affects the entire Web server and all applications on it), however ASP.NET provides facilities to create and consume other config files. These are stored in XML format. .cs/vb :  Code files (cs indicates C#, vb indicates Visual Basic). Code behind files (see a...
Read more

checkbox all for radioButtonList Control Inside Gridview in Asp.Net C#

-
In gridview Design code .................................................. <asp:GridView ID="gvUserMenus" runat="server" EmptyDataText="No Records"  RowStyle-Height="20px" ShowHeaderWhenEmpty="true" >                     <Columns>                         <%-- <asp:BoundField DataField="MainMenu" HeaderText="MainMenu" ItemStyle-Width="150" />                                                     <asp:BoundField DataField="SubMenu" HeaderText="SubMenu" ItemStyle-Width="150" />                                                     <asp:BoundField DataField="MenuItem" HeaderText="MenuItem...
Read more