利用RowDeleted事件捕捉SQL错误(c#,vb.net)

作者:袖梨 2022-06-25

利用RowDeleted事件捕捉SQL错误(c#)

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



    Untitled Page


   


   

        <asp教程:GridView ID="GridView1" 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">
            

           
                                     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=localhostSQLEXPRESS;Initial Catalog=Northwind;Integrated Security=True"
             providerName="System.Data.SqlClient" />
   

 
   
     
       
       
     

   

   
     
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
     

   

   
   
 

vb.net版

<%@ Page Language="VB" %>

http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

http://www.111com.net /1999/xhtml" >

    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.111com.net/ 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=localhostSQLEXPRESS;Initial Catalog=Northwind;Integrated Security=True"
             providerName="System.Data.SqlClient" />
   

 
   
     
       
       
     

   

   
     
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
     

   

   
   
 

相关文章

精彩推荐