Datagridview combobox data binding by another combox selected item

Question

Hi I have a datagirdview with two combo box columns. for example country and city. If I selected country combox in datagridview the city combobox column have to bind based on the selected county. I can able to get the selected country value. I have to bind the city combobx column. Thanks in advance. Regards Anil

Maneesh · Answer

Hi Amit My main project has a database made in Access 2007 with the following tables: pastors and village codes. It has a Pastors table (Parent Table) which contains a list of of pastors and a VillCODES (Child) Table which contains details of the ministry of each pastor. The Pastors (Parent) table has the following fields: PastorID DistrictID Name Sex Phone Email Address The VillCODES (Child) table has the following fields: ID PastorID DistrictID Church DISTRICT BLOCK VillCODE VillName etc among other fields. The Pastors (Parent) table and the VillCODES(Child) table are related to each other on the PastorID field which is an AutoNumber field. I am able to display data from the Pastors (Parent) table as Details View dragged from the DataSource Window. But for the VillCODES (Child) table I am trying to display as a DataGridView control. Inside the DataGridView control I want to implement the functionality so that the user can add multiple villages (rows) where a Pastor works. As there are thousands of villages with thousands of villageID's called VillCODES I want the user to add rows like the following: The user wants to add more villages where the pastor works. The user first selects the DISTRICT from the DISTRICT ComboBoxColumn (this ComboBox should be populated with the names of the Districts). BASED on the selection made in the DISTRICT ComboBoxColumn the next BLOCK ComboBoxColumn gets filled with the list of names of BLOCKS ONLY belonging to this particular DISTRICT. The user selects one BLOCK from the BLOCK ComboBoxColumn and BASED on the selection from this ComboBox the VillNames ComboBoxColumn gets filled with the list of names of all village names which are a part of this particular BLOCK. The user makes a selection of one village name from the VillName ComboBoxColumn and the BASED on the selection made in this ComoBox the VillCODES TextBox (Read only textbox) fills with the correct Village code. I have attached a shot of the form here: Like this the user can keep adding as many villages for a particular pastor as one would continue to add Orders for a Customer. When all villages have been added the user presses the Save button on the Navigationbar and this would update all the related child records in the database. Can you please help me how to set this up and do this using Visual Basic 2008 Express Edition ? Kind Regards Maneesh maneeshmassey@gmail.com

elizabeth mwashuma · Answer

i am mwashuma from kenya...am curently faced with a similar problem...i hope i will find help from you amit. i have a datagridview with 3comboboxes. i want to filter the second column based on the value selected in column 1. take the following scenario. the first column is populated with continent names.the second with country names and the third with cities names. what code will i use so that wen a continent say Europe is selected then the country's in Europe shall be populated only and the cities of the country selected shall be populated in the third column. then another thing i am using c# and sql server 2005. on the code you have provided above it contains a statement that brings an error..... string t2 = TaskMDataGridView.Item[ CategoryCol  e.RowIndex].Value.ToString ; ... does not contain definition for item thats the error i am getting. hope to you here from you soon...thanks in advance

Amit Choudhary · Answer

hi friend SubCatCol and FilterSubCatBSource are GridViewComboBox names/ID's. Don't get confuse with few lines of code and be confident while doing programming you'll get what you want. Cheers

Anil · Answer

Hi Amit Thanks. I'm new windows application. Please let me know what is SubCatCol and FilterSubCatBSource. I Can able to get the values don't know to bind to combox box. Regards Anitha

Amit Choudhary · Answer

hi friend i got a solution of your problem any how.. you have to add two events of grid view and then you can change the values in one combo box on the basis of selection of another combo box. see below code: private void TaskMDataGridView_CellBeginEdit( object sender System.Windows.Forms.DataGridViewCellCancelEventArgs e) { if ((TaskMDataGridView.Columns[e.ColumnIndex].Name == CategoryCol )) { string t2 = TaskMDataGridView.Item[ CategoryCol  e.RowIndex].Value.ToString ; SubCatCol.DataSource = FilterSubCatBSource ; FilterSubCatBSource.Filter = ( Cat_ID =  + t2) ; } } private void TaskMDataGridView_CellEndEdit( object sender System.Windows.Forms.DataGridViewCellEventArgs e) { if ((TaskMDataGridView.Columns[e.ColumnIndex].Name == CategoryCol )) { object t3 ; AsString = TaskMDataGridView.Item[ CategoryCol  e.RowIndex].Value.ToString ; SubCatCol.DataSource = FilterSubCatBSource ; FilterSubCatBSource.RemoveFilter() ; } } Please mark as answer if it helps