Hello ... I have a form that is straight forward, with little code behind (code is for a more friendly error msg when attempting insert,update, delete from a detailsview). I have had this problem before and the usual fix of reconfiguring the sqldataAdapter and detailsview does not work. The problem is when I have a row that contains column with a null value it will not update or delete. I can insert the row with a column that contains a null value, but cannot update or delete it. There is no error or exception thrown, the row simply fails to update or delete.

I am curious to know if anyone else is having this problem? If so what did you do to fix it?

Any information is certainly appreciated ... Thanks!

Dave

I think that if you post your code I might be able to help. It's very hard to guess at things without seeing any code.

Neil Timmerman
Programmer
Veris Consulting

Neil,
Thanks for the offer to help. Actually I fixed (circumvented) the problem by not allowing any nulls in all columns. I then checked the columns before updating/inserting and plugged in a value.
Working fine this way ... again thanks for the offer!
Dave

Hi,

I am having the same problem as specified as above, but want to allow null values in certain columns is there anyway of allowing this to happen?

My code is as follows:

<asp:DetailsView ID="DetailsView1" runat="server" AutoGenerateRows="False" DataKeyNames="COMPONENT_ID,C_INTERNAL_VERSION"
        DataSourceID="SqlDataSource3" Height="50px" Width="125px">
        <Fields>
            <asp:BoundField DataField="COMPONENT_ID" HeaderText="COMPONENT_ID" ReadOnly="True"
                SortExpression="COMPONENT_ID" />
            <asp:BoundField DataField="C_INTERNAL_VERSION" HeaderText="C_INTERNAL_VERSION" ReadOnly="True"
                SortExpression="C_INTERNAL_VERSION" />
            <asp:BoundField DataField="C_VERSION" HeaderText="C_VERSION" SortExpression="C_VERSION" />
            <asp:BoundField DataField="C_COMMISSIONED_DATE" HeaderText="C_COMMISSIONED_DATE"
                SortExpression="C_COMMISSIONED_DATE" />
            <asp:BoundField DataField="C_DEOMMISSIONED_DATE" HeaderText="C_DEOMMISSIONED_DATE"
                SortExpression="C_DEOMMISSIONED_DATE" />
            <asp:BoundField DataField="C_DECOMM_REASON" HeaderText="C_DECOMM_REASON" SortExpression="C_DECOMM_REASON" />
            <asp:BoundField DataField="PLAT_ID" HeaderText="PLAT_ID" SortExpression="PLAT_ID" />
            <asp:BoundField DataField="PLAT_IVER" HeaderText="PLAT_IVER" SortExpression="PLAT_IVER" />
            <asp:BoundField DataField="COMPONENT_TYPE_ID" HeaderText="COMPONENT_TYPE_ID" SortExpression="COMPONENT_TYPE_ID" />
            <asp:BoundField DataField="C_NAME" HeaderText="C_NAME" SortExpression="C_NAME" />
            <asp:BoundField DataField="C_DESCRIPTION" HeaderText="C_DESCRIPTION" SortExpression="C_DESCRIPTION" />
            <asp:BoundField DataField="C_AUDIT_INFO" HeaderText="C_AUDIT_INFO" SortExpression="C_AUDIT_INFO" />
            <asp:CommandField ShowEditButton="True" />
        </Fields>
    </asp:DetailsView>
    <asp:SqlDataSource ID="SqlDataSource3" runat="server" ConflictDetection="CompareAllValues"
        ConnectionString="<%$ ConnectionStrings:ConnectionString2 %>" OldValuesParameterFormatString="original_{0}" ProviderName="<%$ ConnectionStrings:ConnectionString2.ProviderName %>"
        SelectCommand='SELECT * FROM "COMPONENT" WHERE (("COMPONENT_ID" = :COMPONENT_ID) AND ("C_INTERNAL_VERSION" = :C_INTERNAL_VERSION))'
        UpdateCommand='UPDATE "COMPONENT" SET "C_VERSION" = :C_VERSION, "C_COMMISSIONED_DATE" = :C_COMMISSIONED_DATE, "C_DEOMMISSIONED_DATE" = :C_DEOMMISSIONED_DATE, "C_DECOMM_REASON" = :C_DECOMM_REASON, "PLAT_ID" = :PLAT_ID, "PLAT_IVER" = :PLAT_IVER, "COMPONENT_TYPE_ID" = :COMPONENT_TYPE_ID, "C_NAME" = :C_NAME, "C_DESCRIPTION" = :C_DESCRIPTION, "C_AUDIT_INFO" = :C_AUDIT_INFO WHERE "COMPONENT_ID" = :original_COMPONENT_ID AND "C_INTERNAL_VERSION" = :original_C_INTERNAL_VERSION AND "C_VERSION" = :original_C_VERSION AND "C_COMMISSIONED_DATE" = :original_C_COMMISSIONED_DATE AND "C_DEOMMISSIONED_DATE" = :original_C_DEOMMISSIONED_DATE AND "C_DECOMM_REASON" = :original_C_DECOMM_REASON AND "PLAT_ID" = :original_PLAT_ID AND "PLAT_IVER" = :original_PLAT_IVER AND "COMPONENT_TYPE_ID" = :original_COMPONENT_TYPE_ID AND "C_NAME" = :original_C_NAME AND "C_DESCRIPTION" = :original_C_DESCRIPTION AND "C_AUDIT_INFO" = :original_C_AUDIT_INFO'>
        <UpdateParameters>
            <asp:Parameter Name="C_VERSION" Type="String" />
            <asp:Parameter Name="C_COMMISSIONED_DATE" Type="DateTime" />
            <asp:Parameter Name="C_DEOMMISSIONED_DATE" Type="DateTime" />
            <asp:Parameter Name="C_DECOMM_REASON" Type="String" />
            <asp:Parameter Name="PLAT_ID" Type="Decimal" />
            <asp:Parameter Name="PLAT_IVER" Type="Decimal" />
            <asp:Parameter Name="COMPONENT_TYPE_ID" Type="Decimal" />
            <asp:Parameter Name="C_NAME" Type="String" />
            <asp:Parameter Name="C_DESCRIPTION" Type="String" />
            <asp:Parameter Name="C_AUDIT_INFO" Type="String" />
            <asp:Parameter Name="original_COMPONENT_ID" Type="Decimal" />
            <asp:Parameter Name="original_C_INTERNAL_VERSION" Type="Decimal" />
            <asp:Parameter Name="original_C_VERSION" Type="String" />
            <asp:Parameter Name="original_C_COMMISSIONED_DATE" Type="DateTime" />
            <asp:Parameter Name="original_C_DEOMMISSIONED_DATE" Type="DateTime" />
            <asp:Parameter Name="original_C_DECOMM_REASON" Type="String" />
            <asp:Parameter Name="original_PLAT_ID" Type="Decimal" />
            <asp:Parameter Name="original_PLAT_IVER" Type="Decimal" />
            <asp:Parameter Name="original_COMPONENT_TYPE_ID" Type="Decimal" />
            <asp:Parameter Name="original_C_NAME" Type="String" />
            <asp:Parameter Name="original_C_DESCRIPTION" Type="String" />
            <asp:Parameter Name="original_C_AUDIT_INFO" Type="String" />
        </UpdateParameters>
        <SelectParameters>
            <asp:ControlParameter ControlID="DropDownList1" DefaultValue="1" Name="COMPONENT_ID"
                PropertyName="SelectedValue" Type="Decimal" />
            <asp:ControlParameter ControlID="DropDownList2" DefaultValue="1" Name="C_INTERNAL_VERSION"
                PropertyName="SelectedValue" Type="Decimal" />
        </SelectParameters>
    </asp:SqlDataSource>