I don't know how to solve this error ? count

Question

1.00/5 (2 votes)

See more:

i have 2 where what i loking for is to have (where) (and)

C#

where DB_A448D1_ilgswork.DueBy == DateTime.Today.ToLongDateString() 
                                where DB_A448D1_ilgswork.username == txtusername.Text

What I have tried:

C#

var getreminders = (from DB_A448D1_ilgswork in doAction.uni_projects
                                where DB_A448D1_ilgswork.DueBy == DateTime.Today.ToLongDateString() 
                                where DB_A448D1_ilgswork.username == txtusername.Text
                                select DB_A448D1_ilgswork).ToList();

            if (getreminders.Count >= 1)
            {
                lbldue.Visible = true;
                lbldue.Text = "You have " + getreminders.Count() + "reminders set for today";
                lbnoldue.Visible = false;
            }
            else
            {
                lbnoldue.Visible = true;
                lbldue.Visible = false;
            }

Posted 12-Feb-19 0:08am

el_tot93

Updated 12-Feb-19 1:53am

v4

Add a Solution

Comments

Richard Deeming 12-Feb-19 9:48am

where DB_A448D1_ilgswork.DueBy == DateTime.Today.ToLongDateString()

Looks like you're storing dates as strings. Don't do that. Not only does it take up much more space, it also allows invalid values, and leads to problems interpreting strings generated on computers with different regional settings.

Use either DateTime or DateTimeOffset in your model, and use a proper date/time data type in your database.

1 solution

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)

TheRealSteveJudge · Answer 1 · 2019-02-12T00:15:00

Solution 1

You do not say what kind of error.
I assume that getreminders is null because your query gave no results.
You cannot access the Count property when getreminders is null.
You will get a null reference exception.

Use a debugger and see yourself.

OK. The red line is in your IDE.
Of course an IQueriable does not have a Count property.
You should convert it then to a list.

var getreminders = (from DB_A448D1_ilgswork in doAction.uni_projects
                              where DB_A448D1_ilgswork.DueBy == DateTime.Today.ToLongDateString()
                              select DB_A448D1_ilgswork).ToList();

Posted 12-Feb-19 0:15am

TheRealSteveJudge

Updated 12-Feb-19 0:23am

v3

Comments

el_tot93 12-Feb-19 6:18am

i get a red line under it

TheRealSteveJudge 12-Feb-19 6:23am

Please see updated solution.

el_tot93 12-Feb-19 6:24am

sorry my bro how can i do that ??

TheRealSteveJudge 12-Feb-19 6:34am

Just replace line 3 to 5 by the example I showed you.

el_tot93 12-Feb-19 6:35am

thx it work with me

TheRealSteveJudge 12-Feb-19 6:44am

you're welcome

el_tot93 12-Feb-19 7:47am

sorry can you see my update

TheRealSteveJudge 12-Feb-19 7:55am

Please see the updated solution.
Now no one else can understand the solution
as you changed the question...
Please, in future, one question for each problem.

el_tot93 12-Feb-19 8:02am

ok i will