combo box control

Question

Thank you for your services. Keep it up. Please. I have a related table in my Mysql database. Members table and memberstatus table. The memberstatus table is a foreign key in the members table. Please help me out. How do i set a combo box showing the memberstatus such that when i select a status in the combo box it will show records of all members that are 'active' 'resigned' 'dismissed' 'demised'. Thank you.

Chetan Ranpariya · Answer

The logic would be You retrieve all the rows from memberstatus table and bind them to ComboBox. Set DateMember and ValueMember properties of ComboBox while binding it to the datasource. Attach an event handler to Combobox's seletedIndexchanged event. In the event handler you retrive the selected memberstatusid from the ComboBox.SelectedItem.Value; Query your database to get all the rows from members table where memberstatusid = selectedmemberstatusid. Assign retrieved data as a datasource to the datagridview. There can be multiple ways to retrive data from the db and bind it to the control. 1. Retrive data using query and DataTable. 2. Retrive data using query and create List of MemberStatus class and populate the list using the data retrived from the database. I hope this would help you complete your task. Let me know if any thing is not clear. Thanks and regards Chetan Ranpariya

Chetan Ranpariya · Answer

Hi You can use SelectedIndexChanged event for this. You need to attach an event handler to this event. http://csharp.net-informations.com/gui/cs-combobox.htm This link wil help you understand more about the event. Thanks and regards Chetan Ranpariya

Chetan Ranpariya · Answer

Hi I won't help you with the ready-made code. I will send you the logic of how to achieve this functionality. Then it will be Metter of just implementing in code. Thanks and regards Chetan Ranpariya

Ikechukwu Daniel · Answer

Thank you for your reply. Please this is actually what i mean. I have two tables in mysql database. Members table and Memberstatus table. The members table contains all the details of the members of an organisation and the Memberstatus table contains their status such as 'active' 'resigned' 'dismissed'. Now i have made the Memberstatus Id a foreign key in the Members table. Also i have made a dataset for it. So i want to know how to drop a combox in my C# form such that when i select a value in the combo box it will display all the members details in a datagrid view . Thanks