DataGrid view with combobox

Question

i have a form that created using C# 2010. in this there is a combo box called "cmbDept" and datagrid view name is "DataGrideView" i just need to populate data from my SQL 2008 data base (HRM) table (NewEmp) according to selection is made by my combo box (cmbDept).
this combo box have values (All, Philips Division, Power Tool, Wipro). my table have values (EmpID, Name, ContactNo, Post, Department)
you can click the attachment to see real look of my interface.
Pls in advance...

Thanks to you for your commitment

SUNIL GUTTA · Answer

Hi there Create SP like this @ DB level . Create Proc spempinfo @dept nvarchar(50) as begin select empid name contactnopost from newEmp where department=@dept end Later use SP with ADO classes as you may know how .. Pass the combo Box selected input as Input parameter to SP which will fetch data and load the data to Data set using adapter & fill method and finally Bind it with Grid View to display data according to your requirement . Other way is Bring everything into dataset and later do modifications on Dataset Regards Sunil G

Satyapriya Nayak · Answer

http://www.c-sharpcorner.com/Blogs/9630/