how to validate gridview employee id to imagefolderemployee

Question

  In E Folder all faculty images are stored with the name of each employee id.

In E folder list of images as follows


1 ( 1 is the employee id is the image name for each faculty)
2 ( 2 is the employee id is the image name for each faculty)


In Gridview as follows


Faculty Name Faculty ID Images

Ramesh 1 Ramesh image (Ramesh employee id is 1)
Suresh 2 Suresh image (sruesh employee id is 2)


i want to bind corresponding employee id image from folder to gridview.


for that how can i do in asp.net using c#.

thanks
regards,
narasiman P

Answer 1

In DB Column, You may have a column to specify the Room is booked on that date or not ?. For a range of dates, use between statement in sql.  If the rooms are booked between the date range, then do your action.