combobox depending on another combobox

Question

Hi everybody I need your help. I have a Excel Spreadsheet which i use for my programm. I have 4 combobox. The fisrt one show AAAA & BBBB If AAAA selected the second show aaaa &bbbb if aaaa selected the third show 1111&1112....... I don't want to use database so if you have an other solution for my problem I tried Dictionnary but it doesn't work. Sorry for my English i'm French Thanks

Amit Gupta · Answer

Hey You can make use of DataTable to get your desired result 1. Load your excel sheet into a DataTable 2. Bind your first column to your combobox 3. On combobox selection changed event fetch it from the Datatable.Select event this will return your the DataRows[] 4. Rebind this DataRows[] to your next combobox 5. Thats it Good Luck

Pierre MERCIER · Answer

I will try it thanks for your answer Amit