Question

  Asked: May 13 2008   7:50 AM GMT
  Asked by: Harsh2215


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

Subscribe to Alerts! Get questions and answers delivered to your Inbox.


E-mail me updates on this question



   SUBSCRIBE

hidden modal window

Answer Wiki (Improve, edit or add to this answer)


 RATE THIS ANSWER
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
  • AddThis Social Bookmark Button

Browse more Questions and Answers on Development.

Looking for relevant Development Whitepapers? Visit the SearchSQLServer.com Research Library.


Discuss This Answer


You must be logged-in to discuss a question. Log-in/Register