Show data between two dates

Question

0.00/5 (No votes)

See more:

Hi, i want to select data from database between two dates, its showing data only that month, if i want to show data between two months its not showing.
I am using this code for retrieving data.

C#

using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["connection"].ConnectionString))
        {
            using (SqlCommand cmd = new SqlCommand("SELECT * FROM [tablename] where Date BETWEEN '"+txtDateFrom.Text+"' AND '"+txtToDate.Text+"'"))
            {
                using (SqlDataAdapter sda = new SqlDataAdapter())
                {
                    cmd.Connection = con;
                    sda.SelectCommand = cmd;
                    using (DataTable dt = new DataTable())
                    {
                        sda.Fill(dt);
                        GridView1.DataSource = dt;
                        GridView1.DataBind();
                    }
                }
            }
        }

Posted 20-Dec-13 20:18pm

Sachin Mortale

Updated 20-Dec-13 20:26pm

Karthik_Mahalingam

v2

Add a Solution

Comments

♥…ЯҠ…♥ 21-Dec-13 2:32am

Nothing to do with C# here, Can you give sample data to optimize your query.....? what is the input and what is the expected output?

Sachin Mortale 21-Dec-13 2:35am

I want to show data between '10/10/2013' and '20/12/2013' but its display only 12th(Dec) month data.

♥…ЯҠ…♥ 21-Dec-13 2:37am

You sure you have data for the prev month also? execute your query in sql server and see what you get

Sachin Mortale 21-Dec-13 2:38am

Yes i have data in 10th month and 12th month but not in 11th month

♥…ЯҠ…♥ 21-Dec-13 2:57am

SELECT * FROM [tablename] where Date BETWEEN '10/10/2013' AND '20/12/2013' execute this query in sql server and check your data, if data exist then time could be the issue... check it now

5 solutions

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)

Praveen_P · Answer 1 · 2013-12-20T22:22:00

Solution 3

Select * from Tablename where (Initiate_date BETWEEN '" + txtsdate.Text + "' AND '" + txtfdate.Text + "')

Posted 20-Dec-13 22:22pm

Praveen_P

Nayan Chavada · Answer 2 · 2013-12-21T08:37:00

Hi,

You can use following code of SQL to get date between records

where Date BETWEEN Convert(DateTime,'"+txtFromDate.Text+"',101) AND Convert(DateTime,'"+txtToDate.Text+"',101)"

you can also use server side filter option on DataTable object

DataTable dt = new DataTable();
//Date between datefrom and dateto expression like sql server
string strSQLExp = "Date=21/12/2013";
dt.Select(strSQLExp);

that you have use for binding data to datacontrol

Don't forgot to mark this as solution if it is.

Happy Codding...
Nayan Chavada

Karthik_Mahalingam · Answer 3 · 2013-12-20T20:36:00

Solution 1

Try like this,

SQL

SELECT * FROM tablename
WHERE datecolumn >= '"+txtDateFrom.Text+"'  AND datecolumn <=  '"+txtDateTo.Text+"'

Posted 20-Dec-13 20:36pm

Karthik_Mahalingam

ravikiran from Hyderabad · Answer 4 · 2013-12-20T22:06:00

Solution 2

As per SQL database default date format is mm/dd/year.

so you have to convert your textbox date to sql's date.

DateTime.ParseExact(<textboxdate>, "dd/MM/yyyy", null).ToString("MM/dd/yyyy");

Posted 20-Dec-13 22:06pm

ravikiran from Hyderabad

M.R.A. · Answer 5 · 2013-12-21T04:45:00

Solution 4

SQL

SELECT * FROM [tablename] where Date BETWEEN Convert(Datetime,'"+txtDateFrom.Text+"',103) AND Convert(datetime,'"+txtToDate.Text+"',103)"

Posted 21-Dec-13 4:45am

M.R.A.

Updated 21-Dec-13 5:57am

v2