I want to capture the selection(s) a user makes on the calendar control and use that as a filter for my gridview. This is what I have so far, but of course it isn't filtering as I believe the formatting isn't correct?
If Label2.Text Then
data.SelectCommand = ("SELECT * FROM [atable] where date is like '" & Label2.Text & " ' ")
Protected Sub Calendar1_SelectionChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles Calendar1.SelectionChanged
Label2.Text = Calendar1.SelectedDate.ToShortDateString