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