GridView - Insert Update Delete

CS Page
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.Configuration;

public

partial class _Default : System.Web.UI.Page

{


string conString = ConfigurationManager.ConnectionStrings["conn"].ConnectionString;


SqlConnection con;


SqlCommand cmd;


SqlDataAdapter adap;


DataTable dt;


protected void Page_Load(object sender, EventArgs e)

{


if (!IsPostBack)

{

showData();

}

}


protected void showData()

{


try

{

con =
new SqlConnection(conString);

adap =
new SqlDataAdapter("select * from Emp", con);

dt =
new DataTable();

adap.Fill(dt);

g1.DataSource = dt;

g1.DataBind();

}


catch (Exception ex)

{

Response.Write(ex.Message);

}

}


protected void g1_RowDeleting(object sender, GridViewDeleteEventArgs e)

{


Label ID = g1.Rows[e.RowIndex].FindControl("lblEmpId") as Label;




try

{

con =
new SqlConnection(conString);


if (con.State == ConnectionState.Closed)

{

con.Open();

}

cmd =
new SqlCommand("Delete from Emp where EmpId = '" + ID.Text + "'", con);


int t = cmd.ExecuteNonQuery();


if (t > 0)

{

showData();

}


if (con.State == ConnectionState.Open)

{

con.Close();

}

}


catch (Exception ex)

{

Response.Write(ex.Message);

}

}


protected void DataSave(object sender, EventArgs e)

{




TextBox id = g1.FooterRow.FindControl("txtEmpId") as TextBox;


TextBox name = g1.FooterRow.FindControl("txtEmpName") as TextBox;


TextBox add = g1.FooterRow.FindControl("txtEmpAdd") as TextBox;


TextBox sal= g1.FooterRow.FindControl("txtEmpSal") as TextBox;


try

{

con =
new SqlConnection(conString);


if (con.State == ConnectionState.Closed)

{

con.Open();

}

cmd =
new SqlCommand("insert into Emp values("+id.Text+",'"+name.Text+"','"+add.Text+"',"+sal.Text+")", con);


int t = cmd.ExecuteNonQuery();


if (t > 0)

{

showData();

}


if (con.State == ConnectionState.Open)

{

con.Close();

}

}


catch (Exception ex)

{

Response.Write(ex.Message);

}

}


protected void g1_RowEditing(object sender, GridViewEditEventArgs e)

{

g1.EditIndex = e.NewEditIndex;

showData();

}


protected void g1_RowUpdating(object sender, GridViewUpdateEventArgs e)

{


GridViewRow row = (GridViewRow)g1.Rows[e.RowIndex];

　


Label id = g1.Rows[e.RowIndex].FindControl("lblEmpId") as Label;


TextBox name =(TextBox)row.FindControl("txtEmpName1");


TextBox add = (TextBox)row.FindControl("txtEmpAdd1");


TextBox sal = (TextBox)row.FindControl("txtEmpSal1");


//TextBox name1 = g1.Rows[e.RowIndex].FindControl("txtEnpName1") as TextBox;


//TextBox add1 = g1.Rows[e.RowIndex].FindControl("txtEmpAdd1") as TextBox;


//TextBox sal1 = g1.Rows[e.RowIndex].FindControl("txtEmpSal1") as TextBox;


try

{

con =
new SqlConnection(conString);


if (con.State == ConnectionState.Closed)

{

con.Open();

}

cmd =
new SqlCommand("update Emp set EmpName='" + name.Text + "', EmpAdd='" + add.Text + "', EmpSal=" + sal.Text + " where EmpId=" + id.Text + "", con);


int t = cmd.ExecuteNonQuery();


if (t > 0)

{

g1.EditIndex = -1;

showData();





}


if (con.State == ConnectionState.Open)

{

con.Close();

}

}


catch (Exception ex)

{

Response.Write(ex.Message);

}

}


protected void g1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)

{

g1.EditIndex = -1;

showData();

}

}

　
Aspx Page

<%
@ Page Title="Home Page" Language="C#" MasterPageFile="~/Site.master" AutoEventWireup="true"


CodeFile="Default.aspx.cs" Inherits="_Default" %>

<

asp:Content ID="HeaderContent" runat="server" ContentPlaceHolderID="HeadContent">

</

asp:Content>

<

asp:Content ID="BodyContent" runat="server" ContentPlaceHolderID="MainContent">


<h2>

Welcome to Home Page...
</h2>


<p>


<asp:GridView ID="g1" runat="server" AutoGenerateColumns="false"


onrowdeleting="g1_RowDeleting" ShowFooter="true"


onrowcancelingedit="g1_RowCancelingEdit" onrowediting="g1_RowEditing"


onrowupdating="g1_RowUpdating">


<Columns>


<asp:TemplateField HeaderText="Emp Id">


<ItemTemplate>


<asp:Label ID="lblEmpId" runat="server" Text='<%#bind("EmpId") %>'></asp:Label>


</ItemTemplate>


<FooterTemplate>


<asp:TextBox ID="txtEmpId" runat="server" ></asp:TextBox>


</FooterTemplate>


</asp:TemplateField>


<asp:TemplateField HeaderText="Emp Name">


<ItemTemplate>


<asp:Label ID="lblEmpName" runat="server" Text='<%#bind("EmpName") %>'></asp:Label>


</ItemTemplate>


<EditItemTemplate>


<asp:TextBox ID="txtEmpName1" runat="server" Text='<%#bind("EmpName") %>'></asp:TextBox>


</EditItemTemplate>


<FooterTemplate>


<asp:TextBox ID="txtEmpName" runat="server" ></asp:TextBox>


</FooterTemplate>


</asp:TemplateField>


<asp:TemplateField HeaderText="Emp Add">


<ItemTemplate>


<asp:Label ID="lblEmpAdd" runat="server" Text='<%#bind("EmpAdd") %>'></asp:Label>


</ItemTemplate>


<EditItemTemplate>


<asp:TextBox ID="txtEmpAdd1" runat="server" Text='<%#bind("EmpAdd") %>'></asp:TextBox>


</EditItemTemplate>


<FooterTemplate>


<asp:TextBox ID="txtEmpAdd" runat="server" ></asp:TextBox>


</FooterTemplate>


</asp:TemplateField>


<asp:TemplateField HeaderText="Emp Sal">


<ItemTemplate>


<asp:Label ID="lblEmpSal" runat="server" Text='<%#bind("EmpSal") %>'></asp:Label>


</ItemTemplate>


<EditItemTemplate>


<asp:TextBox ID="txtEmpSal1" runat="server" Text='<%#bind("EmpSal") %>'></asp:TextBox>


</EditItemTemplate>


<FooterTemplate>


<asp:TextBox ID="txtEmpSal" runat="server" ></asp:TextBox>


</FooterTemplate>


</asp:TemplateField>


<asp:TemplateField HeaderText="Operation">


<ItemTemplate>


<asp:Button ID="btnDelete" runat="server" Text="Delete" CommandName="Delete"/>


<asp:Button ID="btnEdit" runat="server" Text="Edit" CommandName="Edit" />


</ItemTemplate>


<FooterTemplate>


<asp:Button ID="btnSave" Width="120px" runat="server" Text="Save" OnClick="DataSave" />


</FooterTemplate>


<EditItemTemplate>


<asp:Button ID="btnUpdate" runat="server" Text="Update" CommandName="Update"/>


<asp:Button ID="btnCancel" runat="server" Text="Cancel" CommandName="Cancel" />


</EditItemTemplate>


</asp:TemplateField>


</Columns>


</asp:GridView>


</p>


</asp:Content>