Insert ,update,delete ,paging and sorting In to gridview

Gridsorting.aspx

<asp:GridView ID="grd" runat="server" AllowPaging="true" AllowSorting="true" PageSize="10"

AutoGenerateColumns="false" ShowFooter ="true"

DataKeyNames="id" OnSorting="grd_Sorting" OnRowEditing="grd_RowEditing"

onrowupdating="grd_RowUpdating" onrowcancelingedit="grd_RowCancelingEdit"

onpageindexchanging="grd_PageIndexChanging"

onrowdeleting="grd_RowDeleting">

<asp:TemplateField HeaderText="Name" SortExpression="name" FooterStyle-Width="200px"

ItemStyle-Width="200px">

<asp:Label ID="lblname" Text='<%#Eval("name") %>' runat="server"></asp:Label>

</ItemTemplate>

<asp:TextBox ID="txtname" Text='<%#Eval("name") %>' runat="server"></asp:TextBox>

<asp:RequiredFieldValidator ID="rfvEditCame" ValidationGroup="Edit"runat="server" SetFocusOnError="true" Display="Dynamic" ControlToValidate="txtname"ErrorMessage="Please , Enter Name."></asp:RequiredFieldValidator>

</EditItemTemplate>

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

<asp:RequiredFieldValidator ID="rfvFooteitynme" ValidationGroup="Footer"runat="server" SetFocusOnError="true" Display="Dynamic" ControlToValidate="txtfname"ErrorMessage="Please , Enter City Name."></asp:RequiredFieldValidator>

</FooterTemplate>

</asp:TemplateField>

<asp:TemplateField HeaderText="Email" SortExpression="E_id" FooterStyle-Width="200px" ItemStyle-Width="200px">

<asp:Label ID="lbleid" runat="server" Text='<%# Eval("E_id") %>'></asp:Label>

</ItemTemplate>

<asp:TextBox ID="txtemail" runat="server" Text='<%# Eval("E_id") %>' ></asp:TextBox>

<asp:RequiredFieldValidator ID="rfvEditCityname" ValidationGroup="Edit"runat="server"

SetFocusOnError="true" Display="Dynamic" ControlToValidate="txtemail"ErrorMessage="Please , Enter Email Id"></asp:RequiredFieldValidator>

</EditItemTemplate>

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

<asp:RequiredFieldValidator ID="vFooterCityname" ValidationGroup="Footer"runat="server" SetFocusOnError="true" Display="Dynamic" ControlToValidate="txtfemail"ErrorMessage="Please , Enter Email Id"></asp:RequiredFieldValidator>

</FooterTemplate>

</asp:TemplateField>

<asp:TemplateField HeaderText="Mobile" SortExpression="Mobile" FooterStyle-Width="200px" ItemStyle-Width="200px">

<asp:Label ID="lblMObile" Text='<%#Bind("mobile")%>' runat="server"></asp:Label>

</ItemTemplate>

<asp:TextBox ID="txtEditMObile" Text='<%#Bind("Mobile")%>' runat="server"></asp:TextBox>

<asp:RequiredFieldValidator ID="mobilename" ValidationGroup="Edit"runat="server" SetFocusOnError="true" Display="Dynamic" ControlToValidate="txtEditMObile"

ErrorMessage="Please , Enter Mobile No."></asp:RequiredFieldValidator>

</EditItemTemplate>

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

<asp:RequiredFieldValidator ID="mobile" ValidationGroup="Footer"runat="server"

SetFocusOnError="true" Display="Dynamic" ControlToValidate="txtmobile"ErrorMessage="Please , Enter Mobile NO."></asp:RequiredFieldValidator>

</FooterTemplate>

</asp:TemplateField>

<asp:TemplateField HeaderText="City Name" SortExpression="City" FooterStyle-Width="200px"ItemStyle-Width="200px">

<asp:Label ID="lblCityName" Text='<%#Bind("City")%>' runat="server"></asp:Label>

</ItemTemplate>

<asp:TextBox ID="txtEditCityName" Text='<%#Bind("City")%>' runat="server"></asp:TextBox>

<asp:RequiredFieldValidator ID="rfvityname" ValidationGroup="Edit"runat="server" SetFocusOnError="true" Display="Dynamic" ControlToValidate="txtEditCityName"

ErrorMessage="Please , Enter City Name."></asp:RequiredFieldValidator>

</EditItemTemplate>

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

<asp:RequiredFieldValidator ID="rfvFooterCitame" ValidationGroup="Footer" runat="server" SetFocusOnError="true" Display="Dynamic" ControlToValidate="txtCityName"ErrorMessage="Please , Enter City Name."></asp:RequiredFieldValidator>

</FooterTemplate>

</asp:TemplateField>

<asp:TemplateField HeaderText="Action">

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

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

</ItemTemplate>

<asp:Button ID="btnupdate" runat="server" Text="Update"ValidationGroup="Edit" CommandName ="update" />

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

</EditItemTemplate>

<asp:Button ID="btninsert" runat="server" Text="Insert" ValidationGroup="Footer"

OnClick="btninsert_Click" />

</FooterTemplate>

</asp:TemplateField>

</Columns>

</asp:GridView>

gridsorting.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 DAL;

public partial class gridsorting : System.Web.UI.Page

{

DataTable dt = new DataTable();

Dal odal = new Dal();

DataSet ds = new DataSet();

protected void Page_Load(object sender, EventArgs e)

{

if (!IsPostBack)

{

fill();

}

public void fill()

{

dt = odal.selectbyquerydt("select * from registeruser");

grd.DataSource = dt;

grd.DataBind();

}

public SortDirection dir

{

get

{

if (ViewState["dirState"] == null)

{

ViewState["dirState"] = SortDirection.Ascending;

}

return (SortDirection)ViewState["dirState"];

}

set

{

ViewState["dirState"] = value;

}

protected void grd_Sorting(object sender, GridViewSortEventArgs e)

{

fill();

DataTable dt = new DataTable();

dt = grd.DataSource as DataTable;

{

string SortDir = string.Empty;

if (dir == SortDirection.Ascending)

{

dir = SortDirection.Descending;

SortDir = "Desc";

}

else

{

dir = SortDirection.Ascending;

SortDir = "Asc";

}

DataView sortedView = new DataView(dt);

sortedView.Sort = e.SortExpression + " " + SortDir;

grd.DataSource = sortedView;

grd.DataBind();

}

protected void grd_RowEditing(object sender, GridViewEditEventArgs e)

{

grd.EditIndex = 0;

}

protected void btninsert_Click(object sender, EventArgs e)

{

TextBox Name = (TextBox)grd.FooterRow.FindControl("txtfName") as TextBox;

TextBox Email = (TextBox)grd.FooterRow.FindControl("txtfemail") as TextBox;

TextBox city = (TextBox)grd.FooterRow.FindControl("txtCityName") as TextBox;

TextBox mobile = (TextBox)grd.FooterRow.FindControl("txtmobile") as TextBox;

odal.updatedata("insert into registeruser (name,e_id,Mobile,city) values('" + Name.Text + "','" + Email.Text + "','" + mobile.Text + "','" + city.Text + "')");

fill();

}

protected void grd_RowUpdating(object sender, GridViewUpdateEventArgs e)

{

grd.EditIndex = e.RowIndex;

int id = int.Parse(grd.DataKeys[grd.EditIndex].Value.ToString());

TextBox Name = (TextBox)grd.Rows[e.RowIndex].FindControl("txtfName") as TextBox;

TextBox Email = (TextBox)grd.Rows[e.RowIndex].FindControl("txtemail") as TextBox;

TextBox city = (TextBox)grd.Rows[e.RowIndex].FindControl("txtEditCityName") as TextBox;

TextBox mobile = (TextBox)grd.Rows[e.RowIndex].FindControl("txtEditMObile") as TextBox;

string str = "update registeruser set name='" + Name.Text + "',e_id='" + Email.Text + "',city='" + city.Text + "',mobile='" + mobile.Text + "' where id =" + id;

odal.updatedata(str);

grd.EditIndex = -1;

fill();

}

protected void grd_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)

{

grd.EditIndex = -1;

fill();

}

protected void grd_PageIndexChanging(object sender, GridViewPageEventArgs e)

{

grd.PageIndex = e.NewPageIndex;

fill();

}

protected void grd_RowDeleting(object sender, GridViewDeleteEventArgs e)

{

grd.EditIndex = e.RowIndex;

int id = int.Parse(grd.DataKeys[grd.EditIndex].Value.ToString());

odal.updatedata("delete from registeruser where id=" + id);

fill();

}

Search This Blog

Programming With Sangani