How to retrieve data from sql database by clicking one date of calender control

See more:

SQL-Server-2005

C#

ASP.NET

, +

I want to retrieve the particular datas from sql database by clicking one date of calender control.
In my database i have taken name nvarchar(50),date nvarchar(50),year nvarchar(50) in the table name record.
Build is succeeded but it is not retrieving the datas from database.

protected void Calendar1_SelectionChanged(object sender, EventArgs e)
    {
        con.Open();
        SqlCommand cmd = new SqlCommand("select  *from record where date='" + Calendar1.SelectedDate.Day.ToString() + "' and Month='" + Calendar1.SelectedDate.Year.ToString() + "'", con);
        SqlDataAdapter ad = new SqlDataAdapter(cmd);
        DataSet ds = new DataSet();
        ad.Fill(ds, "record");
        GridView1.DataSource = ds.Tables["record"].DefaultView;
        GridView1.DataBind();
        con.Close();
    }

Sir please give the solution.