Using Date Field In Search String To Bind To Repeater

i am trying to search an SQL database to retrieve all names from employee table who have a birthday today. this needs to automatically fill in the date parameter with the system date. this is what i have so far:








sub page_load(sender as object, e as eventargs)


dtmDate=DateTime.Now.ToString("M")


con = New SqlConnection("Server=Localhost;UID=******;PWD=*****;Database=Pubs")





cmd = New SqlCommand("Select fname, lname From Employee where dob='& dtmDate'", con)





con.open()


dtrBday = cmd.ExecuteReader()





rptBday.DataSource=dtrBday


rptBday.DataBind()


dtrBday.Close()











I know this isnt quite right. i get errors when it hits my repeater.





the error i am getting is :Syntax error converting string to smalldatetime data type.


if someone could give me a push in the right direction here it would be greatly appreciated.