View Snippet

Edit GridView And Save Changes

ASP.Net - C# Controls

Viewed: 1173

Date: 2010-02-09

This code snippet shows how to populate a gridview control from a datatable object and allow a user to edit the rows and save the changes.

View More GridView Examples

<%@ Page Language="C#" %>

<%@ Import Namespace="System.Data" %>

<%@ Import Namespace="System.Data.SqlClient" %>

<script runat="server">

    string Provider = "Data Source=DATA_SOURCE;Integrated Security=True";

    SqlConnection con;

    protected void Page_Load(object sender, EventArgs e)

    {

        if (!Page.IsPostBack)

        {

            con = new SqlConnection(Provider);

            con.Open();

            SqlCommand cmd = new SqlCommand("SELECT * FROM Customer", con);

            SqlDataAdapter adapter = new SqlDataAdapter(cmd);

            DataTable CustomerTable = new DataTable();

            adapter.Fill(CustomerTable);

            Session["CustomerTable"] = CustomerTable;

            BindGridData();

        }

    }

    protected void CustomerGrid_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)

    {

        CustomerGrid.EditIndex = -1;

        BindGridData();

    }

    protected void CustomerGrid_PageIndexChanging(object sender, GridViewPageEventArgs e)

    {

        CustomerGrid.PageIndex = e.NewPageIndex;

        BindGridData();

    }

    protected void CustomerGrid_RowUpdating(object sender, GridViewUpdateEventArgs e)

    {

        DataTable CustomerTable = (DataTable)Session["CustomerTable"];

        GridViewRow row = CustomerGrid.Rows[e.RowIndex];

        string ID =((TextBox)(row.Cells[1].Controls[0])).Text;

        string FirstName =((TextBox)(row.Cells[2].Controls[0])).Text;

        string LastName =((TextBox)(row.Cells[3].Controls[0])).Text;

        CustomerTable.Rows[row.DataItemIndex]["FirstName"] = FirstName;

        CustomerTable.Rows[row.DataItemIndex]["LastName"] = LastName;

        con = new SqlConnection(Provider);

        con.Open();

        SqlCommand cmd = new SqlCommand("UPDATE Customer SET FirstName='" + FirstName + "', LastName='" + LastName + "' WHERE ID=" + ID,con);

        cmd.ExecuteNonQuery();

        CustomerGrid.EditIndex =-1;

        BindGridData();

    }

    protected void CustomerGrid_RowEditing(object sender, GridViewEditEventArgs e)

    {

        CustomerGrid.EditIndex = e.NewEditIndex;

        BindGridData();

    }

    private void BindGridData()

    {

        CustomerGrid.DataSource = Session["CustomerTable"];

        CustomerGrid.DataBind();

    }

</script>

<html>

<head>

    <title>Grid View</title>

</head>

<body>

    <form runat="server">

      <asp:GridView ID="CustomerGrid" runat="server" 

        AutoGenerateEditButton="True" 

        AllowPaging="true"

        OnRowEditing="CustomerGrid_RowEditing"         

        OnRowCancelingEdit="CustomerGrid_RowCancelingEdit" 

        OnRowUpdating="CustomerGrid_RowUpdating"

        OnPageIndexChanging="CustomerGrid_PageIndexChanging">

      </asp:GridView>

    </form>

</body>

</html>

New Snippets

Highlight Input Element On Focus Javascript JQuery

This code snippet shows how to highlight an input element when it has focus and remove the highlight when it loses focus.

Calculate Age C# Miscellaneous

This code snippet shows how to calculate an age from a date of birth.

LINQ Example 2 C# LINQ

This linq example shows how to query a List object.

Sliding Tab Control Javascript JQuery

This code snippet shows how to develop a simple tab control, that slides tab pages when you click onto a tab.

LINQ Example 1 C# LINQ

This code snippet uses where to find all elements of an array that is less than 10.

File Exists Visual C++ File Manipulation

This code snippet determines if a file exists.

XML Example 1 Ruby XML

This code snippet shows how to loop through an XML string.

Simple MySQL Class To Query Database Java Database

The following code snippet shows how to create a simple MySql class that can be used to create a connection to the database server and execute queries which return a ResultSet object.

Connect To MySQL Database Java Database

This code snippet shows how to connect to a MySQL database server. You will need to download Connector/j.

File Viewer Example Java Controls

This code snippet shows how to open a file for reading and display the data into a JTextArea component.

JMenu With ActionListener Example Java Controls

This code snippet shows how to add an ActionListener to a JMenu component.

JMenuBar Example Java Controls

This code snippet demonstrates how to use the JMenuBar component and how to add menu items using the JMenu and JMenuItem components.

MD5 Message Digest Example 1 Java Security

This code snippet shows how to use the MessageDigest class to get an instance of the MD5 MessageDigest. This code snippet does not return a 32 character string.

Check If File Is Hidden Java File Manipulation

This code snippet checks if a file is hidden.

Check If File Exists Java File Manipulation

This code snippet checks if a file exists. If it does, it displays its absolute file path.

What Others Are Viewing

Highlight Input Element On Focus Javascript JQuery

This code snippet shows how to highlight an input element when it has focus and remove the highlight when it loses focus.

LINQ Example 2 C# LINQ

This linq example shows how to query a List object.

Sliding Tab Control Javascript JQuery

This code snippet shows how to develop a simple tab control, that slides tab pages when you click onto a tab.

LINQ Example 1 C# LINQ

This code snippet uses where to find all elements of an array that is less than 10.

File Exists Visual C++ File Manipulation

This code snippet determines if a file exists.

Top ASP.Net - C# Snippets

Edit GridView And Save Changes - ASP.Net - C#

This code snippet shows how to populate a gridview control from a datatable object and allow a user to edit the rows and save the changes.

GridView From DataTable - ASP.Net - C#

This code snippet shows how to populate a gridview control with data from a datatable object.

HTTP Response Output Stream - ASP.Net - C#

This code snippet writes a file directly to the HTTP response output stream using the WriteFile method.

Export GridView To Word Document - ASP.Net - C#

This code snippet exports a GridView to a MS Word document as a download.

XML To GridView - ASP.Net - C#

This code snippet shows how to load an XML file from the App_Data folder into a GridView control using the DataSet class.

List Headers And Values From HttpRequest - ASP.Net - C#

This code snippet loops through all the headers from the HttpRequest object and displays its value.

Reading And Writing A Session - ASP.Net - C#

This code snippet shows you how to read and write to a session.

Simple Cookie Example - ASP.Net - C#

This code snippet shows how to use the HttpCookie class and set a cookie expiry time and a value.

Reading And Writing A Cookie - ASP.Net - C#

This code snippet shows how to read and write a cookie and how to check if a cookie exists.

List Form Variables And Values From HttpRequest - ASP.Net - C#

This code snippet loops through all the form variables and shows its value if the form has been posted.