DataGrid
DataGrid, Web development
I have a datagrid in my form that contains coloumn of attendence of a perticular ID .what i want to do is to calculate total number of 'P' and 'A' in a textbox Question
DataGrid, Web development
I have a datagrid in my form that contains coloumn of attendence of a perticular ID .what i want to do is to calculate total number of 'P' and 'A' in a textbox 
Subscribe to Alerts! Get questions and answers delivered to your Inbox.
Answer Wiki (Improve, edit or add to this answer)
RATE THIS ANSWER
0
Click to Vote:
0
Click to Vote:
- 0
0
Hello,
adjust and use the following queries to match your needs (change the YOURFILED to match your own).
SELECT COUNT(YOURFIELD) AS COUNTPs WHERE YOURFIELD="P"
SELECT COUNT(YOURFIELD) AS COUNTAs WHERE YOURFIELD="A"
Bye
Browse more Questions and Answers on Development.
Looking for relevant Development Whitepapers? Visit the SearchSQLServer.com Research Library.
