Posted on: 6/19/2014 8:17:50 PM | Views : 333

Hello,

I have this query in my SelectCommand of my SQLDataSource : "SELECT ID, AvancementQuantitatifT1, AvancementQuantitatifT2, AvancementQuantitatifT3, AvancementQuantitatifT4 FROM [reponse] WHERE ID=@ID"
I would like to do "SELECT ID, AvancementQuantitatifT1 * 100, AvancementQuantitatifT2, AvancementQuantitatifT3, AvancementQuantitatifT4 FROM [reponse] WHERE ID=@ID" knowing that the column AvancementQuantitatifT1 is a Decimal type. But this query doesn't work... Do you have a solution ?

This is my complete code :

<asp:Chart ID="Chart1" runat="server" DataSourceID="SqlDataSource1"> <Series> <asp:Series Name="Trimestre 1" YValueMembers="AvancementQuantitatifT1"> </asp:Series> <asp:Series Name="Trimestre 2" YValueMembers="AvancementQuan ...

Go to the complete details ...