Avatar of DJ P
DJ P
Flag for United States of America asked on

Record count based on a condition vb.net winform

Hello experts. I have a winform that I fumbled my way through that connects to a sql database via a class I created (see attached if helpful). On my form I have a datagridview. The grid contains several columns. What I want to do is either have text boxes or labels that tell me how many records in my priority column contain Urgent, High, Medium, Low.

Example: Low               5
                 Medium        11

My issue is I have no idea how to connect a text box or label to the db with the proper syntax on how to count those records.
code.docx
DatabasesVisual Basic.NETSQL

Avatar of undefined
Last Comment
DJ P

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
it_saige

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
SOLUTION
it_saige

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
DJ P

ASKER
That's great but I'm not sure where this code gets placed in relation to my current code.
DJ P

ASKER
Sorry, Disregard my last. Worked perfectly!
DJ P

ASKER
Thanks for the help!
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy