Export (0) Print
Expand All
Expand Minimize

GridView.UpdateRow Method

Note: This method is new in the .NET Framework version 2.0.

Updates the record at the specified row index using the field values of the row.

Namespace: System.Web.UI.WebControls
Assembly: System.Web (in system.web.dll)

public virtual void UpdateRow (
	int rowIndex,
	bool causesValidation
)
public void UpdateRow (
	int rowIndex, 
	boolean causesValidation
)
public function UpdateRow (
	rowIndex : int, 
	causesValidation : boolean
)

Parameters

rowIndex

The index of the row to update.

causesValidation

true to perform page validation when this method is called; otherwise, false.

Exception typeCondition

HttpException

The GridView control is bound to a data source control, but the DataSourceView associated with the data source is a null reference (Nothing in Visual Basic).

Use the UpdateRow method to programmatically update the record at the specified index in the data source. This method is commonly used when you need to update a record from outside of the GridView control, such as from a different control on the page.

NoteNote

This method can be called only for the row that is currently in edit mode, or for a row that contains a two-way data-bound input control. For more information on two-way binding expressions, see Binding to Databases.

To specify whether page validation is performed before the update operation, use the causesValidation parameter. Calling this method also raises the RowUpdated and RowUpdating events.

The following code example demonstrates how to use the UpdateRow method to programmatically update a record in a GridView control.


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

<script runat="server">

  void UpdateRowButton_Click(Object sender, EventArgs e)
  {
    // Programmatically update the current record in edit mode.
    CustomersGridView.UpdateRow(CustomersGridView.EditIndex, true);
  }

  void CustomersGridView_RowCommand(Object sender, GridViewCommandEventArgs e)
  {
    // Enable the UpdateRowButton button only when the GridView control
    // is in edit mode.
    switch (e.CommandName)
    {
      case "Edit":
        UpdateRowButton.Enabled = true;
        break;
      case "Cancel":
        UpdateRowButton.Enabled = false;
        break;
      case "Update":
        UpdateRowButton.Enabled = false;
        break;
      default:
        UpdateRowButton.Enabled = false;
        break;
    }
  }
    
</script>

<html>
  <body>
    <form runat="server">
        
      <h3>GridView UpdateRow Example</h3>
      
      <asp:button id="UpdateRowButton"
        text="Update Record"
        enabled="false"
        onclick="UpdateRowButton_Click" 
        runat="server"/>
        
      <hr/>

      <!-- The GridView control automatically sets the columns     -->
      <!-- specified in the datakeynames property as read-only.    -->
      <!-- No input controls are rendered for these columns in     -->
      <!-- edit mode.                                              -->
      <asp:gridview id="CustomersGridView"
        allowpaging="true" 
        datasourceid="CustomersSqlDataSource" 
        autogeneratecolumns="true"
        autogenerateeditbutton="true"
        datakeynames="CustomerID"
        onrowcommand="CustomersGridView_RowCommand"   
        runat="server">
      </asp:gridview>
            
      <!-- This example uses Microsoft SQL Server and connects  -->
      <!-- to the Northwind sample database. Use an ASP.NET     -->
      <!-- expression to retrieve the connection string value   -->
      <!-- from the Web.config file.                            -->
      <asp:sqldatasource id="CustomersSqlDataSource"  
        selectcommand="Select [CustomerID], [CompanyName], [Address], [City], [PostalCode], [Country] From [Customers]"
        updatecommand="Update Customers SET CompanyName=@CompanyName, Address=@Address, City=@City, PostalCode=@PostalCode, Country=@Country WHERE (CustomerID = @CustomerID)"
        connectionstring="<%$ ConnectionStrings:NorthWindConnectionString%>"
        runat="server">
      </asp:sqldatasource>
            
    </form>
  </body>
</html>


Windows 98, Windows 2000 SP4, Windows Server 2003, Windows XP Media Center Edition, Windows XP Professional x64 Edition, Windows XP SP2, Windows XP Starter Edition

The .NET Framework does not support all versions of every platform. For a list of the supported versions, see System Requirements.

.NET Framework

Supported in: 2.0

Community Additions

ADD
Show:
© 2014 Microsoft