DJ P
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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Sorry, Disregard my last. Worked perfectly!
ASKER
Thanks for the help!
ASKER