Posted on: 6/17/2014 12:42:46 PM | Views : 387

Hello,
I have a DetailView and I would like to edit a column but I have a probleme with my UpdateCommand because when I put in the value in the textbox, I get a error " not possible to convert nvarchar to numeric".
My column "AvancementQuantitatifT1" has a Decimal(3,2) type.

My code aspx :

<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:connexionBase %>" SelectCommand="SELECT ID, [AvancementQuantitatifT1] FROM reponse WHERE ID=@ID" UpdateCommand="UPDATE [reponse] SET [AvancementQuantitatifT1]=@AvancementQuantitatifT1 WHERE ID=@ID"> <UpdateParameters> <asp:Parameter Name="AvancementQuantitatifT1" Type="Decimal" /> </UpdateParameters> <SelectParameters> <asp:QuerySt ...

Go to the complete details ...