SqlDataSource and Optimistic Concurrency Problems

stuart.d.jones · Jan 30, 2006

Hi,

I'm using a detailsview control with an SqlDataSource control. My
Update query isn't working, and I've narrowed it down to the optimistic
concurrency parameters - i.e. when I comment them out of the query, it
works. What seems to be happening is that if a field is NULL when it
is read in through the select statement, it's causing the update
statment not to find a match. I've got ConvertEmptyStringToNull not
set (so it should default to true), but I can't get the update to work
all the time and it's driving me crazy.

Here's my code:

Stored Procedure for Select as follows (the Update's going in a Stored
Procedure when I can get it to work...):
SELECT Customers.CustID, Customers.CustDisplayName,
Customers.CustFirstName, Customers.CustSurname, Customers.CustType,
Customers.CustNotes, Customers.CustIsBillingSame,
Customers.CustNumEmployees, Customers.CustIsProspect,
Customers.CustOnHold, Customers.CustPersonID,
Customers.CustUserFieldB1, Customers.CustUserFieldB2,
Customers.CustUserFieldB3, Customers.CustUserFieldD1,
Customers.CustUserFieldD2, Customers.CustUserFieldD3,
Customers.CustUserFieldI1, Customers.CustUserFieldI2,
Customers.CustUserFieldI3, Customers.CustCategory,
Customers.CustInactive, CustomerContactDetails_1.CustContactStreet1,
CustomerContactDetails_1.CustContactStreet2,
CustomerContactDetails_1.CustContactStreet3,
CustomerContactDetails_1.CustContactTown,
CustomerContactDetails_1.CustContactCounty,
CustomerContactDetails_1.CustContactPostCode,
CustomerContactDetails_1.CustContactCountry,
CustomerContactDetails_1.CustContactTelephone,
CustomerContactDetails_1.CustContactMobile,
CustomerContactDetails_1.CustContactEMail,
CustomerContactDetails_1.CustContactFax,
CustomerContactDetails.CustContactStreet1 AS CustBContactStreet1,
CustomerContactDetails.CustContactStreet2 AS CustBContactStreet2,
CustomerContactDetails.CustContactStreet3 AS CustBContactStreet3,
CustomerContactDetails.CustContactTown AS CustBContactTown,
CustomerContactDetails.CustContactCounty AS CustBContactCounty,
CustomerContactDetails.CustContactPostCode AS CustBContactPostCode,
CustomerContactDetails.CustContactCountry AS CustBContactCountry,
CustomerContactDetails.CustContactTelephone AS CustBContactTelephone,
CustomerContactDetails.CustContactMobile AS CustBContactMobile,
CustomerContactDetails.CustContactEMail AS CustBContactEMail,
CustomerContactDetails.CustContactFax AS CustBContactFax FROM Customers
LEFT OUTER JOIN CustomerContactDetails AS CustomerContactDetails_1 ON
Customers.CustAddressID = CustomerContactDetails_1.CustContactID LEFT
OUTER JOIN CustomerContactDetails ON Customers.CustBillingID =
CustomerContactDetails.CustContactID WHERE (Customers.CustID = @CustID)

<asp:SqlDataSource ID="SqlDataSource2" runat="server"
ConflictDetection="CompareAllValues"
ConnectionString="<%$
ConnectionStrings:FocusSystemsConnectionString %>"
OldValuesParameterFormatString="original_{0}"
ProviderName="<%$
ConnectionStrings:FocusSystemsConnectionString.ProviderName %>"
SelectCommand="SelectCustomersAndAddresses"
SelectCommandType="StoredProcedure"
UpdateCommand="UPDATE [Customers] SET
[CustDisplayName] = @CustDisplayName, [CustFirstName] = @CustFirstName,
[CustSurname] = @CustSurname, [CustType] = @CustType, [CustNotes] =
@CustNotes, [CustIsBillingSame] = @CustIsBillingSame,
[CustNumEmployees] = @CustNumEmployees, [CustIsProspect] =
@CustIsProspect, [CustOnHold] = @CustOnHold, [CustPersonID] =
@CustPersonID, [CustUserFieldB1] = @CustUserFieldB1, [CustUserFieldB2]
= @CustUserFieldB2, [CustUserFieldB3] = @CustUserFieldB3,
[CustUserFieldD1] = @CustUserFieldD1, [CustUserFieldD2] =
@CustUserFieldD2, [CustUserFieldD3] = @CustUserFieldD3,
[CustUserFieldI1] = @CustUserFieldI1, [CustUserFieldI2] =
@CustUserFieldI2, [CustUserFieldI3] = @CustUserFieldI3, [CustCategory]
= @CustCategory, [CustInactive] = @CustInactive WHERE [CustID] =
@original_CustID AND [CustDisplayName] = @original_CustDisplayName AND
[CustFirstName] = @original_CustFirstName AND [CustSurname] =
@original_CustSurname AND [CustType] = @original_CustType AND
[CustIsBillingSame] = @original_CustIsBillingSame AND
[CustNumEmployees] = @original_CustNumEmployees AND [CustIsProspect] =
@original_CustIsProspect AND [CustOnHold] = @original_CustOnHold AND
[CustPersonID] = @original_CustPersonID AND [CustCategory] =
@original_CustCategory AND [CustInactive] = @original_CustInactive"
EnableViewState="true">
<UpdateParameters>
<asp

arameter Name="CustDisplayName"
Type="String" />
<asp

arameter Name="CustFirstName"
Type="String" />
<asp

arameter Name="CustSurname" Type="String"
/>
<asp

arameter Name="CustType" Type="String" />
<asp

arameter Name="CustNotes" Type="String"
/>
<asp

arameter Name="CustIsBillingSame"
Type="Boolean" />
<asp

arameter Name="CustNumEmployees"
Type="Int32" />
<asp

arameter Name="CustIsProspect"
Type="Boolean" />
<asp

arameter Name="CustOnHold" Type="Boolean"
/>
<asp

arameter Name="CustPersonID" />
<asp

arameter Name="CustUserFieldB1"
Type="String" />
<asp

arameter Name="CustUserFieldB2"
Type="String" />
<asp

arameter Name="CustUserFieldB3"
Type="String" />
<asp

arameter Name="CustUserFieldD1"
Type="String" />
<asp

arameter Name="CustUserFieldD2"
Type="String" />
<asp

arameter Name="CustUserFieldD3"
Type="String" />
<asp

arameter Name="CustUserFieldI1"
Type="String" />
<asp

arameter Name="CustUserFieldI2"
Type="String" />
<asp

arameter Name="CustUserFieldI3"
Type="String" />
<asp

arameter Name="CustCategory"
Type="String" />
<asp

arameter Name="CustInactive"
Type="Boolean" />
<asp

arameter Name="original_CustID" />
<asp

arameter Name="original_CustDisplayName"
/>
<asp

arameter Name="original_CustFirstName" />
<asp

arameter Name="original_CustSurname" />
<asp

arameter Name="original_CustType" />
<asp

arameter Name="original_CustNotes" />
<asp

arameter
Name="original_CustIsBillingSame" />
<asp

arameter Name="original_CustNumEmployees"
/>
<asp

arameter Name="original_CustIsProspect"
/>
<asp

arameter Name="original_CustOnHold" />
<asp

arameter Name="original_CustPersonID" />
<asp

arameter Name="original_CustUserFieldB1"
/>
<asp

arameter Name="original_CustUserFieldB2"
/>
<asp

arameter Name="original_CustUserFieldB3"
/>
<asp

arameter Name="original_CustUserFieldD1"
/>
<asp

arameter Name="original_CustUserFieldD2"
/>
<asp

arameter Name="original_CustUserFieldD3"
/>
<asp

arameter Name="original_CustUserFieldI1"
/>
<asp

arameter Name="original_CustUserFieldI2"
/>
<asp

arameter Name="original_CustUserFieldI3"
/>
<asp

arameter Name="original_CustCategory" />
<asp

arameter Name="original_CustInactive" />
<asp

arameter Name="CustContactStreet1"
Type="String" />
<asp

arameter Name="CustContactStreet2"
Type="String" />
<asp

arameter Name="CustContactStreet3"
Type="String" />
<asp

arameter Name="CustContactTown"
Type="String" />
<asp

arameter Name="CustContactCounty"
Type="String" />
<asp

arameter Name="CustContactPostCode"
Type="String" />
<asp

arameter Name="CustContactCountry"
Type="String" />
<asp

arameter Name="CustContactTelephone"
Type="String" />
<asp

arameter Name="CustContactMobile"
Type="String" />
<asp

arameter Name="CustContactEMail"
Type="String" />
<asp

arameter Name="CustContactFax"
Type="String" />
<asp

arameter
Name="original_CustContactStreet1" Type="String" />
<asp

arameter
Name="original_CustContactStreet2" Type="String" />
<asp

arameter
Name="original_CustContactStreet3" Type="String" />
<asp

arameter Name="original_CustContactTown"
Type="String" />
<asp

arameter
Name="original_CustContactCounty" Type="String" />
<asp

arameter
Name="original_CustContactPostCode" Type="String" />
<asp

arameter
Name="original_CustContactCountry" Type="String" />
<asp

arameter
Name="original_CustContactTelephone" Type="String" />
<asp

arameter
Name="original_CustContactMobile" Type="String" />
<asp

arameter Name="original_CustContactEMail"
Type="String" />
<asp

arameter Name="original_CustContactFax"
Type="String" />
<asp

arameter Name="CustBContactStreet1"
Type="String" />
<asp

arameter Name="CustBContactStreet2"
Type="String" />
<asp

arameter Name="CustBContactStreet3"
Type="String" />
<asp

arameter Name="CustBContactTown"
Type="String" />
<asp

arameter Name="CustBContactCounty"
Type="String" />
<asp

arameter Name="CustBContactPostCode"
Type="String" />
<asp

arameter Name="CustBContactCountry"
Type="String" />
<asp

arameter Name="CustBContactTelephone"
Type="String" />
<asp

arameter Name="CustBContactMobile"
Type="String" />
<asp

arameter Name="CustBContactEMail"
Type="String" />
<asp

arameter Name="CustBContactFax"
Type="String" />
<asp

arameter
Name="original_CustBContactStreet1" Type="String" />
<asp

arameter
Name="original_CustBContactStreet2" Type="String" />
<asp

arameter
Name="original_CustBContactStreet3" Type="String" />
<asp

arameter Name="original_CustBContactTown"
Type="String" />
<asp

arameter
Name="original_CustBContactCounty" Type="String" />
<asp

arameter
Name="original_CustBContactPostCode" Type="String" />
<asp

arameter
Name="original_CustBContactCountry" Type="String" />
<asp

arameter
Name="original_CustBContactTelephone" Type="String" />
<asp

arameter
Name="original_CustBContactMobile" Type="String" />
<asp

arameter
Name="original_CustBContactEMail" Type="String" />
<asp

arameter Name="original_CustBContactFax"
Type="String" />
</UpdateParameters>
<SelectParameters>
<asp:ControlParameter
ControlID="CustNameSelect" Name="CustID" PropertyName="SelectedValue"
/>
</SelectParameters>
</asp:SqlDataSource>
</td>
</tr>
<tr><td>
<asp

etailsView ID="DetailsView1" runat="server"
AutoGenerateRows="False" DataSourceID="SqlDataSource2"
Height="50px" Width="125px" DataKeyNames="CustID">
<Fields>
<asp:BoundField DataField="CustID"
HeaderText="CustID" ReadOnly="True" SortExpression="CustID" />
<asp:BoundField DataField="CustDisplayName"
HeaderText="CustDisplayName" SortExpression="CustDisplayName" />
<asp:BoundField DataField="CustFirstName"
HeaderText="CustFirstName" SortExpression="CustFirstName" />
<asp:BoundField DataField="CustSurname"
HeaderText="CustSurname" SortExpression="CustSurname" />
<asp:BoundField DataField="CustType"
HeaderText="CustType" SortExpression="CustType" />
<asp:BoundField DataField="CustNotes"
HeaderText="CustNotes" SortExpression="CustNotes" />
<asp:CheckBoxField DataField="CustIsBillingSame"
HeaderText="CustIsBillingSame" SortExpression="CustIsBillingSame" />
<asp:BoundField DataField="CustNumEmployees"
HeaderText="CustNumEmployees" SortExpression="CustNumEmployees" />
<asp:CheckBoxField DataField="CustIsProspect"
HeaderText="CustIsProspect" SortExpression="CustIsProspect" />
<asp:CheckBoxField DataField="CustOnHold"
HeaderText="CustOnHold" SortExpression="CustOnHold" />
<asp:BoundField DataField="CustPersonID"
HeaderText="CustPersonID" SortExpression="CustPersonID" />
<asp:BoundField DataField="CustUserFieldB1"
HeaderText="CustUserFieldB1" SortExpression="CustUserFieldB1" />
<asp:BoundField DataField="CustUserFieldB2"
HeaderText="CustUserFieldB2" SortExpression="CustUserFieldB2" />
<asp:BoundField DataField="CustUserFieldB3"
HeaderText="CustUserFieldB3" SortExpression="CustUserFieldB3" />
<asp:BoundField DataField="CustUserFieldD1"
HeaderText="CustUserFieldD1" SortExpression="CustUserFieldD1" />
<asp:BoundField DataField="CustUserFieldD2"
HeaderText="CustUserFieldD2" SortExpression="CustUserFieldD2" />
<asp:BoundField DataField="CustUserFieldD3"
HeaderText="CustUserFieldD3" SortExpression="CustUserFieldD3" />
<asp:BoundField DataField="CustUserFieldI1"
HeaderText="CustUserFieldI1" SortExpression="CustUserFieldI1" />
<asp:BoundField DataField="CustUserFieldI2"
HeaderText="CustUserFieldI2" SortExpression="CustUserFieldI2" />
<asp:BoundField DataField="CustUserFieldI3"
HeaderText="CustUserFieldI3" SortExpression="CustUserFieldI3" />
<asp:BoundField DataField="CustCategory"
HeaderText="CustCategory" SortExpression="CustCategory" />
<asp:CheckBoxField DataField="CustInactive"
HeaderText="CustInactive" SortExpression="CustInactive" />
<asp:BoundField DataField="CustContactStreet1"
HeaderText="CustContactStreet1" SortExpression="CustContactStreet1" />
<asp:BoundField DataField="CustContactStreet2"
HeaderText="CustContactStreet2" SortExpression="CustContactStreet2" />
<asp:BoundField DataField="CustContactStreet3"
HeaderText="CustContactStreet3" SortExpression="CustContactStreet3" />
<asp:BoundField DataField="CustContactTown"
HeaderText="CustContactTown" SortExpression="CustContactTown" />
<asp:BoundField DataField="CustContactCounty"
HeaderText="CustContactCounty" SortExpression="CustContactCounty" />
<asp:BoundField DataField="CustContactPostCode"
HeaderText="CustContactPostCode"
SortExpression="CustContactPostCode" />
<asp:BoundField DataField="CustContactCountry"
HeaderText="CustContactCountry" SortExpression="CustContactCountry" />
<asp:BoundField DataField="CustContactTelephone"
HeaderText="CustContactTelephone"
SortExpression="CustContactTelephone" />
<asp:BoundField DataField="CustContactMobile"
HeaderText="CustContactMobile" SortExpression="CustContactMobile" />
<asp:BoundField DataField="CustContactEMail"
HeaderText="CustContactEMail" SortExpression="CustContactEMail" />
<asp:BoundField DataField="CustContactFax"
HeaderText="CustContactFax" SortExpression="CustContactFax" />
<asp:BoundField DataField="CustBContactStreet1"
HeaderText="CustBContactStreet1"
SortExpression="CustBContactStreet1" />
<asp:BoundField DataField="CustBContactStreet2"
HeaderText="CustBContactStreet2"
SortExpression="CustBContactStreet2" />
<asp:BoundField DataField="CustBContactStreet3"
HeaderText="CustBContactStreet3"
SortExpression="CustBContactStreet3" />
<asp:BoundField DataField="CustBContactTown"
HeaderText="CustBContactTown" SortExpression="CustBContactTown" />
<asp:BoundField DataField="CustBContactCounty"
HeaderText="CustBContactCounty" SortExpression="CustBContactCounty" />
<asp:BoundField DataField="CustBContactPostCode"
HeaderText="CustBContactPostCode"
SortExpression="CustBContactPostCode" />
<asp:BoundField DataField="CustBContactCountry"
HeaderText="CustBContactCountry"
SortExpression="CustBContactCountry" />
<asp:BoundField DataField="CustBContactTelephone"
HeaderText="CustBContactTelephone"
SortExpression="CustBContactTelephone" />
<asp:BoundField DataField="CustBContactMobile"
HeaderText="CustBContactMobile" SortExpression="CustBContactMobile" />
<asp:BoundField DataField="CustBContactEMail"
HeaderText="CustBContactEMail" SortExpression="CustBContactEMail" />
<asp:BoundField DataField="CustBContactFax"
HeaderText="CustBContactFax" SortExpression="CustBContactFax" />
<asp:CommandField ShowEditButton="True" />
</Fields>
</asp

etailsView>

W.G. Ryan - MVP · Jan 30, 2006

When you say it isn't working, is it throwing an exception or is it just not
updating. From the looks of the Update query if I'm reading it correctly,
there's no where clause to specify which row you're going to update. Is that
intentional?

Hi,

I'm using a detailsview control with an SqlDataSource control. My
Update query isn't working, and I've narrowed it down to the optimistic
concurrency parameters - i.e. when I comment them out of the query, it
works. What seems to be happening is that if a field is NULL when it
is read in through the select statement, it's causing the update
statment not to find a match. I've got ConvertEmptyStringToNull not
set (so it should default to true), but I can't get the update to work
all the time and it's driving me crazy.

Here's my code:

Stored Procedure for Select as follows (the Update's going in a Stored
Procedure when I can get it to work...):
SELECT Customers.CustID, Customers.CustDisplayName,
Customers.CustFirstName, Customers.CustSurname, Customers.CustType,
Customers.CustNotes, Customers.CustIsBillingSame,
Customers.CustNumEmployees, Customers.CustIsProspect,
Customers.CustOnHold, Customers.CustPersonID,
Customers.CustUserFieldB1, Customers.CustUserFieldB2,
Customers.CustUserFieldB3, Customers.CustUserFieldD1,
Customers.CustUserFieldD2, Customers.CustUserFieldD3,
Customers.CustUserFieldI1, Customers.CustUserFieldI2,
Customers.CustUserFieldI3, Customers.CustCategory,
Customers.CustInactive, CustomerContactDetails_1.CustContactStreet1,
CustomerContactDetails_1.CustContactStreet2,
CustomerContactDetails_1.CustContactStreet3,
CustomerContactDetails_1.CustContactTown,
CustomerContactDetails_1.CustContactCounty,
CustomerContactDetails_1.CustContactPostCode,
CustomerContactDetails_1.CustContactCountry,
CustomerContactDetails_1.CustContactTelephone,
CustomerContactDetails_1.CustContactMobile,
CustomerContactDetails_1.CustContactEMail,
CustomerContactDetails_1.CustContactFax,
CustomerContactDetails.CustContactStreet1 AS CustBContactStreet1,
CustomerContactDetails.CustContactStreet2 AS CustBContactStreet2,
CustomerContactDetails.CustContactStreet3 AS CustBContactStreet3,
CustomerContactDetails.CustContactTown AS CustBContactTown,
CustomerContactDetails.CustContactCounty AS CustBContactCounty,
CustomerContactDetails.CustContactPostCode AS CustBContactPostCode,
CustomerContactDetails.CustContactCountry AS CustBContactCountry,
CustomerContactDetails.CustContactTelephone AS CustBContactTelephone,
CustomerContactDetails.CustContactMobile AS CustBContactMobile,
CustomerContactDetails.CustContactEMail AS CustBContactEMail,
CustomerContactDetails.CustContactFax AS CustBContactFax FROM Customers
LEFT OUTER JOIN CustomerContactDetails AS CustomerContactDetails_1 ON
Customers.CustAddressID = CustomerContactDetails_1.CustContactID LEFT
OUTER JOIN CustomerContactDetails ON Customers.CustBillingID =
CustomerContactDetails.CustContactID WHERE (Customers.CustID = @CustID)

<asp:SqlDataSource ID="SqlDataSource2" runat="server"
ConflictDetection="CompareAllValues"
ConnectionString="<%$
ConnectionStrings:FocusSystemsConnectionString %>"
OldValuesParameterFormatString="original_{0}"
ProviderName="<%$
ConnectionStrings:FocusSystemsConnectionString.ProviderName %>"
SelectCommand="SelectCustomersAndAddresses"
SelectCommandType="StoredProcedure"
UpdateCommand="UPDATE [Customers] SET
[CustDisplayName] = @CustDisplayName, [CustFirstName] = @CustFirstName,
[CustSurname] = @CustSurname, [CustType] = @CustType, [CustNotes] =
@CustNotes, [CustIsBillingSame] = @CustIsBillingSame,
[CustNumEmployees] = @CustNumEmployees, [CustIsProspect] =
@CustIsProspect, [CustOnHold] = @CustOnHold, [CustPersonID] =
@CustPersonID, [CustUserFieldB1] = @CustUserFieldB1, [CustUserFieldB2]
= @CustUserFieldB2, [CustUserFieldB3] = @CustUserFieldB3,
[CustUserFieldD1] = @CustUserFieldD1, [CustUserFieldD2] =
@CustUserFieldD2, [CustUserFieldD3] = @CustUserFieldD3,
[CustUserFieldI1] = @CustUserFieldI1, [CustUserFieldI2] =
@CustUserFieldI2, [CustUserFieldI3] = @CustUserFieldI3, [CustCategory]
= @CustCategory, [CustInactive] = @CustInactive WHERE [CustID] =
@original_CustID AND [CustDisplayName] = @original_CustDisplayName AND
[CustFirstName] = @original_CustFirstName AND [CustSurname] =
@original_CustSurname AND [CustType] = @original_CustType AND
[CustIsBillingSame] = @original_CustIsBillingSame AND
[CustNumEmployees] = @original_CustNumEmployees AND [CustIsProspect] =
@original_CustIsProspect AND [CustOnHold] = @original_CustOnHold AND
[CustPersonID] = @original_CustPersonID AND [CustCategory] =
@original_CustCategory AND [CustInactive] = @original_CustInactive"
EnableViewState="true">
<UpdateParameters>
<asparameter Name="CustDisplayName"
Type="String" />
<asparameter Name="CustFirstName"
Type="String" />
<asparameter Name="CustSurname" Type="String"
/>
<asparameter Name="CustType" Type="String" />
<asparameter Name="CustNotes" Type="String"
/>
<asparameter Name="CustIsBillingSame"
Type="Boolean" />
<asparameter Name="CustNumEmployees"
Type="Int32" />
<asparameter Name="CustIsProspect"
Type="Boolean" />
<asparameter Name="CustOnHold" Type="Boolean"
/>
<asparameter Name="CustPersonID" />
<asparameter Name="CustUserFieldB1"
Type="String" />
<asparameter Name="CustUserFieldB2"
Type="String" />
<asparameter Name="CustUserFieldB3"
Type="String" />
<asparameter Name="CustUserFieldD1"
Type="String" />
<asparameter Name="CustUserFieldD2"
Type="String" />
<asparameter Name="CustUserFieldD3"
Type="String" />
<asparameter Name="CustUserFieldI1"
Type="String" />
<asparameter Name="CustUserFieldI2"
Type="String" />
<asparameter Name="CustUserFieldI3"
Type="String" />
<asparameter Name="CustCategory"
Type="String" />
<asparameter Name="CustInactive"
Type="Boolean" />
<asparameter Name="original_CustID" />
<asparameter Name="original_CustDisplayName"
/>
<asparameter Name="original_CustFirstName" />
<asparameter Name="original_CustSurname" />
<asparameter Name="original_CustType" />
<asparameter Name="original_CustNotes" />
<asparameter
Name="original_CustIsBillingSame" />
<asparameter Name="original_CustNumEmployees"
/>
<asparameter Name="original_CustIsProspect"
/>
<asparameter Name="original_CustOnHold" />
<asparameter Name="original_CustPersonID" />
<asparameter Name="original_CustUserFieldB1"
/>
<asparameter Name="original_CustUserFieldB2"
/>
<asparameter Name="original_CustUserFieldB3"
/>
<asparameter Name="original_CustUserFieldD1"
/>
<asparameter Name="original_CustUserFieldD2"
/>
<asparameter Name="original_CustUserFieldD3"
/>
<asparameter Name="original_CustUserFieldI1"
/>
<asparameter Name="original_CustUserFieldI2"
/>
<asparameter Name="original_CustUserFieldI3"
/>
<asparameter Name="original_CustCategory" />
<asparameter Name="original_CustInactive" />
<asparameter Name="CustContactStreet1"
Type="String" />
<asparameter Name="CustContactStreet2"
Type="String" />
<asparameter Name="CustContactStreet3"
Type="String" />
<asparameter Name="CustContactTown"
Type="String" />
<asparameter Name="CustContactCounty"
Type="String" />
<asparameter Name="CustContactPostCode"
Type="String" />
<asparameter Name="CustContactCountry"
Type="String" />
<asparameter Name="CustContactTelephone"
Type="String" />
<asparameter Name="CustContactMobile"
Type="String" />
<asparameter Name="CustContactEMail"
Type="String" />
<asparameter Name="CustContactFax"
Type="String" />
<asparameter
Name="original_CustContactStreet1" Type="String" />
<asparameter
Name="original_CustContactStreet2" Type="String" />
<asparameter
Name="original_CustContactStreet3" Type="String" />
<asparameter Name="original_CustContactTown"
Type="String" />
<asparameter
Name="original_CustContactCounty" Type="String" />
<asparameter
Name="original_CustContactPostCode" Type="String" />
<asparameter
Name="original_CustContactCountry" Type="String" />
<asparameter
Name="original_CustContactTelephone" Type="String" />
<asparameter
Name="original_CustContactMobile" Type="String" />
<asparameter Name="original_CustContactEMail"
Type="String" />
<asparameter Name="original_CustContactFax"
Type="String" />
<asparameter Name="CustBContactStreet1"
Type="String" />
<asparameter Name="CustBContactStreet2"
Type="String" />
<asparameter Name="CustBContactStreet3"
Type="String" />
<asparameter Name="CustBContactTown"
Type="String" />
<asparameter Name="CustBContactCounty"
Type="String" />
<asparameter Name="CustBContactPostCode"
Type="String" />
<asparameter Name="CustBContactCountry"
Type="String" />
<asparameter Name="CustBContactTelephone"
Type="String" />
<asparameter Name="CustBContactMobile"
Type="String" />
<asparameter Name="CustBContactEMail"
Type="String" />
<asparameter Name="CustBContactFax"
Type="String" />
<asparameter
Name="original_CustBContactStreet1" Type="String" />
<asparameter
Name="original_CustBContactStreet2" Type="String" />
<asparameter
Name="original_CustBContactStreet3" Type="String" />
<asparameter Name="original_CustBContactTown"
Type="String" />
<asparameter
Name="original_CustBContactCounty" Type="String" />
<asparameter
Name="original_CustBContactPostCode" Type="String" />
<asparameter
Name="original_CustBContactCountry" Type="String" />
<asparameter
Name="original_CustBContactTelephone" Type="String" />
<asparameter
Name="original_CustBContactMobile" Type="String" />
<asparameter
Name="original_CustBContactEMail" Type="String" />
<asparameter Name="original_CustBContactFax"
Type="String" />
</UpdateParameters>
<SelectParameters>
<asp:ControlParameter
ControlID="CustNameSelect" Name="CustID" PropertyName="SelectedValue"
/>
</SelectParameters>
</asp:SqlDataSource>
</td>
</tr>
<tr><td>
<aspetailsView ID="DetailsView1" runat="server"
AutoGenerateRows="False" DataSourceID="SqlDataSource2"
Height="50px" Width="125px" DataKeyNames="CustID">
<Fields>
<asp:BoundField DataField="CustID"
HeaderText="CustID" ReadOnly="True" SortExpression="CustID" />
<asp:BoundField DataField="CustDisplayName"
HeaderText="CustDisplayName" SortExpression="CustDisplayName" />
<asp:BoundField DataField="CustFirstName"
HeaderText="CustFirstName" SortExpression="CustFirstName" />
<asp:BoundField DataField="CustSurname"
HeaderText="CustSurname" SortExpression="CustSurname" />
<asp:BoundField DataField="CustType"
HeaderText="CustType" SortExpression="CustType" />
<asp:BoundField DataField="CustNotes"
HeaderText="CustNotes" SortExpression="CustNotes" />
<asp:CheckBoxField DataField="CustIsBillingSame"
HeaderText="CustIsBillingSame" SortExpression="CustIsBillingSame" />
<asp:BoundField DataField="CustNumEmployees"
HeaderText="CustNumEmployees" SortExpression="CustNumEmployees" />
<asp:CheckBoxField DataField="CustIsProspect"
HeaderText="CustIsProspect" SortExpression="CustIsProspect" />
<asp:CheckBoxField DataField="CustOnHold"
HeaderText="CustOnHold" SortExpression="CustOnHold" />
<asp:BoundField DataField="CustPersonID"
HeaderText="CustPersonID" SortExpression="CustPersonID" />
<asp:BoundField DataField="CustUserFieldB1"
HeaderText="CustUserFieldB1" SortExpression="CustUserFieldB1" />
<asp:BoundField DataField="CustUserFieldB2"
HeaderText="CustUserFieldB2" SortExpression="CustUserFieldB2" />
<asp:BoundField DataField="CustUserFieldB3"
HeaderText="CustUserFieldB3" SortExpression="CustUserFieldB3" />
<asp:BoundField DataField="CustUserFieldD1"
HeaderText="CustUserFieldD1" SortExpression="CustUserFieldD1" />
<asp:BoundField DataField="CustUserFieldD2"
HeaderText="CustUserFieldD2" SortExpression="CustUserFieldD2" />
<asp:BoundField DataField="CustUserFieldD3"
HeaderText="CustUserFieldD3" SortExpression="CustUserFieldD3" />
<asp:BoundField DataField="CustUserFieldI1"
HeaderText="CustUserFieldI1" SortExpression="CustUserFieldI1" />
<asp:BoundField DataField="CustUserFieldI2"
HeaderText="CustUserFieldI2" SortExpression="CustUserFieldI2" />
<asp:BoundField DataField="CustUserFieldI3"
HeaderText="CustUserFieldI3" SortExpression="CustUserFieldI3" />
<asp:BoundField DataField="CustCategory"
HeaderText="CustCategory" SortExpression="CustCategory" />
<asp:CheckBoxField DataField="CustInactive"
HeaderText="CustInactive" SortExpression="CustInactive" />
<asp:BoundField DataField="CustContactStreet1"
HeaderText="CustContactStreet1" SortExpression="CustContactStreet1" />
<asp:BoundField DataField="CustContactStreet2"
HeaderText="CustContactStreet2" SortExpression="CustContactStreet2" />
<asp:BoundField DataField="CustContactStreet3"
HeaderText="CustContactStreet3" SortExpression="CustContactStreet3" />
<asp:BoundField DataField="CustContactTown"
HeaderText="CustContactTown" SortExpression="CustContactTown" />
<asp:BoundField DataField="CustContactCounty"
HeaderText="CustContactCounty" SortExpression="CustContactCounty" />
<asp:BoundField DataField="CustContactPostCode"
HeaderText="CustContactPostCode"
SortExpression="CustContactPostCode" />
<asp:BoundField DataField="CustContactCountry"
HeaderText="CustContactCountry" SortExpression="CustContactCountry" />
<asp:BoundField DataField="CustContactTelephone"
HeaderText="CustContactTelephone"
SortExpression="CustContactTelephone" />
<asp:BoundField DataField="CustContactMobile"
HeaderText="CustContactMobile" SortExpression="CustContactMobile" />
<asp:BoundField DataField="CustContactEMail"
HeaderText="CustContactEMail" SortExpression="CustContactEMail" />
<asp:BoundField DataField="CustContactFax"
HeaderText="CustContactFax" SortExpression="CustContactFax" />
<asp:BoundField DataField="CustBContactStreet1"
HeaderText="CustBContactStreet1"
SortExpression="CustBContactStreet1" />
<asp:BoundField DataField="CustBContactStreet2"
HeaderText="CustBContactStreet2"
SortExpression="CustBContactStreet2" />
<asp:BoundField DataField="CustBContactStreet3"
HeaderText="CustBContactStreet3"
SortExpression="CustBContactStreet3" />
<asp:BoundField DataField="CustBContactTown"
HeaderText="CustBContactTown" SortExpression="CustBContactTown" />
<asp:BoundField DataField="CustBContactCounty"
HeaderText="CustBContactCounty" SortExpression="CustBContactCounty" />
<asp:BoundField DataField="CustBContactPostCode"
HeaderText="CustBContactPostCode"
SortExpression="CustBContactPostCode" />
<asp:BoundField DataField="CustBContactCountry"
HeaderText="CustBContactCountry"
SortExpression="CustBContactCountry" />
<asp:BoundField DataField="CustBContactTelephone"
HeaderText="CustBContactTelephone"
SortExpression="CustBContactTelephone" />
<asp:BoundField DataField="CustBContactMobile"
HeaderText="CustBContactMobile" SortExpression="CustBContactMobile" />
<asp:BoundField DataField="CustBContactEMail"
HeaderText="CustBContactEMail" SortExpression="CustBContactEMail" />
<asp:BoundField DataField="CustBContactFax"
HeaderText="CustBContactFax" SortExpression="CustBContactFax" />
<asp:CommandField ShowEditButton="True" />
</Fields>
</aspetailsView>

Otis Mukinfus · Jan 31, 2006

When you say it isn't working, is it throwing an exception or is it just not
updating. From the looks of the Update query if I'm reading it correctly,
there's no where clause to specify which row you're going to update. Is that
intentional?

It's there but almost hidden in the formatting ;o) See below.

Here is the update command, and ....

UpdateCommand="UPDATE [Customers] SET
[CustDisplayName] = @CustDisplayName, [CustFirstName] = @CustFirstName,
[CustSurname] = @CustSurname, [CustType] = @CustType, [CustNotes] =
@CustNotes, [CustIsBillingSame] = @CustIsBillingSame,
[CustNumEmployees] = @CustNumEmployees, [CustIsProspect] =
@CustIsProspect, [CustOnHold] = @CustOnHold, [CustPersonID] =
@CustPersonID, [CustUserFieldB1] = @CustUserFieldB1, [CustUserFieldB2]
= @CustUserFieldB2, [CustUserFieldB3] = @CustUserFieldB3,
[CustUserFieldD1] = @CustUserFieldD1, [CustUserFieldD2] =
@CustUserFieldD2, [CustUserFieldD3] = @CustUserFieldD3,
[CustUserFieldI1] = @CustUserFieldI1, [CustUserFieldI2] =
@CustUserFieldI2, [CustUserFieldI3] = @CustUserFieldI3, [CustCategory]

Click to expand...

Here is the where clause...

= @CustCategory, [CustInactive] = @CustInactive WHERE [CustID] =
@original_CustID AND [CustDisplayName] = @original_CustDisplayName AND
[CustFirstName] = @original_CustFirstName AND [CustSurname] =
@original_CustSurname AND [CustType] = @original_CustType AND
[CustIsBillingSame] = @original_CustIsBillingSame AND
[CustNumEmployees] = @original_CustNumEmployees AND [CustIsProspect] =
@original_CustIsProspect AND [CustOnHold] = @original_CustOnHold AND
[CustPersonID] = @original_CustPersonID AND [CustCategory] =
@original_CustCategory AND [CustInactive] = @original_CustInactive"
EnableViewState="true">
<UpdateParameters>
<asparameter Name="CustDisplayName"
Type="String" />
<asparameter Name="CustFirstName"
Type="String" />
<asparameter Name="CustSurname" Type="String"
/>
<asparameter Name="CustType" Type="String" />
<asparameter Name="CustNotes" Type="String"
/>
<asparameter Name="CustIsBillingSame"
Type="Boolean" />
<asparameter Name="CustNumEmployees"
Type="Int32" />
<asparameter Name="CustIsProspect"
Type="Boolean" />
<asparameter Name="CustOnHold" Type="Boolean"
/>
<asparameter Name="CustPersonID" />
<asparameter Name="CustUserFieldB1"
Type="String" />
<asparameter Name="CustUserFieldB2"
Type="String" />
<asparameter Name="CustUserFieldB3"
Type="String" />
<asparameter Name="CustUserFieldD1"
Type="String" />
<asparameter Name="CustUserFieldD2"
Type="String" />
<asparameter Name="CustUserFieldD3"
Type="String" />
<asparameter Name="CustUserFieldI1"
Type="String" />
<asparameter Name="CustUserFieldI2"
Type="String" />
<asparameter Name="CustUserFieldI3"
Type="String" />
<asparameter Name="CustCategory"
Type="String" />
<asparameter Name="CustInactive"
Type="Boolean" />
<asparameter Name="original_CustID" />
<asparameter Name="original_CustDisplayName"
/>
<asparameter Name="original_CustFirstName" />
<asparameter Name="original_CustSurname" />
<asparameter Name="original_CustType" />
<asparameter Name="original_CustNotes" />
<asparameter
Name="original_CustIsBillingSame" />
<asparameter Name="original_CustNumEmployees"
/>
<asparameter Name="original_CustIsProspect"
/>
<asparameter Name="original_CustOnHold" />
<asparameter Name="original_CustPersonID" />
<asparameter Name="original_CustUserFieldB1"
/>
<asparameter Name="original_CustUserFieldB2"
/>
<asparameter Name="original_CustUserFieldB3"
/>
<asparameter Name="original_CustUserFieldD1"
/>
<asparameter Name="original_CustUserFieldD2"
/>
<asparameter Name="original_CustUserFieldD3"
/>
<asparameter Name="original_CustUserFieldI1"
/>
<asparameter Name="original_CustUserFieldI2"
/>
<asparameter Name="original_CustUserFieldI3"
/>
<asparameter Name="original_CustCategory" />
<asparameter Name="original_CustInactive" />
<asparameter Name="CustContactStreet1"
Type="String" />
<asparameter Name="CustContactStreet2"
Type="String" />
<asparameter Name="CustContactStreet3"
Type="String" />
<asparameter Name="CustContactTown"
Type="String" />
<asparameter Name="CustContactCounty"
Type="String" />
<asparameter Name="CustContactPostCode"
Type="String" />
<asparameter Name="CustContactCountry"
Type="String" />
<asparameter Name="CustContactTelephone"
Type="String" />
<asparameter Name="CustContactMobile"
Type="String" />
<asparameter Name="CustContactEMail"
Type="String" />
<asparameter Name="CustContactFax"
Type="String" />
<asparameter
Name="original_CustContactStreet1" Type="String" />
<asparameter
Name="original_CustContactStreet2" Type="String" />
<asparameter
Name="original_CustContactStreet3" Type="String" />
<asparameter Name="original_CustContactTown"
Type="String" />
<asparameter
Name="original_CustContactCounty" Type="String" />
<asparameter
Name="original_CustContactPostCode" Type="String" />
<asparameter
Name="original_CustContactCountry" Type="String" />
<asparameter
Name="original_CustContactTelephone" Type="String" />
<asparameter
Name="original_CustContactMobile" Type="String" />
<asparameter Name="original_CustContactEMail"
Type="String" />
<asparameter Name="original_CustContactFax"
Type="String" />
<asparameter Name="CustBContactStreet1"
Type="String" />
<asparameter Name="CustBContactStreet2"
Type="String" />
<asparameter Name="CustBContactStreet3"
Type="String" />
<asparameter Name="CustBContactTown"
Type="String" />
<asparameter Name="CustBContactCounty"
Type="String" />
<asparameter Name="CustBContactPostCode"
Type="String" />
<asparameter Name="CustBContactCountry"
Type="String" />
<asparameter Name="CustBContactTelephone"
Type="String" />
<asparameter Name="CustBContactMobile"
Type="String" />
<asparameter Name="CustBContactEMail"
Type="String" />
<asparameter Name="CustBContactFax"
Type="String" />
<asparameter
Name="original_CustBContactStreet1" Type="String" />
<asparameter
Name="original_CustBContactStreet2" Type="String" />
<asparameter
Name="original_CustBContactStreet3" Type="String" />
<asparameter Name="original_CustBContactTown"
Type="String" />
<asparameter
Name="original_CustBContactCounty" Type="String" />
<asparameter
Name="original_CustBContactPostCode" Type="String" />
<asparameter
Name="original_CustBContactCountry" Type="String" />
<asparameter
Name="original_CustBContactTelephone" Type="String" />
<asparameter
Name="original_CustBContactMobile" Type="String" />
<asparameter
Name="original_CustBContactEMail" Type="String" />
<asparameter Name="original_CustBContactFax"
Type="String" />
</UpdateParameters>
<SelectParameters>
<asp:ControlParameter
ControlID="CustNameSelect" Name="CustID" PropertyName="SelectedValue"
/>
</SelectParameters>
</asp:SqlDataSource>
</td>
</tr>
<tr><td>
<aspetailsView ID="DetailsView1" runat="server"
AutoGenerateRows="False" DataSourceID="SqlDataSource2"
Height="50px" Width="125px" DataKeyNames="CustID">
<Fields>
<asp:BoundField DataField="CustID"
HeaderText="CustID" ReadOnly="True" SortExpression="CustID" />
<asp:BoundField DataField="CustDisplayName"
HeaderText="CustDisplayName" SortExpression="CustDisplayName" />
<asp:BoundField DataField="CustFirstName"
HeaderText="CustFirstName" SortExpression="CustFirstName" />
<asp:BoundField DataField="CustSurname"
HeaderText="CustSurname" SortExpression="CustSurname" />
<asp:BoundField DataField="CustType"
HeaderText="CustType" SortExpression="CustType" />
<asp:BoundField DataField="CustNotes"
HeaderText="CustNotes" SortExpression="CustNotes" />
<asp:CheckBoxField DataField="CustIsBillingSame"
HeaderText="CustIsBillingSame" SortExpression="CustIsBillingSame" />
<asp:BoundField DataField="CustNumEmployees"
HeaderText="CustNumEmployees" SortExpression="CustNumEmployees" />
<asp:CheckBoxField DataField="CustIsProspect"
HeaderText="CustIsProspect" SortExpression="CustIsProspect" />
<asp:CheckBoxField DataField="CustOnHold"
HeaderText="CustOnHold" SortExpression="CustOnHold" />
<asp:BoundField DataField="CustPersonID"
HeaderText="CustPersonID" SortExpression="CustPersonID" />
<asp:BoundField DataField="CustUserFieldB1"
HeaderText="CustUserFieldB1" SortExpression="CustUserFieldB1" />
<asp:BoundField DataField="CustUserFieldB2"
HeaderText="CustUserFieldB2" SortExpression="CustUserFieldB2" />
<asp:BoundField DataField="CustUserFieldB3"
HeaderText="CustUserFieldB3" SortExpression="CustUserFieldB3" />
<asp:BoundField DataField="CustUserFieldD1"
HeaderText="CustUserFieldD1" SortExpression="CustUserFieldD1" />
<asp:BoundField DataField="CustUserFieldD2"
HeaderText="CustUserFieldD2" SortExpression="CustUserFieldD2" />
<asp:BoundField DataField="CustUserFieldD3"
HeaderText="CustUserFieldD3" SortExpression="CustUserFieldD3" />
<asp:BoundField DataField="CustUserFieldI1"
HeaderText="CustUserFieldI1" SortExpression="CustUserFieldI1" />
<asp:BoundField DataField="CustUserFieldI2"
HeaderText="CustUserFieldI2" SortExpression="CustUserFieldI2" />
<asp:BoundField DataField="CustUserFieldI3"
HeaderText="CustUserFieldI3" SortExpression="CustUserFieldI3" />
<asp:BoundField DataField="CustCategory"
HeaderText="CustCategory" SortExpression="CustCategory" />
<asp:CheckBoxField DataField="CustInactive"
HeaderText="CustInactive" SortExpression="CustInactive" />
<asp:BoundField DataField="CustContactStreet1"
HeaderText="CustContactStreet1" SortExpression="CustContactStreet1" />
<asp:BoundField DataField="CustContactStreet2"
HeaderText="CustContactStreet2" SortExpression="CustContactStreet2" />
<asp:BoundField DataField="CustContactStreet3"
HeaderText="CustContactStreet3" SortExpression="CustContactStreet3" />
<asp:BoundField DataField="CustContactTown"
HeaderText="CustContactTown" SortExpression="CustContactTown" />
<asp:BoundField DataField="CustContactCounty"
HeaderText="CustContactCounty" SortExpression="CustContactCounty" />
<asp:BoundField DataField="CustContactPostCode"
HeaderText="CustContactPostCode"
SortExpression="CustContactPostCode" />
<asp:BoundField DataField="CustContactCountry"
HeaderText="CustContactCountry" SortExpression="CustContactCountry" />
<asp:BoundField DataField="CustContactTelephone"
HeaderText="CustContactTelephone"
SortExpression="CustContactTelephone" />
<asp:BoundField DataField="CustContactMobile"
HeaderText="CustContactMobile" SortExpression="CustContactMobile" />
<asp:BoundField DataField="CustContactEMail"
HeaderText="CustContactEMail" SortExpression="CustContactEMail" />
<asp:BoundField DataField="CustContactFax"
HeaderText="CustContactFax" SortExpression="CustContactFax" />
<asp:BoundField DataField="CustBContactStreet1"
HeaderText="CustBContactStreet1"
SortExpression="CustBContactStreet1" />
<asp:BoundField DataField="CustBContactStreet2"
HeaderText="CustBContactStreet2"
SortExpression="CustBContactStreet2" />
<asp:BoundField DataField="CustBContactStreet3"
HeaderText="CustBContactStreet3"
SortExpression="CustBContactStreet3" />
<asp:BoundField DataField="CustBContactTown"
HeaderText="CustBContactTown" SortExpression="CustBContactTown" />
<asp:BoundField DataField="CustBContactCounty"
HeaderText="CustBContactCounty" SortExpression="CustBContactCounty" />
<asp:BoundField DataField="CustBContactPostCode"
HeaderText="CustBContactPostCode"
SortExpression="CustBContactPostCode" />
<asp:BoundField DataField="CustBContactCountry"
HeaderText="CustBContactCountry"
SortExpression="CustBContactCountry" />
<asp:BoundField DataField="CustBContactTelephone"
HeaderText="CustBContactTelephone"
SortExpression="CustBContactTelephone" />
<asp:BoundField DataField="CustBContactMobile"
HeaderText="CustBContactMobile" SortExpression="CustBContactMobile" />
<asp:BoundField DataField="CustBContactEMail"
HeaderText="CustBContactEMail" SortExpression="CustBContactEMail" />
<asp:BoundField DataField="CustBContactFax"
HeaderText="CustBContactFax" SortExpression="CustBContactFax" />
<asp:CommandField ShowEditButton="True" />
</Fields>
</aspetailsView>

Click to expand...

Otis Mukinfus
http://www.otismukinfus.com
http://www.tomchilders.com

stuart.d.jones · Jan 31, 2006

It's just not updating. I'm going to try a timestamp concurrency
approach instead (came to me at 4AM this morning), unless anyone can
better advise!

Thanks,

Stuart

SqlDataSource and Optimistic Concurrency Problems

stuart.d.jones

W.G. Ryan - MVP

Otis Mukinfus

stuart.d.jones