i have database name emp_tracker in that i have column 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
for e.g
Consultant_Name
tcs morphees krutika
Status
InProcess C V Sent InProcess
how can i get in gridview count of cv received with consultant name