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

Bradley George

15y15.9k

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

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Manikavelu Velayutham15y ago
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 George15y ago
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 Nair15y ago
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 Velayutham15y ago
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.