SqlDataSource Update Stored Procedure

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="Default" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
    <title>Untitled Page</title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <asp:SqlDataSource ID="sourceEmployees" 
                           runat="server" 
                           ProviderName="System.Data.SqlClient" 
                           ConnectionString="<%$ ConnectionStrings:Northwind %>" 
                           SelectCommand="SELECT EmployeeID, FirstName, LastName, TitleOfCourtesy FROM Employees" 
                           UpdateCommand="UpdateEmployee" 
                           UpdateCommandType="StoredProcedure" 
                           OldValuesParameterFormatString="{0}" 
                           OnUpdating="sourceEmployees_Updating">
            <UpdateParameters>
              <asp:Parameter Name="First" Type="String" />
              <asp:Parameter Name="Last" Type="String" />
            </UpdateParameters>
        </asp:SqlDataSource>
        <asp:GridView ID="GridView1" 
                      runat="server" 
                      DataSourceID="sourceEmployees" 
                      CellPadding="4" 
                      Font-Names="Verdana" 
                      Font-Size="Small" 
                      ForeColor="Navy" 
                      GridLines="None" 
                      DataKeyNames="EmployeeID" 
                      EnableSortingAndPagingCallbacks="True" 
                      PageSize="5">
            <FooterStyle BackColor="#990000" Font-Bold="True" ForeColor="White" />
            <RowStyle BackColor="#FFFBD6" ForeColor="Navy" />
            <PagerStyle BackColor="#FFCC66" ForeColor="Navy" HorizontalAlign="Center" />
            <SelectedRowStyle BackColor="#FFCC66" Font-Bold="True" ForeColor="Navy" />
            <HeaderStyle BackColor="#990000" Font-Bold="True" ForeColor="White" />
            <AlternatingRowStyle BackColor="White" />
            <Columns>
                <asp:CommandField ShowEditButton="True" />
            </Columns>
        </asp:GridView>
    </div>
    </form>
</body>
</html>

File: Default.aspx.cs

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

public partial class Default : System.Web.UI.Page
{
  protected void sourceEmployees_Updating(object sender, SqlDataSourceCommandEventArgs e)
  {
    e.Command.Parameters["@First"].Value = e.Command.Parameters["@FirstName"].Value;
    e.Command.Parameters["@Last"].Value = e.Command.Parameters["@LastName"].Value;
    e.Command.Parameters.Remove(e.Command.Parameters["@FirstName"]);
    e.Command.Parameters.Remove(e.Command.Parameters["@LastName"]);

  }
}

File: Web.config
<?xml version="1.0"?>
<configuration xmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0">
  <appSettings/>
  <connectionStrings>
    <add name="Northwind" connectionString="Data Source=localhost;Initial Catalog=Northwind;Integrated Security=SSPI"/>
  </connectionStrings>
</configuration>

Related examples in the same category

1.	Connection to Sql Express (VB.net)
2.	Static Sql connection data source (C#)
3.	Cache Sql data source (C#)
4.	SqlDataSource for Oracle
5.	Typical SqlDataSource control generated by Visual Studio
6.	Adding the DataSourceMode property to a SqlDataSource control
7.	SqlDataSource Simple
8.	SqlDataSource Update
9.	SqlDataSource with Parameters
10.	Change parameters of SqlDataSource in your own code
11.	Executing Inline SQL Statements: SelectCommand, InsertCommand, UpdateCommand, DeleteCommand
12.	Programmatically Executing SqlDataSource Commands
13.	Executing Insert, Update, and Delete Commands
14.	Executing Select Commands
15.	SqlDataSource with select command
16.	Adding the ConflictDetection property to a SqlDataSource control
17.	Detecting concurrency errors after updating data (C#)
18.	Detecting concurrency errors after updating data (VB)
19.	Adding an InsertCommand to the SqlDataSource control
20.	Filtering SqlDataSource data with a FilterExpression
21.	Adding delete functionality to the SqlDataSource Control
22.	Adding a section to the SqlDataSource control
23.	Adding an UpdateCommand to a SqlDataSource control
24.	Adding UpdateParameters to the SqlDataSource control
25.	Adding the AutoGenerateEditButton attribute to a SqlDataSource control
26.	Executing a Stored Procedure using SqlDataSource Control
27.	Handling Null values in the SqlDataSource Control
28.	Renaming Parameters passed to a Stored Procedure by handling the SqlDataSource Events
29.	Deletion using SqlDataSource Control
30.	Programmatically adding a SqlDataSource control to the Page
31.	Set sqlCacheDependency

SqlDataSource Update Stored Procedure : SqlDataSource « ADO.net Database « ASP.Net

Related examples in the same category