Hi, Below is my MS SQL Server query which selecting 5 columns from the Database table

Employee_Id, Manager_Time_In, Employee_Time_In, Biometric_Time_In, Date

select Employee_Id
       ,(case when Manager_Time_In is NULL then Employee_Time_In
         when Biometric_Time_In is Null then Employee_Time_In
         else Manager_Time_In end) as Check_in
       ,Attendance_Date from Time_Adjustment_Of_Employee

Now my requirement is while loading data to VB.Net Gridview

If case result is Biometric_Time_In then the cell colour of vb.net gridview will remain White

If case result is Employee_Time_In then the cell colour of vb.net gridview will change to Red

if case result is Manager_Time_In then the cell colour of vb.net gridview will change to Green

Please help

If not understand the requirement please ask