Search Date based on ddMMyyyy and show result in GridView

Here i have used the AjaxCalenderControl to Select the date.

HTML:

<form id="form1" runat="server">
    <div>
        <cc1:ToolkitScriptManager runat="server">
        </cc1:ToolkitScriptManager>
        AttenDate
        <asp:TextBox ID="txtAteDate" runat="server" /><br />
        <cc1:CalendarExtender ID="ceAteDate" runat="server" Format="dd/MM/yyyy" TargetControlID="txtAteDate">
        </cc1:CalendarExtender>
        name<asp:TextBox ID="txtName" runat="server" /><br />
        City<asp:TextBox ID="txtCity" runat="server" /><br />
        State<asp:TextBox ID="txtState" runat="server" /><br />
        DoB
        <asp:TextBox ID="txtDob" runat="server" /><br />
        <cc1:CalendarExtender ID="ceDob" runat="server" Format="dd/MM/yyyy" TargetControlID="txtDob">
        </cc1:CalendarExtender>
        Id<asp:TextBox ID="txtID" runat="server" /><br />
        <asp:Button ID="btnSearchDate" runat="server" Text="Insert" OnClick="AddData" />
        <br />
        <br />
        Search
        <asp:TextBox ID="txtSearchDate" runat="server" Text="" />
        <cc1:CalendarExtender ID="ceSearchDate" runat="server" Format="dd/MM/yyyy" TargetControlID="txtSearchDate">
        </cc1:CalendarExtender>
        <asp:Button ID="btnSearchBasedOnDate" Text="Search" OnClick="SearchBasedOnDate" runat="server" />
        <asp:GridView ID="gvSearchResult" runat="server">
            <Columns>
                <asp:BoundField DataField="Name" HeaderText="Name" />
                <asp:BoundField DataField="City" HeaderText="City" />
                <asp:BoundField DataField="State" HeaderText="State" />
            </Columns>
        </asp:GridView>
    </div>
    </form>

C#

protected void SearchBasedOnDate(object sender, EventArgs e)
    {
        string constr = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
        string sqlStatment = "SELECT [Name] ,[City],[State] FROM Child WHERE Dob = @Dob";
        using (SqlConnection con = new SqlConnection(constr))
        {
            using (SqlCommand cmd = new SqlCommand(sqlStatment, con))
            {
                cmd.Parameters.AddWithValue("@Dob", Convert.ToDateTime((this.txtSearchDate.Text.Trim())));
                using (SqlDataAdapter da = new SqlDataAdapter(cmd))
                {
                    DataSet ds = new DataSet();
                    da.Fill(ds);
                    this.gvSearchResult.DataSource = ds;
                    this.gvSearchResult.DataBind();

                }
            }
        }
    }

    protected void AddData(object sender, EventArgs e)
    {
        string constr = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
        string sqlStatment = "INSERT INTO [Child]([AttenDate],[ID],[Dob] ,[Name] ,[City],[State])" +
     "VALUES(@AttenDate,@ID,@Dob,@Name,@City,@State)";
        using (SqlConnection con = new SqlConnection(constr))
        {
            using (SqlCommand cmd = new SqlCommand(sqlStatment, con))
            {
                con.Open();
                cmd.Parameters.AddWithValue("@AttenDate", Convert.ToDateTime(txtAteDate.Text));
                cmd.Parameters.AddWithValue("@ID", txtID.Text.Trim());
                cmd.Parameters.AddWithValue("@Dob", Convert.ToDateTime(txtDob.Text));
                cmd.Parameters.AddWithValue("@Name", this.txtName.Text.Trim());
                cmd.Parameters.AddWithValue("@City", this.txtCity.Text.Trim());
                cmd.Parameters.AddWithValue("@State", txtState.Text.Trim());
                cmd.ExecuteNonQuery();
                con.Close();
            }
        }
    }

SQL:

CREATE TABLE [dbo].[Child](
	[AttenDate] [datetime] NULL,
	[ID] [int] NULL,
	[Dob] [smalldatetime] NULL,
	[Name] [varchar](50) NULL,
	[City] [varchar](50) NULL,
	[State] [varchar](50) NULL
) ON [PRIMARY]

GO

Register the AjaxControlToolkit in page as

<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="cc1" %>