ADO Database ASP.Net

  1. Home
  2. ASP.Net
  3. ADO Database
  4. Adding the ConflictDetection property to a SqlDataSource control



    Untitled Page


    
    

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

    


File: Web.config

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