how can i display details of the current month from sql table in c # ?

Question

i have appintment application in c # the user would like to search the appointment of the current month 

i havw field called appdate as datetime 

 

thanks for help