ADO Database ASP.Net

  1. Home
  2. ASP.Net
  3. ADO Database
  4. Renaming Parameters passed to a Stored Procedure by handling the SqlDataSource Events
<%@ Page Language="C#" AutoEventWireup="true"%>

  void deptSource_Updating(Object sender, System.Web.UI.WebControls.SqlDataSourceCommandEventArgs e) 
  {    
    e.Command.Parameters["@DeptName"].Value = e.Command.Parameters["@Name"].Value;
    e.Command.Parameters["@DeptGroupName"].Value = e.Command.Parameters["@GroupName"].Value;    
    e.Command.Parameters.Remove(e.Command.Parameters["@Name"]);
    e.Command.Parameters.Remove(e.Command.Parameters["@GroupName"]);    
  }


  
    Renaming Parameters passed to a Stored Procedure by handling the SqlDataSource Events
  
  
    
              DataSourceID="deptSource" AutoGenerateEditButton="true" DataKeyNames="DepartmentID"
        AutoGenerateColumns="False" HeaderStyle-HorizontalAlign="Center" HeaderStyle-Font-Bold="True"
        HeaderStyle-BackColor="blue" HeaderStyle-ForeColor="White">
        
          
          
          
          
        
      
              ConnectionString="<%$ ConnectionStrings:AdventureWorks%>" 
        SelectCommand= "SELECT DepartmentID, Name, GroupName, ModifiedDate from HumanResources.Department" 
        UpdateCommand="UpdateDepartment" UpdateCommandType="StoredProcedure" OnUpdating="deptSource_Updating" >