Getting total amount of rows with a certain value C# WPF Linq

Question

I need to check my tblProjects table, in the foreign key column "ClientID", for a value that matches the "ClientLoginID"(primary key) value in my tblClientLoginDetails table and I want to display the total amount of columns that match that value in a label.

Here is coding where I have tried to do so, but it doesn't display any info in my label. I think it might be because of it getting multiple values and not knowing what to do with it.

using (DataClassesDataContext DC = new DataClassesDataContext())
{
    int CurrentClient = CLD.UserID;

    var Count = DC.tblProjects.Where<tblProject>
                  (c => c.ClientID == CurrentClient);
                  lblTotalProjectsAmount.Content = Count;
}

Also I am not getting any errors with the code above?

Sorry if the question sounds vague, but I do not know how to ask it in another way. For any advice or answers, I would be very greatfull!

Hossein Narimani Rad · Accepted Answer · 2015-04-23 13:03:30Z

1

Seems you forget to use the Count() at the end of your linq:

 using (DataClassesDataContext DC = new DataClassesDataContext())
 {
    int CurrentClient = CLD.UserID;

    var Count = DC.tblProjects.Where<tblProject>
            (c => c.ClientID == CurrentClient).Count(); //THIS LINE

    lblTotalProjectsAmount.Content = Count;
}

Alternatively you may try something like this:

 using (DataClassesDataContext DC = new DataClassesDataContext())
 {
    int CurrentClient = CLD.UserID;

    var Count = DC.tblProjects.Count(c => c.ClientID == CurrentClient); //THIS LINE

    lblTotalProjectsAmount.Content = Count;
}

answered Apr 23, 2015 at 13:03

Hossein Narimani Rad

32.7k19 gold badges92 silver badges122 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

CareTaker22 Over a year ago

Thank you very much for your effort! This got it fixed :D

Collectives™ on Stack Overflow

Getting total amount of rows with a certain value C# WPF Linq

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related