How to dynamically add a new column to an SfDataGrid that gets it's values from a dictionary

[Daniel Neve]

I want to display a table of data. Each row is an instance of my class "Fruit", each column is a date.

Sort of like this:

	01/01/2016	02/01/2016	03/01/2016	04/01/2016	05/01/2016	06/01/2016	07/01/2016	08/01/2016
Apple	123	456	789	987	654	321	123	456
Orange	789	987	654	321	123	456	789	987

I can store the data however is needed, but both the number of columns and rows is variable.

My hope is that the simplest solution is that I store the data as a Dictionary<DateTime, int> (or perhaps as Dictionary<string, int>) as a child property of Fruit, and set a MappingName along the lines of "FruitDict[01/01/2016]" when adding a new column to display that particular date.

[Jai Ganesh S]

Hi Daniel,

Yes. You can achieve your requirement using Dictionary type is one of the underlying collection property and display the value in column as mentioned your update.  We have prepared the sample based on this and you can download the sample from the below location,

Code Example: Add Column from XAML

<Syncfusion:GridTextColumn MappingName="dictionary[03/01/2016]" HeaderText="03/01/2016"    />

Code Behind:

private void Button_Click(object sender, RoutedEventArgs e)

        {

            this.datagrid.Columns.Add(new GridTextColumn() { MappingName = "dictionary[04/01/2016]", HeaderText = "05/01/2016" });
        }

Sample: http://www.syncfusion.com/downloads/support/directtrac/147512/ze/SfGridDemo-1612589586

Regards,
Jai Ganesh S

[Pavel]

Hi, how can i get this example?

[Balamurugan Thirumalaikumar]

Hi Pavel, 

Thank you for interesting in Syncfusion products. 

You can download the sample from following link. 

Sample link - https://www.syncfusion.com/downloads/support/directtrac/general/ze/NoRowColumnSizing_c0ab1cfe_(2)-678701226.zip 

Thanks & Regards, 

Balamurugan Thirumalaikumar  

  

[Ramesh Mahadevan (RBEI/EDC1)]

Hello,

How can I download this sample. I get Access denied message

Thanks

[Dhanasekar Mohanraj]

Ramesh Mahadevan,

We regret the inconvenience caused,

Here you can get the requested sample.

Attachment: SfGridDemo1612589586_25678f2b.zip