lizareay

Hi,

Don't worry.

You have to gover proper order to the update parameters and remove braces from the where clause.

UpdateCommand="Update tbl_MaintenanceSubTemp SET Quantity=@Quantity, MaintenanceTermsID=@MaintenanceTermsID, Total=@Total where (MaintenanceSubTempID=@MaintenanceSubTempID)"
Change this to :
                    UpdateCommand="Update tbl_MaintenanceSubTemp SET Quantity=@Quantity, MaintenanceTermsID=@MaintenanceTermsID, Total=@Total where MaintenanceSubTempID=@MaintenanceSubTempID"

<UpdateParameters>

                        <asp:Parameter Name="Quantity" />
                        <asp:Parameter Name="MaintenanceTermsID" />
                        <asp:Parameter Name="Total" />
                        <asp:Parameter Name="MaintenanceSubTempID" />
                    </UpdateParameters>

tHis will work for you.

Thank you for your reply,

but still I have the same problem, the DropDownList becomes NULL in the database :(