Sign In| Join
Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Member
237 Points
167 Posts
Mar 05, 2012 03:32 AM|LINK
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.
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 :(
dxb lady
Member
237 Points
167 Posts
Re: GridView Update Problem
Mar 05, 2012 03:32 AM|LINK
Thank you for your reply,
but still I have the same problem, the DropDownList becomes NULL in the database :(