I have an requirement in my application i was showing Employee Designations according to their manager level in a GridView Control. Based on Employee Designation i need to have a coloring on every different designations of an employee.
If employee desig is :Associate->show in Blue color
If employee desig is :Senior Associate->show in Greencolor
If employee desig is :Team Lead->show in Red color
from Stored Procedure.