Greetings all!
After a week of toiling I've finallay decided to post the code below with
hopes that someone can point out my error(s).
Basically I have a Gridview/Formview on a ASP.NEt 2.0 page.
When I select a record on the Gridview I'm presented with the corresponding
FormView Template for Editing. Works fine!
ItemTemplate in FormView works fine...Edit button takes me Edit Template!
However...
Upon clicking the Update button on the item Tempalte (With the associated
SqlDataSource associated below my data fails to update.)
I'm sure my error is obvious but I just cannot find it.
<asp:SqlDataSou rce ID="REACTOR_AHT s" runat="server"
ConnectionStrin g="<%$
ConnectionStrin gs:REACTORConne ctionString % %>"
ProviderName="< %$
ConnectionStrin gs:REACTORConne ctionString.Pro viderName %>"
OldValuesParame terFormatString ="original_{ 0}"
SelectCommand=
"SELECT CaseCounter,
Condition_of_An imal,
TreatmentCardHi story
FROM Animal_Health_R ecords
WHERE (CaseCounter = @CaseCounter)"
UpdateCommand=
"UPDATE Animal_Health_R ecords
SET Condition_of_An imal = @Condition_of_A nimal,
TreatmentCardHi story = @TreatmentCardH istory
WHERE (Animal_Health_ Records.CaseCou nter =
@original_CaseC ounter)">
<DeleteParamete rs>
</DeleteParameter s>
<UpdateParamete rs>
<asp:Paramete r Name="Condition _of_Animal" Type="String" />
<asp:Paramete r Name="Treatment CardHistory" Type="String"
/>
<asp:ControlPar ameter ControlID="grdR EACTOR"
Name="original_ CaseCounter" PropertyName="S electedValue" Type="Int32" />
</UpdateParameter s>
<SelectParamete rs>
<asp:ControlPar ameter ControlID="grdR EACTOR"
Name="CaseCount er" PropertyName="S electedValue"
Type="Int32" />
</SelectParameter s>
</asp:SqlDataSour ce>
--
All suggestions welcomed!
Application Engineer / DBA
UCLA SOM
