Help with using one grid to switch between two different data sources!

Question

I made an app that displays data in a data grid from local xml files. What I want to do is be able to select another data source from a drop down box that will display in the same grid, but not at the same time. The second source is coming from a remote server. Basically, right now i have two separate apps that i want to combine into one app. I have code for both but now i am having trouble combining the two. Let me know if you have any suggestions. Also let me know if seeing source code will help. Thanks

Manikavelu Velayutham · Answer

only thing that should be considered here is the two data sources should be of same schema based on the grid view. If its a autogenerated columns no issues. If the grid has no autogenerated columns data item in the grid should match with the two data sources. On button click event you can bind the second data source to that grid. hope you understood let me know if you need further information

Bradley George · Answer

Ok I have 2 data sources. One data source is displayed on the grid by default. What I want to do is bind the other data source on the same grid when I click on a button in the gui. So 1 grid that is shared. I do not want the two data sources to be used at the same time. So when I click on the button the grid populated only the second data source. Any ideas on how to do this? Thanks

Suthish Nair · Answer

Hi George Welcome to C# Corner.. Please provide more information about data structure same grid etc. If same you can do as per Mani saie.

Manikavelu Velayutham · Answer

Do you want to merge the two data source and display it in single grid ? If so both the data source should have same columns. DataTable.Merge --> this method is used to merge the two data tables having the same schema. let me know If my understanding is wrong.