Display data from SQL based on date selected c#

Question

4.00/5 (1 vote)

See more:

Hello,
I'm new to ASP.NET
I have a GridView that display data from SQL table.
I want to display data in the GridView based on the date selected from either Calendar or Textbox.
Here is the code:

ASP.NET

<p><asp:Label ID="Date" runat="server">Select Date:</asp:Label>
     
      <asp:Calendar ID="Calendar2" runat="server"  SelectionMode="DayWeekMonth" onselectionchanged="Calendar1_SelectionChanged">
            </asp:Calendar>

        <p>Todays Date is:  <asp:Label ID="lblday" runat="server"></asp:Label></p>
        <p>Selected Date is:<asp:Label ID="lblbday" runat="server"></asp:Label></p>

    <asp:Button ID="addDates" runat="server" Text="Display" class="button1" 
            style="margin-left: 137px" Width="150px" />
        </p>
    <!--<p><asp:Calendar ID="drdates" runat="server" class="textbox1"></asp:Calendar>-->
       

        <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" 
            DataSourceID="SqlDataSource1" 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" />
            </Columns>
        </asp:GridView>
        <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
            ConnectionString="<%$ ConnectionStrings:Zain-IraqConnectionString %>" 
            SelectCommand="select scode, drdates, count(*) from drreceive_20141229 group by drdates, scode">
        </asp:SqlDataSource>

Here is the C# code:

C#

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();
        }
    }
}

Posted 3-May-15 21:20pm

zahedkw

Add a Solution

Comments

upendra shahi 4-May-15 3:57am

Bind gridview on button clicked event.

zahedkw 4-May-15 4:00am

Im new...how do I do that. Thanks

4 solutions

Solution 1

Hello.. you should search google before spending time to ask questions. there are lot of answers in the web here are a few

https://msdn.microsoft.com/en-us/library/fkx0cy6d%28v=vs.110%29.aspx[^]

http://www.java2s.com/Tutorial/ASP.NET/0380__Data-Binding/DataBindingtoGridViewC.htm[^]

and you can filter data based on date in the sql query

Posted 3-May-15 22:54pm

SRJ88

Updated 3-May-15 22:56pm

v2

Solution 3

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

C#

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();
    }

    }
}

Posted 3-May-15 23:04pm

upendra shahi

Solution 6

Please check the aspx code as below :-

C#

 <div>
	<asp:Calendar ID="Calendar1" runat="server" OnSelectionChanged="Calendar1_SelectionChanged" xmlns:asp="#unknown"></asp:Calendar>
	<asp:GridView ID="GridView1" runat="server" xmlns:asp="#unknown">
	<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" />
	</Columns>
	</asp:GridView>
	<p>Todays Date is:  <asp:Label ID="lblday" runat="server"></asp:Label></p>
	<p>Selected Date is:<asp:Label ID="lblbday" runat="server" xmlns:asp="#unknown"></asp:Label></p>
	<asp:SqlDataSource ID="SqlDataSource1" runat="server"  ConnectionString='<%$ ConnectionStrings:Zain-IraqConnectionString %>' 
	SelectCommand="SELECT scode, drdates, COUNT(*)  FROM drreceive_20141229 GROUP BY scode, drdates" FilterExpression=" drdates = '{0}'">
		<FilterParameters>
		<asp:ControlParameter ControlID="Calendar1" DefaultValue="" Name="drdates" PropertyName="SelectedDate" />
		</FilterParameters>
	</asp:SqlDataSource>
</div>

Please check the below code behind :-

C#

protected void Calendar1_SelectionChanged(object sender, EventArgs e)
	{
		lblday.Text = Calendar1.TodaysDate.ToShortDateString();
		lblbday.Text = Calendar1.SelectedDate.ToShortDateString();


		GridView1.DataSource = SqlDataSource1;
		GridView1.DataBind();
	}

Posted 4-May-15 0:57am

psima

Updated 4-May-15 1:00am

v3

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

KaushalJB · Accepted Answer · 2015-05-03T22:59:00

Solution 2

You need to perform date filter on sql query and again bind the Grid.

Refer this link for how to apply filter : Filter GridView Data based from Date Ranges

Posted 3-May-15 22:59pm

KaushalJB