Formating Decimal Numbers to two or more decimal places in dotnet

Formating Decimal Numbers to two or more decimal places in dotnet

FormatNumber(convert.ToDouble("100.22"), 2, , , TriState.False)

using Case statmenet in sql server query


select [Disti Name], [Product Group],
CASE FQ
WHEN 'Q1' THEN 'Feb-Jul'
WHEN 'Q2'THEN 'March-Aug'
WHEN 'Q3' THEN 'April-Sept'
WHEN 'Q4' THEN ' May-Oct'
ELSE 'NULL'
END
,SUM([Extended Resale]) as [Total Post Extended Resale],SUM([Extended Cost]) AS [Total Pos Extended Cost],CONVERT(varchar,
(CONVERT(decimal(18, 2), (1.0 * ((SUM([Extended Resale])-SUM([Extended Cost]))/(nullif(SUM([Extended Resale]),0)))) * 100))) AS [Margin]
from dbo.POS_Details_FY09M10_FY10M05
group by [Disti Name],[product group],FQ
order by [Disti Name],[Product Group],FQ