With previous data source I want to set new DataSource to grid

[Shanti 😎]

HI,

I have set the data source in my grid view. When I add the next data source, I want the new data source add, not the existing data source to be cleared.

Append with previous. it's possible?

waiting for your favorable response.

Thanks

[Dess | Tech Support Engineer, Principal]

Hello, Tovino,

RadGridView supports data binding to a single DataSource collection at a time. If the AutoGenerateColumns property is set to true, the columns will be generated from the data source.

Every next setting to a new DataSource collection will re-generate the columns according to the columns available in this new DataSource. Appending with the previous DataSource is not expected to be supported.

The possible solution that I can suggest is to append the DataSource programmatically and then apply it to the RadGridView.DataSource property, e.g. if you have DataTable1 and DataTable2 you can create a third DataTable which contains the columns from both DataTable objects and populate the rows considering the cells from both tables.

I hope this information helps. If you need any further assistance please don't hesitate to contact me. 

Regards,
Dess | Tech Support Engineer, Sr.
Progress Telerik

[Shanti 😎]

Thank you!