HOW TO EDIT UPDATE IN GRIDVIEW IN C#.NET

Ankit Singh

Total Post:341

Points:2389
Posted by  Ankit Singh
C#  ASP.Net 
 643  View(s)
Ratings:
Rate this:
 I want to edit update data in gridview  how to do this please help me.
  1. aditya kumar Patel

    Post:254

    Points:1810
    Re: how to edit update in gridview in c#.net

    <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" BackColor="White" BorderColor="#CC9966" BorderStyle="Solid" BorderWidth="1px" CellPadding="4" OnRowCommand="GridView1_RowCommand1" >

    <Columns>

    <asp:TemplateField HeaderText="Emp_ID" >

    <ItemTemplate>

    <%#Eval("Emp_ID") %> <asp:HiddenField ID="EmpID" runat="server" Value='<%#Eval("Emp_ID") %>' />

    </ItemTemplate>

    <ControlStyle Width="100px"></ControlStyle>

    <HeaderStyle Width="100px" />

    <ItemStyle HorizontalAlign="Center" />

    </asp:TemplateField>

    <asp:TemplateField HeaderText="Emp_Name" >

    <ItemTemplate>

    <%#Eval("Emp_Name") %>

    </ItemTemplate>

    <EditItemTemplate>

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

    </EditItemTemplate>

    <ControlStyle Width="300px"></ControlStyle>

    <HeaderStyle Width="200px" />

    </asp:TemplateField>

    <asp:TemplateField HeaderText="Emp_Sal" >

    <ItemTemplate>

    <%#Eval("Emp_Sal") %>

    </ItemTemplate>

    <EditItemTemplate>

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

    </EditItemTemplate>

    <ControlStyle Width="200px"></ControlStyle>

    <HeaderStyle Width="200px" />

    </asp:TemplateField>

    <asp:TemplateField HeaderText="Emp_Sal" >

    <ItemTemplate>

    <asp:Button ID="btnedit" runat="server" Text="Edit" CommandName="Change" CommandArgument="<%# ((GridViewRow) Container).RowIndex %>" />

    </ItemTemplate>

    <EditItemTemplate>

    <asp:Button ID="btnupdate" runat="server" Text="Update" CommandName="Save" CommandArgument="<%# ((GridViewRow) Container).RowIndex %>" />

    </EditItemTemplate>

    <ControlStyle Width="200px"></ControlStyle>

    <HeaderStyle Width="200px" />

    </asp:TemplateField>

    </Columns>

    <FooterStyle BackColor="#FFFFCC" ForeColor="#330099" />

    <HeaderStyle BackColor="#990000" Font-Bold="True" ForeColor="#FFFFCC" />

    <PagerStyle BackColor="#FFFFCC" ForeColor="#330099" HorizontalAlign="Center" />

    <RowStyle BackColor="White" ForeColor="#330099" />

    <SelectedRowStyle BackColor="#FFCC66" Font-Bold="True" ForeColor="#663399" />

    <SortedAscendingCellStyle BackColor="#FEFCEB" />

    <SortedAscendingHeaderStyle BackColor="#AF0101" />

    <SortedDescendingCellStyle BackColor="#F6F0C0" />

    <SortedDescendingHeaderStyle BackColor="#7E0000" />

    </asp:GridView>

    using System;

    using System.Collections.Generic;

    using System.Configuration;

    using System.Data;

    using System.Data.SqlClient;

    using System.Linq;

    using System.Web;

    using System.Web.UI;

    using System.Web.UI.WebControls;

    namespace Forumasp

    {

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

    {

    protected void Page_Load(object sender, EventArgs e)

    {

    if (!IsPostBack)

    {

    GridView1.DataSource = GetRecord(); //set DataSource GridView

    GridView1.DataBind(); //binding GridView

    }

    }

    public DataTable GetRecord()

    {

    DataTable dt = new DataTable();

    string constr = ConfigurationManager.ConnectionStrings["forumConnectionString"].ToString(); // connection string

    SqlConnection con = new SqlConnection(constr);

    con.Open();

    SqlCommand com = new SqlCommand("select *from Employee", con); // table name

    SqlDataAdapter da = new SqlDataAdapter(com);

    DataSet ds = new DataSet();

    da.Fill(ds);

    dt = ds.Tables[0];

    return dt;

    }

    protected void GridView1_RowCommand1(object sender, GridViewCommandEventArgs e)

    {

    int index = Convert.ToInt32(e.CommandArgument.ToString());

    if (e.CommandName == "Change")

    {

    GridView1.EditIndex = index;

    GridView1.DataSource = GetRecord(); //set DataSource GridView

    GridView1.DataBind(); //binding GridView

    }

    else if (e.CommandName == "Save")

    {

    HiddenField EmpID = GridView1.Rows[index].FindControl("EmpID") as HiddenField;

    TextBox txtname = GridView1.Rows[index].FindControl("txtname") as TextBox;

    TextBox txtsal = GridView1.Rows[index].FindControl("txtsal") as TextBox;

    string constr = ConfigurationManager.ConnectionStrings["forumConnectionString"].ToString(); // connection string

    SqlConnection con = new SqlConnection(constr);

    con.Open();

    string sqlstr = "update Employee set Emp_Name='" + txtname.Text + "', Emp_Sal='" + txtsal.Text + "' where Emp_ID=" + EmpID.Value + "";

    SqlCommand cmd = new SqlCommand(sqlstr, con); // table name

    cmd.ExecuteNonQuery();

    con.Close();

    GridView1.EditIndex = -1;

    GridView1.DataSource = GetRecord(); //set DataSource GridView

    GridView1.DataBind(); //binding GridView

    }

    }

    }

    }

Answer

NEWSLETTER

Enter your email address here always to be updated. We promise not to spam!