DaniWeb Forum Index > Software Development > C#

Fetching records based on range of dates

Please support our C# advertiser: Programming Forums - DaniWeb Sister Site

Thread Solved

•

Join Date: Oct 2009

Posts: 3

Reputation: dhana3 is an unknown quantity at this point

Solved Threads: 0

dhana3

Offline

Newbie Poster

Fetching records based on range of dates

Nov 9th, 2009

Hai,
I need to fetch records in to gridview based on fromdate and todate using c#,plzzz help asap

•

Join Date: Jul 2009

Posts: 972

Reputation: DdoubleD is a jewel in the rough

Solved Threads: 213

DdoubleD

Offline

Posting Shark

Nov 9th, 2009

Are you wanting a WHERE clause example? If so, what database are you using?

•

Join Date: Oct 2008

Posts: 2,721

Reputation: adatapost has much to be proud of

Solved Threads: 501

adatapost

Offline

Posting Maven

Nov 9th, 2009

Use BETWEEN caluse - BETWEEN returns TRUE if the value of test_expression is greater than or equal to the value of begin_expression and less than or equal to the value of end_expression.

Help with Code Tags

text Syntax (Toggle Plain Text)

SELECT * FROM TableName Where TestDate 
  BETWEEN '01/01/2009' AND '01/31/2009'

Last edited by adatapost; Nov 9th, 2009 at 9:31 pm.

•

Join Date: Feb 2009

Posts: 3,442

Reputation: sknake has much to be proud of

Solved Threads: 625

sknake

Offline

.NET Enthusiast

Nov 10th, 2009

Here is another example of MSSQL using the between operater with parameterized SQL:

 Help with Code Tags 
 C# Syntax (Toggle Plain Text) 
    private void button2_Click(object sender, EventArgs e)
    {
      const string connStr = "Data Source=apex2006sql;Initial Catalog=Leather;Integrated Security=True;";
      const string query = "Select * From Invoice Where (InHomeDate BETWEEN @Date1 and @Date2)";
      using (SqlConnection conn = new SqlConnection(connStr))
      {
        conn.Open();
        using (SqlCommand cmd = new SqlCommand(query, conn))
        {
          cmd.Parameters.Add(new SqlParameter("@Date1", SqlDbType.DateTime)).Value = DateTime.Today.AddDays(-180);
          cmd.Parameters.Add(new SqlParameter("@Date2", SqlDbType.DateTime)).Value = DateTime.Today;
          using (SqlDataReader dr = cmd.ExecuteReader())
          {
            DataTable dt = new DataTable();
            dt.Load(dr);
            dataGridView1.DataSource = dt;
          }
        }
      }
    }
    private void button2_Click(object sender, EventArgs e)
    {
      const string connStr = "Data Source=apex2006sql;Initial Catalog=Leather;Integrated Security=True;";
      const string query = "Select * From Invoice Where (InHomeDate BETWEEN @Date1 and @Date2)";
      using (SqlConnection conn = new SqlConnection(connStr))
      {
        conn.Open();
        using (SqlCommand cmd = new SqlCommand(query, conn))
        {
          cmd.Parameters.Add(new SqlParameter("@Date1", SqlDbType.DateTime)).Value = DateTime.Today.AddDays(-180);
          cmd.Parameters.Add(new SqlParameter("@Date2", SqlDbType.DateTime)).Value = DateTime.Today;
          using (SqlDataReader dr = cmd.ExecuteReader())
          {
            DataTable dt = new DataTable();
            dt.Load(dr);
            dataGridView1.DataSource = dt;
          }
        }
      }
    }