troubleshooting Question

Record count based on a condition vb.net winform

Avatar of DJ P
DJ PFlag for United States of America asked on
DatabasesVisual Basic.NETSQL
5 Comments2 Solutions29 ViewsLast Modified:
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
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 2 Answers and 5 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 5 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros