ADO Database ASP.Net

  1. Home
  2. ASP.Net
  3. ADO Database
  4. SqlDataSource Update
<%@ Page Language="C#" AutoEventWireup="true"%>



    Untitled Page


    
    

                                   runat="server" 
                           ProviderName="System.Data.SqlClient" 
                           ConnectionString="<%$ ConnectionStrings:Northwind %>" 
                           SelectCommand="SELECT EmployeeID, FirstName, LastName, Title, City FROM Employees" 
                           UpdateCommand="UPDATE Employees SET FirstName=@FirstName, LastName=@LastName, Title=@Title, City=@City FROM Employees WHERE EmployeeID=@EmployeeID"  
                           UpdateCommandType="StoredProcedure"/>
        
                              runat="server" 
                      DataSourceID="sourceEmployees" 
                      CellPadding="4" 
                      Font-Names="Verdana" 
                      Font-Size="Small" 
                      ForeColor="Navy" 
                      GridLines="None" 
                      DataKeyNames="EmployeeID" 
                      EnableSortingAndPagingCallbacks="True" 
                      PageSize="5">
            
            
            
            
            
            
            
                
            
        
    

    


File: Web.config