Wednesday, April 15, 2015

How to add serial no in crystal report cross tab

No option in crystal report instead use sql server's DENSE RANK FUNCTION
e.g.
SELECT DENSE_RANK() OVER(ORDER BY g.[FirstColumnInCrossTab]) SrNo, * FROM 

Monday, April 13, 2015

How do I convert an enum to a list in asp net C#

Enum.GetValues(typeof(SomeEnum)).Cast<SomeEnum>().Select(v => v.ToString()).ToList();