Compare date in database.

Question

0.00/5 (No votes)

See more:

C#

var _tol = from to in ddc.tbl_LeadAssigns
                          where to.ToDate == DateTime.Today && to.UserId == new Guid(sID)
                          select to;
               foreach (var cnt in _tol)
               {
                   todayCount = todayCount + Convert.ToInt32(cnt.TotalLead);
               }
               lblToday.Text = todayCount.ToString();

Posted 9-May-11 2:13am

Vineet_2109

Add a Solution

Comments

Mahendra.p25 9-May-11 8:15am

what is the error

R. Giskard Reventlov 9-May-11 8:17am

Last week.

Vineet_2109 9-May-11 8:18am

In above query, i want today's lead from column "totalLead" and add all lead.
if i change code in query and put "where to.Todate < DateTime.Today" it return previous lead and add all lead. so how can i retrieve compare today date.

3 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)

OriginalGriff · Answer 1 · 2011-05-09T02:34:00

Solution 1

The problem is probably that the DateTime value you retrieve from the database will have a time on it, so the comparison will never succeed.
Try:

where to.ToDate.Today == DateTime.Today && to.UserId == new Guid(sID)

That may fix it. If it doesn't then we will need a bit more info.

Posted 9-May-11 2:34am

OriginalGriff

Comments

Vineet_2109 9-May-11 8:42am

where to.ToDate.Today this wont happen as it LINQ database entity

Wonde Tadesse 9-May-11 22:14pm

It doesn't work with direct == operator. :(. That happen usually the database time value will not match to the current date time value. I know that you already stated but the example you gave doesn't work.

Wonde Tadesse · Answer 2 · 2011-05-09T15:28:00

I will answer your question based on two assumption.
1.If your table contains non nullable value of ToDate column.If so you have to use ToDate.Value
2.If you concerned only about Month,Day and Year values of the ToDate column. Not hour, minute and second values. If so you can format based on these values.

If we agree on this, the following code will properly select date value from your linq query

C#

var query = from to in ddc.tbl_LeadAssigns
                   select new { formatedDate = to.ToDate.Month + "/" + to.ToDate.Day + "/" + to.ToDate.Year, to.UserId };

       var _tol = from to in query
                  where to.formatedDate.Equals(DateTime.Now.ToShortDateString())
                  select to;
              foreach (var cnt in _tol)
              {
                  todayCount = todayCount + Convert.ToInt32(cnt.TotalLead);
              }
              lblToday.Text = todayCount.ToString();

Again there are a lot of assumption that I left, like culture and more.

Theingi Win · Answer 3 · 2011-05-09T18:47:00

If you save long date time in your database ,you can check the following code for only one day

C#

var _tol = "from to in ddc.tbl_LeadAssigns
           where to.ToDate > "+  DateTime.Today + " &&"+ "to.ToDate < "+ DateTime.Today.AddDays(1) +" <pre lang="sql">&& to.UserId == new Guid(sID)
                          select to;
               foreach (var cnt in _tol)
               {
                   todayCount = todayCount + Convert.ToInt32(cnt.TotalLead);
               }
               lblToday.Text = todayCount.ToString();

Best Regard ,
Theingi Win

Compare date in database.

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0