Your browser does not seem to support JavaScript. As a result, your viewing experience will be diminished, and you have been placed in read-only mode.

Please download a browser that supports JavaScript, or enable it if it's disabled (i.e. NoScript).

Display format - Price

2 Posts 2 Posters 0 Views 1 Watching

D Offline
D Offline
DotNet

wrote on last edited by

#1

As I have this, Dim CommandText2 As String = "Select SUM(PeriPrice) FROM Peripheral Where PCID='P0003'" It sums up, and displayed "3399.000" on the datagrid. But I want - 3,399.00. Is there any way to do it? Please help. Thanks.
A 1 Reply Last reply

0
D DotNet

As I have this, Dim CommandText2 As String = "Select SUM(PeriPrice) FROM Peripheral Where PCID='P0003'" It sums up, and displayed "3399.000" on the datagrid. But I want - 3,399.00. Is there any way to do it? Please help. Thanks.
A Offline
A Offline
Anonymous

wrote on last edited by

#2

Select Right(Replicate('',10) + Convert(varchar(11),Convert(Decimal(10,2),SUM(PeriPrice))),11) FROM Peripheral Where PCID='P0003'
1 Reply Last reply

0

Log in to reply