Display Dates between two Dates using AJAX CalendarExtender in ASP.Net using C# and VB.Net

Hey democloud,

Please refer below sample,

HTML

<asp:ScriptManager runat="server" />
<div class=" input-group date form_date">
    from:
    <asp:TextBox ID="txtFrom" class="form-control years hasDatepicker" placeholder="Enter Date"
        runat="server"></asp:TextBox>
    To :
    <asp:TextBox ID="txt_todate" class="form-control years hasDatepicker" placeholder="Enter Date"
        runat="server"></asp:TextBox>
    <span class="input-group-addon"><a href="#"><i id="Image2" class="fa fa-calendar"></i>
    </a>
        <cc1:CalendarExtender ID="CalendarExtender2" runat="server" TargetControlID="txt_todate"
            CssClass="" Format="MM/dd/yyyy" Enabled="True" PopupButtonID="txt_todate" />
    </span><span class="input-group-addon"><a href="#"><i id="I1" class="fa fa-calendar">
    </i></a>
        <cc1:CalendarExtender ID="CalendarExtender1" runat="server" TargetControlID="txtFrom"
            CssClass="" Format="MM/dd/yyyy" Enabled="True" PopupButtonID="txtFrom" />
    </span>
    <br />
    <asp:Button Text="Display" runat="server" OnClick="Display" />
    <br />
    <asp:GridView runat="server" AutoGenerateColumns="false" ID="gvEmployees">
        <Columns>
            <asp:BoundField DataField="BirthDate" HeaderText="BirthDate" />
        </Columns>
    </asp:GridView>
</div>

Namespaces

C#

using System.Data.SqlClient;
using System.Configuration;
using System.Data;

VB.Net

Imports System.Data.SqlClient
Imports System.Data

Code

C#

protected void Display(object sender, EventArgs e)
{
    string constr = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
    using (SqlConnection con = new SqlConnection(constr))
    {
        using (SqlCommand cmd = new SqlCommand("SELECT BirthDate FROM Employees WHERE BirthDate BETWEEN @fromDate AND @ToDate", con))
        {
            cmd.Parameters.AddWithValue("@fromDate", txtFrom.Text);
            cmd.Parameters.AddWithValue("@ToDate", txt_todate.Text);
            using (SqlDataAdapter da = new SqlDataAdapter(cmd))
            {
                DataTable dt = new DataTable();
                da.Fill(dt);
                this.gvEmployees.DataSource = dt;
                this.gvEmployees.DataBind();
            }
        }
    }
}

VB.Net

Protected Sub Display(ByVal sender As Object, ByVal e As EventArgs)
    Dim constr As String = ConfigurationManager.ConnectionStrings("constr").ConnectionString
    Using con As SqlConnection = New SqlConnection(constr)
        Using cmd As SqlCommand = New SqlCommand("SELECT BirthDate FROM Employees WHERE BirthDate BETWEEN @fromDate AND @ToDate", con)
            cmd.Parameters.AddWithValue("@fromDate", txtFrom.Text)
            cmd.Parameters.AddWithValue("@ToDate", txt_todate.Text)
            Using da As SqlDataAdapter = New SqlDataAdapter(cmd)
                Dim dt As DataTable = New DataTable()
                da.Fill(dt)
                Me.gvEmployees.DataSource = dt
                Me.gvEmployees.DataBind()
            End Using
        End Using
    End Using
End Sub

Screenshot