gridview 如何更新！！急！急！急！急！急！

各位博友，本人碰到一个问题，请教大家。
我要在GridView1表中显示EmployeeID=1的雇员，我在load 事件中这样写
protected void Page_Load(object sender, EventArgs e)
  {
        SqlDataSource1.SelectCommand="select * from Employees where EmployeeID=1"
  }
这样gridview1 就只现实EmployeeID=1的雇员。却不能更新这条记录。

表单代码如下：
<asp:GridView
  ID="GridView1"
  runat="server"
  AutoGenerateColumns="true"
  DataKeyNames="EmployeeID"
  DataSourceID="SqlDataSource1" EmptyDataText="没有可显示的数据记录。">
    <asp:CommandField
       ShowEditButton=true />  </asp:GridView>
  <asp:SqlDataSource
    ID="SqlDataSource1"
    runat="server"
    ConnectionString="<%$ ConnectionStrings:NorthwindConnectionString1 %>"
    DeleteCommand="DELETE FROM [Employees] WHERE [EmployeeID] = @original_EmployeeID"
       ProviderName="<%$ ConnectionStrings:NorthwindConnectionString1.ProviderName %>"
    
    UpdateCommand="UPDATE [Employees] SET [LastName] = @LastName, [FirstName] = @FirstName, [Title] = @Title, [TitleOfCourtesy] = @TitleOfCourtesy, [BirthDate] = @BirthDate, [HireDate] = @HireDate, [Address] = @Address, [City] = @City, [Region] = @Region, [PostalCode] = @PostalCode, [Country] = @Country, [HomePhone] = @HomePhone, [Extension] = @Extension, [Notes] = @Notes, [ReportsTo] = @ReportsTo, [PhotoPath] = @PhotoPath WHERE [EmployeeID] = @original_EmployeeID">
        <UpdateParameters>
      <asp:Parameter Name="LastName" Type="String" />
      <asp:Parameter Name="FirstName" Type="String" />
      <asp:Parameter Name="Title" Type="String" />
      <asp:Parameter Name="TitleOfCourtesy" Type="String" />
      <asp:Parameter Name="BirthDate" Type="DateTime" />
      <asp:Parameter Name="HireDate" Type="DateTime" />
      <asp:Parameter Name="Address" Type="String" />
      <asp:Parameter Name="City" Type="String" />
      <asp:Parameter Name="Region" Type="String" />
      <asp:Parameter Name="PostalCode" Type="String" />
      <asp:Parameter Name="Country" Type="String" />
      <asp:Parameter Name="HomePhone" Type="String" />
      <asp:Parameter Name="Extension" Type="String" />
      <asp:Parameter Name="Notes" Type="String" />
      <asp:Parameter Name="ReportsTo" Type="Int32" />
      <asp:Parameter Name="PhotoPath" Type="String" />
      <asp:Parameter Name="original_EmployeeID" Type="Int32" />
    </UpdateParameters>
     </asp:SqlDataSource>

我该怎样更新这条记录呢？

转载于:https://www.cnblogs.com/hbhujunbo/archive/2005/09/26/244459.html