ADO Database ASP.Net

  1. Home
  2. ASP.Net
  3. ADO Database
  4. Using the RowDeleted event to catch SQL errors (VB)
<%@ Page Language="VB" %>


    Protected Sub GridView1_RowDeleted(ByVal sender As Object, ByVal e As GridViewDeletedEventArgs)
    
        If (Not IsDBNull(e.Exception)) Then
            Me.lblErrorMessage.Text = e.Exception.Message
            e.ExceptionHandled = True
        End If
    End Sub
    Protected Sub SqlDataSource1_Deleted(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.SqlDataSourceStatusEventArgs)
        If (e.Exception IsNot Nothing) Then
            Me.lblErrorMessage.Text = e.Exception.Message
            e.ExceptionHandled = True
        End If
    End Sub
 


    Untitled Page


    
                      Runat="server" 
                  DataSourceID="SqlDataSource1"
                  DataKeyNames="CustomerID" 
                  AutoGenerateColumns="False"
                  AllowSorting="True" 
                  AllowPaging="True"
                  AutoGenerateEditButton="true" 
                  AutoGenerateDeleteButton="true" 
                  OnRowDeleted="GridView1_RowDeleted">
         
                                 FirstPageText="Go to the first page" 
                        LastPageText="Go to the last page" 
                        Mode="NextPreviousFirstLast">
         
            
                                                HeaderText="CustomerID" 
                                DataField="CustomerID"
                                SortExpression="CustomerID" 
                                Visible="False">
                                    DataNavigateUrlFields="CustomerID,Country" SortExpression="CompanyName"
                    DataNavigateUrlFormatString=
                        "http://www.yourServer.com/Customer.aspx?id={0}&country={1}"
                    DataTextField="CompanyName">
                
                                     SortExpression="ContactName">
                                     SortExpression="ContactTitle">
                                     SortExpression="Address">
                                     SortExpression="City">
                                     DataField="Region" SortExpression="Region">
                                     SortExpression="PostalCode">
                                     SortExpression="Country">
                                     SortExpression="Phone">
                                     SortExpression="Fax">
                     
            
        
                     SelectCommand="SELECT * FROM [Customers]"
             ConnectionString="<%$ ConnectionStrings:AppConnectionString1 %>"
             DataSourceMode="DataSet"
             DeleteCommand="DELETE From Customers WHERE (CustomerID = @CustomerID)"
             UpdateCommand="UPDATE [Customers] SET [CompanyName] = @CompanyName,
                  [ContactName] = @ContactName, [ContactTitle] = @ContactTitle,
                  [Address] = @Address, [City] = @City, [Region] = @Region, 
                  [PostalCode] = @PostalCode, [Country] = @Country, [Phone] = @Phone,
                  [Fax] = @Fax WHERE [CustomerID] = @original_CustomerID" OnDeleted="SqlDataSource1_Deleted">
             
                 
                 
                 
                 
                 
                 
                 
                 
                 
                 
                 
             
         
        
    

    


File: Web.config

  
  
                     connectionString="Data Source=localhost\SQLEXPRESS;Initial Catalog=Northwind;Integrated Security=True"
             providerName="System.Data.SqlClient" />