Hi,
I have an access db with say 20 tables and a radDropDownList showing them. On the event SelectedIndexChanged of the radDropDownList I would like to reconstruct radGrid layout so that the radGrid now reflects the selected table and its data.
It would be like simulating ms Access but not needing access installed and being able to make a few minor data changes.
Does anyone have something like this they care to share?
Thanks,
Karl
I have an access db with say 20 tables and a radDropDownList showing them. On the event SelectedIndexChanged of the radDropDownList I would like to reconstruct radGrid layout so that the radGrid now reflects the selected table and its data.
It would be like simulating ms Access but not needing access installed and being able to make a few minor data changes.
Does anyone have something like this they care to share?
Thanks,
Karl
1 Answer, 1 is accepted
0
Hi Karl,
Thank you for writing.
One scenario to achieve this is to fill a DataSet with all the tables from the access database and use the data set to bind the grid and drop down. When the user is done editing you can commit the changes back into the database. The provider you use to read/write the data from/to the database is up to you. Once you have the DataSet set up, you can bind the drop down list to the tables collection of the data set. On the SelectedIndexChanged event of the drop down you should bind the grid to a different table from the data set. Please find attached a sample project where I create a DataSet with two tables and mimic the scenario you have described.
I hope you will find this useful. If you have further questions, I would be glad to help.
All the best,
Ivan Petrov
the Telerik team
Q3’11 of RadControls for WinForms is available for download (see what's new). Get it today.
Thank you for writing.
One scenario to achieve this is to fill a DataSet with all the tables from the access database and use the data set to bind the grid and drop down. When the user is done editing you can commit the changes back into the database. The provider you use to read/write the data from/to the database is up to you. Once you have the DataSet set up, you can bind the drop down list to the tables collection of the data set. On the SelectedIndexChanged event of the drop down you should bind the grid to a different table from the data set. Please find attached a sample project where I create a DataSet with two tables and mimic the scenario you have described.
I hope you will find this useful. If you have further questions, I would be glad to help.
All the best,
Ivan Petrov
the Telerik team
Q3’11 of RadControls for WinForms is available for download (see what's new). Get it today.