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>

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

databinding 'system.data.datarowview' does not contain a propertywith the name	1	Jul 27, 2009
DetailsView not updating	2	Jan 5, 2007
How to update Gridview	0	Jan 30, 2010
Update gridview issue	2	Dec 7, 2008
dropdownlist has a selectedvalue which is invalid because it does not exist in the list of items.	0	Aug 7, 2007
Programmatically set FilterExpression and FilterParameters of SqlDataSource	1	Aug 25, 2005
Inserting from DetailsView and associated Child Records	1	Dec 7, 2007
DetailView	1	Jul 30, 2007

SqlDataSource and Optimistic Concurrency Problems

stuart.d.jones

W.G. Ryan - MVP

stuart.d.jones

Ask a Question

Similar Threads

Members online

Forum statistics

Latest Threads