ADO Database ASP.Net

  1. Home
  2. ASP.Net
  3. ADO Database
  4. Detecting concurrency errors after updating data (C#)
<%@ Page Language="C#" %>


protected void SqlDataSource1_Updated(object sender, SqlDataSourceStatusEventArgs e)
{
    if (e.AffectedRows > 0)
        Message.Text = "The record has been updated";
    else
        Message.Text = "Possible concurrency violation";
}



    Untitled Page


    
    

                                   Runat="server" 
                           SelectCommand="SELECT * FROM [Customers] WHERE ([CustomerID] = @CustomerID)"
                           ConnectionString="<%$ ConnectionStrings:AppConnectionString1 %>"
                           DataSourceMode="DataSet"
                           ConflictDetection="CompareAllValues" 
                           OnUpdated="SqlDataSource1_Updated">
            
                                                          QueryStringField="id" 
                                          Type="String">