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