select combobox value and display releted combobox value

Jigar Patel

hello everyone,
i am creating visual c# desktop application.
i have two table 1) Department Master
dept_id int primarykey,
dept_name varvhar(50).
another table is below:-
2) Contactperson Master
cont_id int primarykey,
dept_id int,
cont_name varchar(50).

now in windows form I put Two Different Combobox like, department combobox and contactperson combobox.
now when I select departmentname from department combobox then the releted data of contact person will show in contactpersonmaster.
pls help me.

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Bikesh Srivastava10y ago
Hi,
Visit on this link ,
you will found proper solution.
http://www.c-sharpcorner.com/UploadFile/009464/cascading-combobox-in-windows-application-using-C-Sharp/
0

Vasanth Natarajan10y ago

Hi Try This...

Everycontactperson have dept_id so simply send the dept id to get thecontactperson for thatcontactperson Master.

Combobox

department .SelectionChanged += new SelectionChangedEventHandler(department _SelectionChanged);

void department_SelectionChanged(object sender, SelectionChangedEventArgs e) 
{     
   comboBox2.DataSource = contactperson_master;//get the below query data
 comboBox2.DisplayMember="cont_id"; 
 comboBox2.ValueMember="cont_name";

}

Query

selectcont_id,cont_name from Contactperson_Master where dept_id=from_dept_master_selected_dept_id

Rajeesh Menoth10y ago
Hi,

You can use Cascading ComboBox In Winforms .

Please check the following reference :

http://www.c-sharpcorner.com/UploadFile/009464/cascading-combobox-in-windows-application-using-C-Sharp/

http://csharpdotnetfreak.blogspot.com/2012/07/cascading-combobox-in-winforms-windows-forms.html
0