Kindly go through below code...
<asp:label id="Date" runat="server" xmlns:asp="#unknown">Select Date:
<asp:calendar id="Calendar2" runat="server" selectionmode="DayWeekMonth" onselectionchanged="Calendar1_SelectionChanged" xmlns:asp="#unknown">
Todays Date is: <asp:label id="lblday" runat="server" xmlns:asp="#unknown">
Selected Date is:<asp:label id="lblbday" runat="server" xmlns:asp="#unknown">
<asp:button id="addDates" runat="server" onclick="addDates_Click" text="Display" class="button1" xmlns:asp="#unknown">
style="margin-left: 137px" Width="150px" />
<asp:gridview id="GridView1" runat="server" autogeneratecolumns="False" xmlns:asp="#unknown">
Height="178px" Width="402px">
<columns> <asp:boundfield datafield="scode" headertext="scode" sortexpression="scode">
<asp:boundfield datafield="drdates" headertext="drdates">
SortExpression="drdates" />
<asp:boundfield datafield="Column1" headertext="Column1" readonly="True">
SortExpression="Column1" />
<asp:sqldatasource id="SqlDataSource1" runat="server" xmlns:asp="#unknown">
ConnectionString="<%$ ConnectionStrings:Zain-IraqConnectionString %>"
SelectCommand="select scode, drdates, count(*) from drreceive_20141229 group by drdates, scode">
code behind
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
namespace ISYSProject
{
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void Calendar1_SelectionChanged(object sender, EventArgs e)
{
lblday.Text = Calendar2.TodaysDate.ToShortDateString();
lblbday.Text = Calendar2.SelectedDate.ToShortDateString();
}
protected void addDates_Click(object sender, EventArgs e)
{
GridView1.DataSource = SqlDataSource1;
GridView1.DataBind();
}
}
}