ADO Database ASP.Net

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


    Protected Sub SqlDataSource1_Updated(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.SqlDataSourceStatusEventArgs)
        If (e.AffectedRows > 0) Then
            Message.Text = "The record has been updated"
        Else
            Message.Text = "Possible concurrency violation"
        End If
    End Sub



    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">