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">
            <Columns>
                <asp:TemplateField HeaderText="Name" SortExpression="name" FooterStyle-Width="200px"
                    ItemStyle-Width="200px">
                    <ItemTemplate>
                        <asp:Label ID="lblname" Text='<%#Eval("name") %>' runat="server"></asp:Label>
                    </ItemTemplate>
                    <EditItemTemplate>
                        <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>
                    <FooterTemplate>
                        <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>
                    <FooterStyle Width="200px"></FooterStyle>
                    <ItemStyle Width="200px"></ItemStyle>
                </asp:TemplateField>
                <asp:TemplateField HeaderText="Email" SortExpression="E_id" FooterStyle-Width="200px" ItemStyle-Width="200px">
                    <ItemTemplate>
                        <asp:Label ID="lbleid" runat="server" Text='<%# Eval("E_id") %>'></asp:Label>
                    </ItemTemplate>
                    <EditItemTemplate>
                        <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>
                    <FooterTemplate>
                        <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>
                    <FooterStyle Width="200px"></FooterStyle>
                    <ItemStyle Width="200px"></ItemStyle>
                </asp:TemplateField>
                <asp:TemplateField HeaderText="Mobile" SortExpression="Mobile" FooterStyle-Width="200px" ItemStyle-Width="200px">
                    <ItemTemplate>
                        <asp:Label ID="lblMObile" Text='<%#Bind("mobile")%>' runat="server"></asp:Label>
                    </ItemTemplate>
                    <EditItemTemplate>
                        <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>
                    <FooterTemplate>
                        <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>
                    <FooterStyle Width="200px"></FooterStyle>
                    <ItemStyle Width="200px"></ItemStyle>
                </asp:TemplateField>
                <asp:TemplateField HeaderText="City Name" SortExpression="City" FooterStyle-Width="200px"ItemStyle-Width="200px">
                    <ItemTemplate>
                        <asp:Label ID="lblCityName" Text='<%#Bind("City")%>' runat="server"></asp:Label>
                    </ItemTemplate>
                    <EditItemTemplate>
                        <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>
                    <FooterTemplate>
                        <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>
                    <FooterStyle Width="200px"></FooterStyle>
                    <ItemStyle Width="200px"></ItemStyle>
                </asp:TemplateField>
                <asp:TemplateField HeaderText="Action">
                    <ItemTemplate>
                        <asp:Button ID="btnedit" runat="server" Text="Edit" CommandName="Edit" />
                        <asp:Button ID ="btndelete" runat ="server" Text ="Delete" CommandName="Delete" />
                    </ItemTemplate>
                    <EditItemTemplate>
                        <asp:Button ID="btnupdate" runat="server" Text="Update"ValidationGroup="Edit" CommandName ="update" />
                        <asp:Button ID="btncancel" runat="server" Text="Cancel"CommandName="Cancel" />
                    </EditItemTemplate>
                    <FooterTemplate>
                        <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();
    }
}





Comments

Post a Comment

Popular posts from this blog

How To Migrate MVC 3 Application To MVC 5

-
Image
Introduction In this article we discuss about how to migrate an MVC 3 application to MVC 5. Step 1:  Open your MVC 3 application in Visual Studio and change the .net framework to 4.7.2 as MVC 5 runs on this framework. MVC 3 Project Property Project → Properties → Application → Target Framework → 4.7.2 For Set MVC 5  Note:  targetFramework in Web.Config will be changing to 4.7.2 Step 2:  Install Asp.Net MVC 5 version through Package Manager Console. Run this Command: Install-Package Microsoft.AspNet.Mvc -Version 5.7.2 Nuget Package Manage → Package Manager Console and run above command. Step 3:  Go to Web.Config(root level) and change, <add key="webpages:Version" value="1.0.0.0" /> to <add key="webpages:Version" value="3.0.0.0" /> webpages:Version Step 4:  Check System.Web.Razor, System.Web.Helpers, System.WebPages.Razor versions. These all should be having versions 3.0.0.0. If th
Read more

Private Chat Using Node js and socket.io with encrypt and decrypt message and insert into mongo db

-
node.js and socket.io chat tutorial This is a very simple single-room chat client using node.js, socket.io and the express module. i found that the ready availability of  documentation  and the eagerness of experienced individuals to help the newly adopting, throughout the  node.js  communities, allow for quicker learning and sharing of acquired skills UPDATE:  long overdue, but you can now skip the following step and just install via the .msi or .pkg files and they include NPM –  http://nodejs.org/#download to begin, you must install node.js and npm along with their dependencies in Linux System now, install the modules curl -sL https://deb.nodesource.com/setup_6.x | sudo -E bash - sudo apt-get install -y nodejs For Update  sudo apt-get purge node-express now, install the modules npm install -d let’s now create the server file, server .js var express = require( 'express' ); var app = express(); var server = require( 'http' ).cr
Read more

Populate a drop-down in Vue.js and Asp.net Core from an ajax call

-
Image
  If you want to call a function on page load and Bind Drop down  List in Vue js then in this example i will show you how to trigger function on page load in vue js. we will run function on page load vue application. we mostly require to call method on page load in our application. so you want to call function in Vue.js app then you can do it using created option in vue js. So i will give full example so you can check it out. Index . cshtml < div id ="apps">     < div class ="form-group">         < label class ="control-label"> State </ label >         < select v-model ="state" class ="form-control" v-on:change ="getcity($event)">             < option v-for ="state in States" : value ="state.stateId"> {{ state.stateName }} </ option >         </ select >     </ div >     < div class ="form-group">         &l
Read more