open a gridview of specific date using calendar

Question

I have problem to extract attendance information of selected date on calendar so I make a triky code which assign selected date from calendar to a textbox and then a gridview should appear that have a column value = textbox value or something like this

 

Public Class Attendance
    Inherits System.Web.UI.Page

    Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
        Calendar1.Visible = False
    End Sub

    Protected Sub Button1_Click(ByVal sender As Object, ByVal e As EventArgs) Handles Button1.Click
        Calendar1.Visible = True
    End Sub

    Protected Sub Calendar1_SelectionChanged(ByVal sender As Object, ByVal e As EventArgs) Handles Calendar1.SelectionChanged
        TextBox1.Text = Calendar1.SelectedDate



    End Sub
End Class

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
        DataSourceID="SqlDataSource2" EnableModelValidation="True">
        <Columns>
            <asp:BoundField DataField="EID" HeaderText="EID" SortExpression="EID" />
            <asp:BoundField DataField="DateOfDay" HeaderText="DateOfDay"
                SortExpression="DateOfDay" />
            <asp:CheckBoxField DataField="Present" HeaderText="Present"
                SortExpression="Present" />
        </Columns>
    </asp:GridView>

 so now I need to filter the result of gridview by selected date

 

 

thanks developers