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>
|