database and label colors depending from the result set.

May 12 2009 9:49 AM

Dear all,

I have a database with 5 columns where I have written 0, 1 or 2.
Depending of the result in these 5 columns I have to change the color of 5 labels (green - 0, yellow - 1 or red - 2) in asp.net c#.