Posted on: 5/16/2012 10:18:03 AM | Views : 234

Hi,
I need some help that relate to database and if...else statement.
Below are the thing that i want to do,
a.pull the latest data from database
b.check whether start_time and end_time got value
c.if end_time got value means the student done her exam ard, system will show label.text="End"
d.if start_time got value but end_time is empty, this means the student still in exam, system will return label.text ="Start"

Below is my database,
column Name    column Starttime     column Endtime
Jenny               1/5/2012 8.00am    1/5/2012 10.00a.m
Alan                 2/5/2012 9.00a.m
Can someone guide me how to code the above problem?
Thanks.Smile Go to the complete details ...