SqlDataSource Update Doesn't Work When Using Parameter

Hi all:

I have a list of items (actually a relation in which a user has selected an item, along with a rating for the item) in an Access database table, connected to my app with a SqlDataSource and bound to a repeater.  The repeater displays the items to the user along with a dropdown box to show the rating, and allow the user to update it.  The page connects and displays correctly.

My problem is that when the user submits the page and I iterate through the repeater items to update each rating, the updates are not being completed in the database.  The update works if I hard-code a value for the rating into the query itself, but not when using an updateparameter (pTaskRating below).  In other words if I replace pTaskRating with '5', all the correct records will be found and have their ratings updated to 5.  That means that the mySurveyId and pTaskId(DefaultValue) parameters have to be working, because the right records are found, but I can't seem to update records based on the DefaultValue of the pTaskRating parameter, even though I can verify that the DefaultValue is correct by placing a watch on it.  It seems that my problem must be in my use of that particular parameter in the query, either in properties of the parameter or in the value assigned to it.  I am extremely frustrated - any ideas would be greatly, greatly appreciated.  Thanks!

Bruck

The table I'm pulling from and updating looks like this:

SURVEY_ID (Text 50), TASK_ID (Long Int), RATING_ID (Long Int)

Here's my ASPX for the main data source:

<asp:SqlDataSource ID="sqlTaskSelections" runat="server" ConnectionString='Provider=Microsoft.Jet.OLEDB.4.0;Data Source="abc.mdb";Persist Security Info=True;Jet OLEDB:Database Password=xyz' ProviderName="System.Data.OleDb" SelectCommand="SELECT [SURVEY_ID], [TASK_ID], [RATING_ID] FROM [TBL_TASK_SELECTION] WHERE [SURVEY_ID] = mySurveyId" UpdateCommand="UPDATE [TBL_TASK_SELECTION] SET [RATING_ID] = pTaskRating WHERE ([SURVEY_ID] = mySurveyId) AND ([TASK_ID] = pTaskId)">

<UpdateParameters>


<asp:SessionParameter Name="mySurveyId" SessionField="SurveyId" DefaultValue="" />
<asp:Parameter Name="pTaskId" DefaultValue="" />
<asp:Parameter Name="pTaskRating" DefaultValue="" />

</UpdateParameters>

And here's the repeater (the Task ID and Rating are stored in hidden fields for easy access later):

<asp:Repeater ID="rptTaskSelections" runat="server">


<HeaderTemplate><table border="0"></HeaderTemplate>


<ItemTemplate>


<tr class="abctr">
<td class="normal">
<asp:DropDownList ID="cbRatings" runat="server"></asp:DropDownList>
<asp:HiddenField ID="hTaskId" Runat="server" Visible="false" Value='<%# Eval("TASK_ID") %>' />
<asp:HiddenField ID="hRating" Runat="server" Visible="false" Value='<%# Eval("RATING_ID") %>' />
<%# Eval("TASK_ID") %>
</td>
</tr>

</ItemTemplate>


<FooterTemplate></td></tr></table></FooterTemplate>

</asp:Repeater>

And here's the page load and submit VB:

Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load


If Not Page.IsPostBack Then



'BIND / LOAD RATINGS TO DROPDOWN BOXES HERE

Dim i As Integer
Dim cbCurrentRating As DropDownList
Dim hCurrentRating As HiddenField
rptTaskSelections.DataSource = sqlTaskSelections
rptTaskSelections.DataBind()



For i = 0 To rptTaskSelections.Items.Count - 1




cbCurrentRating = rptTaskSelections.Items(i).FindControl("cbRatings")
hCurrentRating = rptTaskSelections.Items(i).FindControl("hRating")




cbCurrentRating.DataSource = sqlRatings
cbCurrentRating.DataTextField = "RATING"
cbCurrentRating.DataValueField = "ID"
cbCurrentRating.DataBind()
cbCurrentRating.SelectedValue = hCurrentRating.Value



Next


End If

End Sub

Protected Sub btnSubmitRateTasks_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSubmitRateTasks.Click


'UPDATE RATINGS HERE


Dim i As Integer
Dim cbCurrentRating As DropDownList
Dim hCurrentTaskId As HiddenField


For i = 0 To rptTaskSelections.Items.Count - 1



cbCurrentRating = rptTaskSelections.Items(i).FindControl("cbRatings")
hCurrentTaskId = rptTaskSelections.Items(i).FindControl("hTaskId")



sqlTaskSelections.UpdateParameters.Item("pTaskId").DefaultValue = hCurrentTaskId.Value
sqlTaskSelections.UpdateParameters.Item("pTaskRating").DefaultValue = cbCurrentRating.SelectedValue

sqlTaskSelections.Update()


Next


Response.Redirect("nextpage.aspx")

End Sub