title: Update of AccessDatasource does nothing but has no error
body: <p>My UPDATE command fails to change any date in the table while very similar SELECT and DELETE commands work.  When I change the UpdateParameters to invalid choices, the code behind command throws an error, but when the parameters are correct, nothing hapens.</p>
  
  <p>Code behind to activate DELETE (which works)</p>
  
  <pre><code>protected void Button2_Click(object sender, EventArgs e)
  {
      this.AccessDataSource6.Delete();
  }
  </code></pre>
  
  <p>Code behind to activate UPDATE (which does seem to have any effect on the data)</p>
  
  <pre><code>protected void Button1_Click(object sender, EventArgs e)
  {
      this.AccessDataSource6.Update();
  } 
  </code></pre>
  
  <p>The AccessDatasource, its SQL commands and parameters</p>
  
  <pre><code>   &lt;asp:AccessDataSource ID="AccessDataSource6" runat="server" DataFile="~/App_Data/ASPNetDB.mdb" 
      SelectCommand="SELECT [PracticeDate], 
                            [StartTime], 
                            [EndTime], 
                            [Division], 
                            [TeamStr], 
                            [FieldName] 
      FROM [vw_fbScheduleFull]
      WHERE (([LocationID] = ?) 
         AND ([DayName] = ?) 
         AND ([PracticeDate] &amp;gt;= ?) 
         AND ([PracticeDate] &amp;lt;= ?) 
         AND ([StartTime] = ?))
      ORDER BY [PracticeDate], [FieldName]"
  
      UpdateCommand="UPDATE fbPracticeSlot 
      SET StartTime = ?, EndTime = ?
      WHERE ID IN (
         SELECT [PracticeSlotID] 
         FROM [vw_fbScheduleFull] 
         WHERE (([LocationID] = ?) 
            AND ([DayName] = ?) 
            AND ([PracticeDate] &amp;gt;= ?) 
            AND ([PracticeDate] &amp;lt;= ?) 
            AND ([StartTime] = ?))
         )" 
  
     DeleteCommand="DELETE FROM fbPracticeSlot 
      WHERE ID IN (
         SELECT [PracticeSlotID] 
         FROM [vw_fbScheduleFull]
         WHERE (([LocationID] = ?) 
            AND ([DayName] = ?) 
            AND ([PracticeDate] &amp;gt;= ?) 
            AND ([PracticeDate] &amp;lt;= ?) 
            AND ([StartTime] = ?)) 
         )"&gt;
  
  &lt;SelectParameters&gt;
         &lt;asp:ControlParameter ControlID="DropDownListLocation" Name="LocationID" PropertyName="SelectedValue" Type="Int32" /&gt;
         &lt;asp:ControlParameter ControlID="DropDownListDOW" Name="DayName" PropertyName="SelectedValue" Type="String" /&gt;
         &lt;asp:ControlParameter ControlID="DropDownListStartDate" Name="PracticeDate" PropertyName="SelectedValue" Type="DateTime" /&gt;
         &lt;asp:ControlParameter ControlID="DropDownListEndDate" Name="PracticeDate2" PropertyName="SelectedValue" Type="DateTime" /&gt;
         &lt;asp:ControlParameter ControlID="DropDownListStartTime" Name="StartTime" PropertyName="SelectedValue" Type="DateTime" /&gt;
  &lt;/SelectParameters&gt;
  
  &lt;UpdateParameters&gt;
         &lt;asp:ControlParameter ControlID="DropDownListNewStart" Name="NewStartTime" PropertyName="SelectedValue" Type="DateTime" /&gt;                  
         &lt;asp:ControlParameter ControlID="DropDownListNewEnd" Name="NewEndTime" PropertyName="SelectedValue" Type="DateTime" /&gt;
         &lt;asp:ControlParameter ControlID="DropDownListLocation" Name="LocationID" PropertyName="SelectedValue" Type="Int32" /&gt;
         &lt;asp:ControlParameter ControlID="DropDownListDOW" Name="DayName" PropertyName="SelectedValue" Type="String" /&gt;
         &lt;asp:ControlParameter ControlID="DropDownListStartDate" Name="PracticeDate" PropertyName="SelectedValue" Type="DateTime" /&gt;
         &lt;asp:ControlParameter ControlID="DropDownListEndDate" Name="PracticeDate2" PropertyName="SelectedValue" Type="DateTime" /&gt;
         &lt;asp:ControlParameter ControlID="DropDownListStartTime" Name="StartTime" PropertyName="SelectedValue" Type="DateTime" /&gt;
  &lt;/UpdateParameters&gt;
  
  &lt;DeleteParameters&gt;
         &lt;asp:ControlParameter ControlID="DropDownListLocation" Name="LocationID" PropertyName="SelectedValue" Type="Int32" /&gt;
         &lt;asp:ControlParameter ControlID="DropDownListDOW" Name="DayName" PropertyName="SelectedValue" Type="String" /&gt;
         &lt;asp:ControlParameter ControlID="DropDownListStartDate" Name="PracticeDate" PropertyName="SelectedValue" Type="DateTime" /&gt;
         &lt;asp:ControlParameter ControlID="DropDownListEndDate" Name="PracticeDate2" PropertyName="SelectedValue" Type="DateTime" /&gt;
         &lt;asp:ControlParameter ControlID="DropDownListStartTime" Name="StartTime" PropertyName="SelectedValue" Type="DateTime" /&gt;
  &lt;/DeleteParameters&gt;
  
  &lt;/asp:AccessDataSource&gt;
  </code></pre>
  
  <p>Please help me understand why the update is not changing data.</p>
  
  <p>It seems that I either need to write UpdateCommands with hard coded parameters for the values to change or write a DeleteCommand and InsertCommand for each update that I want to perform.  Please help me find some way to avoid that sort of kludge.</p>