title: error in Update command
body: <p>in my project(Asp.net website using C#), I have a formview that is connected to a sqlserevrDataSource.
  because Of using specify custom sql statement for sqlDataSource Configuration, I can't use Advanced button for active Insert,Update,Delete . Now for adding update feature for my datasource I add UpdateCommand in my source code manually, but it had an error that said :</p>
  
  <pre><code>Invalid column name 'Email'.
  Invalid column name 'IsApproved'.
  Invalid column name 'IsLockedOut'.
  Invalid column name 'LastLockoutDate'.
  
  Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. 
  </code></pre>
  
  <p>the code:</p>
  
  <pre><code>&lt;%@ Page Title="" Language="C#" MasterPageFile="~/MasterPageAdmin.master" AutoEventWireup="true" CodeFile="edit-user.aspx.cs" Inherits="edit_user" %&gt;
  
  &lt;asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server"&gt;
  &lt;/asp:Content&gt;
  &lt;asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server"&gt;
  
          &lt;asp:FormView ID="FormView1" runat="server" DefaultMode="Edit" DataSourceID="SqlDataSource1"&gt;
              &lt;EditItemTemplate&gt;
                  UserName:
                  &lt;asp:TextBox ID="UserNameTextBox" runat="server" Text='&lt;%# Bind("UserName") %&gt;' /&gt;
                  &lt;br /&gt;
                  LastActivityDate:
                  &lt;asp:TextBox ID="LastActivityDateTextBox" runat="server" Text='&lt;%# Bind("LastActivityDate") %&gt;' /&gt;
                  &lt;br /&gt;
                  Email:
                  &lt;asp:TextBox ID="EmailTextBox" runat="server" Text='&lt;%# Bind("Email") %&gt;' /&gt;
                  &lt;br /&gt;
                  IsApproved:
                  &lt;asp:CheckBox ID="IsApprovedCheckBox" runat="server" Checked='&lt;%# Bind("IsApproved") %&gt;' /&gt;
                  &lt;br /&gt;
                  IsLockedOut:
                  &lt;asp:CheckBox ID="IsLockedOutCheckBox" runat="server" Checked='&lt;%# Bind("IsLockedOut") %&gt;' /&gt;
                  &lt;br /&gt;
                  LastLockoutDate:
                  &lt;asp:TextBox ID="LastLockoutDateTextBox" runat="server" Text='&lt;%# Bind("LastLockoutDate") %&gt;' /&gt;
                  &lt;br /&gt;
                  UserId:
                  &lt;asp:TextBox ID="UserIdTextBox" runat="server" Text='&lt;%# Bind("UserId") %&gt;' /&gt;
                  &lt;br /&gt;
                  &lt;asp:LinkButton ID="UpdateButton" runat="server" CausesValidation="True" CommandName="Update" Text="Update" /&gt;
                  &amp;nbsp;&lt;asp:LinkButton ID="UpdateCancelButton" runat="server" CausesValidation="False" CommandName="Cancel" Text="Cancel" /&gt;
              &lt;/EditItemTemplate&gt;
              &lt;InsertItemTemplate&gt;
                  UserName:
                  &lt;asp:TextBox ID="UserNameTextBox" runat="server" Text='&lt;%# Bind("UserName") %&gt;' /&gt;
                  &lt;br /&gt;
                  LastActivityDate:
                  &lt;asp:TextBox ID="LastActivityDateTextBox" runat="server" Text='&lt;%# Bind("LastActivityDate") %&gt;' /&gt;
                  &lt;br /&gt;
                  Email:
                  &lt;asp:TextBox ID="EmailTextBox" runat="server" Text='&lt;%# Bind("Email") %&gt;' /&gt;
                  &lt;br /&gt;
                  IsApproved:
                  &lt;asp:CheckBox ID="IsApprovedCheckBox" runat="server" Checked='&lt;%# Bind("IsApproved") %&gt;' /&gt;
                  &lt;br /&gt;
                  IsLockedOut:
                  &lt;asp:CheckBox ID="IsLockedOutCheckBox" runat="server" Checked='&lt;%# Bind("IsLockedOut") %&gt;' /&gt;
                  &lt;br /&gt;
                  LastLockoutDate:
                  &lt;asp:TextBox ID="LastLockoutDateTextBox" runat="server" Text='&lt;%# Bind("LastLockoutDate") %&gt;' /&gt;
                  &lt;br /&gt;
                  UserId:
                  &lt;asp:TextBox ID="UserIdTextBox" runat="server" Text='&lt;%# Bind("UserId") %&gt;' /&gt;
                  &lt;br /&gt;
                  &lt;asp:LinkButton ID="InsertButton" runat="server" CausesValidation="True" CommandName="Insert" Text="Insert" /&gt;
                  &amp;nbsp;&lt;asp:LinkButton ID="InsertCancelButton" runat="server" CausesValidation="False" CommandName="Cancel" Text="Cancel" /&gt;
              &lt;/InsertItemTemplate&gt;
              &lt;ItemTemplate&gt;
                  UserName:
                  &lt;asp:Label ID="UserNameLabel" runat="server" Text='&lt;%# Bind("UserName") %&gt;' /&gt;
                  &lt;br /&gt;
                  LastActivityDate:
                  &lt;asp:Label ID="LastActivityDateLabel" runat="server" Text='&lt;%# Bind("LastActivityDate") %&gt;' /&gt;
                  &lt;br /&gt;
                  Email:
                  &lt;asp:Label ID="EmailLabel" runat="server" Text='&lt;%# Bind("Email") %&gt;' /&gt;
                  &lt;br /&gt;
                  IsApproved:
                  &lt;asp:CheckBox ID="IsApprovedCheckBox" runat="server" Checked='&lt;%# Bind("IsApproved") %&gt;' Enabled="false" /&gt;
                  &lt;br /&gt;
                  IsLockedOut:
                  &lt;asp:CheckBox ID="IsLockedOutCheckBox" runat="server" Checked='&lt;%# Bind("IsLockedOut") %&gt;' Enabled="false" /&gt;
                  &lt;br /&gt;
                  LastLockoutDate:
                  &lt;asp:Label ID="LastLockoutDateLabel" runat="server" Text='&lt;%# Bind("LastLockoutDate") %&gt;' /&gt;
                  &lt;br /&gt;
                  UserId:
                  &lt;asp:Label ID="UserIdLabel" runat="server" Text='&lt;%# Bind("UserId") %&gt;' /&gt;
                  &lt;br /&gt;
  
              &lt;/ItemTemplate&gt;
          &lt;/asp:FormView&gt;
  
      &lt;asp:SqlDataSource ID="SqlDataSource1" runat="server" 
  
      ConnectionString="&lt;%$ ConnectionStrings:akhbarrConnectionString %&gt;" 
      SelectCommand="SELECT aspnet_Users.UserName, aspnet_Users.LastActivityDate, aspnet_Membership.Email, aspnet_Membership.IsApproved, aspnet_Membership.IsLockedOut, aspnet_Membership.LastLockoutDate, aspnet_Users.UserId FROM aspnet_Users INNER JOIN aspnet_Membership ON aspnet_Membership.UserId = aspnet_Users.UserId WHERE (aspnet_Users.UserName = @UserName)"
          updatecommand="update [aspnet_Users] set [UserName] =@UserName , [LastActivityDate]= @LastActivityDate , [Email]= @Email , [IsApproved] = @IsApproved , [IsLockedOut] = @IsLockedOut , [LastLockoutDate] = @LastLockoutDate , [UserId]= @UserId from aspnet_Users INNER JOIN aspnet_Membership ON aspnet_Membership.UserId = aspnet_Users.UserId"&gt;
  
          &lt;UpdateParameters&gt;
              &lt;asp:Parameter Name="UserName" Type="string" /&gt;
              &lt;asp:Parameter Name="LastActivityDate" Type="DateTime" /&gt;
              &lt;asp:Parameter Name="Email" Type="string" /&gt;
              &lt;asp:Parameter Name="IsApproved" Type="Boolean" /&gt;
              &lt;asp:Parameter Name="IsLockedOut" Type="Boolean" /&gt;
              &lt;asp:Parameter Name="LastLockoutDate" Type="DateTime" /&gt;
              &lt;asp:Parameter Name="UserId" Type="String" /&gt;
  
  
          &lt;/UpdateParameters&gt;
           &lt;SelectParameters&gt;
              &lt;asp:QueryStringParameter DefaultValue="0" Name="UserName" QueryStringField="UserName" /&gt;
          &lt;/SelectParameters&gt;
          &lt;/asp:SqlDataSource&gt;
  
  &lt;/asp:Content&gt;
  </code></pre>