SqlDataSource.Updated Event
Assembly: System.Web (in system.web.dll)
public: event SqlDataSourceStatusEventHandler^ Updated { void add (SqlDataSourceStatusEventHandler^ value); void remove (SqlDataSourceStatusEventHandler^ value); }
/** @event */ public void add_Updated (SqlDataSourceStatusEventHandler value) /** @event */ public void remove_Updated (SqlDataSourceStatusEventHandler value)
JScript supports the use of events, but not the declaration of new ones.
Handle the Updated event to examine the values of output parameters after an update operation has completed. The output parameters are available from the SqlDataSourceStatusEventArgs object that is associated with the event.
For more information about handling events, see Consuming Events.
The following code example demonstrates how to display and update data that is retrieved from an ODBC database in a GridView control. After a record is successfully updated, the Updated event is handled by an event handler to perform a post-processing step where an e-mail notification is sent.
<%@Page Language="VJ#" %>
<%@Import Namespace="System.Web.Mail" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<SCRIPT runat="server">
private void OnDSUpdatedHandler(Object source, SqlDataSourceStatusEventArgs e)
{
if (e.get_AffectedRows() > 0) {
// Perform any additional processing, such as sending an e-mail notification.
Label1.set_Text(get_Request().get_LogonUserIdentity().get_Name() +
" changed user information successfully!");
}
else {
Label1.set_Text("No data updated!");
}
} //OnDSUpdatedHandler
</SCRIPT>
<HTML>
<BODY>
<!-- This example uses a Northwind database that is hosted by an ODBC-compliant
database. To run this sample, create an ODBC DSN to any database that hosts
the Northwind database, including Microsoft SQL Server or Microsoft Access,
change the name of the DSN in the ConnectionString, and view the page.
-->
<FORM runat="server">
<asp:SqlDataSource
id="SqlDataSource1"
runat="server"
ProviderName="System.Data.Odbc"
DataSourceMode="DataSet"
ConnectionString="dsn=myodbc3dsn;"
SelectCommand="SELECT EmployeeID,FirstName,LastName,Title FROM Employees"
UpdateCommand="Update Employees SET FirstName=?,LastName=?,Title=? WHERE EmployeeID=?"
OnUpdated="OnDSUpdatedHandler">
</asp:SqlDataSource>
<asp:GridView
id="GridView1"
runat="server"
AutoGenerateColumns="False"
DataKeyNames="EmployeeID"
AutoGenerateEditButton="True"
DataSourceID="SqlDataSource1">
<Columns>
<asp:BoundField HeaderText="First Name" DataField="FirstName" />
<asp:BoundField HeaderText="Last Name" DataField="LastName" />
<asp:BoundField HeaderText="Title" DataField="Title" />
</Columns>
</asp:GridView>
<asp:Label
id="Label1"
runat="server">
</asp:Label>
</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.