I have a very simple setup that should work fine per documentation. However,
my gridview control will not properly update using the updatecommand of the
sqldatasource. I've simplified everything below. I'd like to be able to see a
table of results in my gridview, click edit on any particular record, modify
the data, then click update. What I find is happening is that my parameters
are not being updated when I go into edit mode, change the text of the
"firstName" field, and click update. In the OnUpdating method of the
sqldatasource, I've stepped through the command parameters collection and it
always contains the original values, not what I've typed into the editable
textboxes in my grid.
<asp:GridView ID="gvContacts " PageSize="200" DataKeyNames="i d"
CssClass="GridV iewStyle" GridLines="both " AllowSorting="t rue" runat="server"
AutoGenerateCol umns="False" DataSourceID="S qlDataSource1"
AllowPaging="Tr ue" Width="98%" Visible="true" >
<Columns>
<asp:BoundFie ld DataField="firs tName" HeaderText="Fir st Name"
SortExpression= "firstName" HeaderStyle-HorizontalAlign ="center"
HeaderStyle-VerticalAlign=" middle" >
</asp:BoundField>
<asp:CommandFie ld ShowEditButton= "true" ShowDeleteButto n="true" />
</Columns>
</asp:GridView>
<asp:SqlDataSou rce
ID="SqlDataSour ce1"
runat="server"
OldValuesParame terFormatString ="original_{ 0}"
ProviderName="S ystem.Data.SqlC lient"
ConnectionStrin g="<%$ ConnectionStrin gs:MyConnection String%>"
SelectCommand=" SELECT id, firstName, lastName, email, phone, importance,
message, subscribeToNews letter, howDidYouHearAb outUs, createdBy, dateCreated,
lastUpdateBy, lastUpdateDate FROM Contacts"Select CommandType="te xt"
UpdateCommand = "UPDATE Contacts SET firstName=@firs tName where
id=@original_id "
UpdateCommandTy pe="text"
DeleteCommand=" DELETE FROM Contacts WHERE id=@original_id "
DeleteCommandTy pe="Text">
</asp:SqlDataSour ce>
--
PK9
