Click here to Skip to main content
15,894,343 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
i have database name emp_tracker in that i have cloumn name consultant in that i have list of consultant.i also have column status in that i maintain status as no of cv received,no of cv rejected.i want to show in gridview that all consultant name with there count means number of cv recceived and no of cv rejected in gridview
how can i show that in c# windows application like
consultant name,no of cv received,no of cv rejected in gridview
i dont have stored number in database just as when add candidate maintaing status as cv received,rejected,selected
Posted
Updated 25-Oct-12 2:17am
v2
Comments
Bhushan Shah1988 25-Oct-12 8:19am    
Please provide some sample data with script.
16041984 25-Oct-12 8:38am    
Consultant_Name
tcs
morphees
krutika



Status
InProcess
C V Sent
InProcess


how can i get in gridview count of cv received with consultant name
BlackMilan 25-Oct-12 8:59am    
Did you have a problem in C# or SQL?
16041984 26-Oct-12 0:46am    
yes i am not understand how to write query to display number of count with status in grid view.i m newbie
BlackMilan 26-Oct-12 9:20am    
Let's see your table definition, sample content and an understandable example of what you will get.

Sorry that I require so much work from you, but my fortune teller crystal sphere must be repaired.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900