gridview for a date column less than 15 days old

Question

5.00/5 (1 vote)

See more:

I have a grid view with a column showing date on which record was posted
I want the grid view to show data which is posted within last 15 days
How do I write my select command so that the only records less than 15 days old compared to current date and time are selected.

I am using ASP.NET with C#

I have tried something like "WHERE DatePosted <= DateTime.UtcNow" in the SqlSelectCommand
and also tried "WHERE DatePosted <= @datePosted" and added command.parameteres.AddwithValue("@DatePosted", DateTime.UtcNow) but apparently I am missing some important code, as it does not work

I am new to ASP.NET and desperately need help to deal with date column
Any kind of help that can be useful for a new person shall be highly appreciated

Kindly help
Best Regards

Posted 1-Nov-13 5:29am

Member 10235977

Updated 1-Nov-13 5:35am

v2

Add a Solution

2 solutions

Solution 1

Try using the DATEADD() function. You can use negative numbers as well.

DATEADD() function tutorial[^]

Posted 1-Nov-13 5:31am

Richard C Bishop

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)

Member 10235977 · Accepted Answer · 2013-11-03T05:03:00

A dynamic command can be given in codebehind. For benefit of those who are stuck at this problem like me, the syntax is
protected void nameofSqlDataSource_Selecting(object sender, SqlDataSourceSelectingEventArgs e)
{
e.Command.Parameters["@DateSent"].Value = DateTime.UtcNow.AddDays(-15);
}
You can give any number for days in stead of 15. You can also define any date dynamically with reference to any control parameter.