This is a migrated thread and some comments may be shown as answers.

Can I bind List of Dictionary<string,object> to RadGridView?

12 Answers 2399 Views

GridView

This is a migrated thread and some comments may be shown as answers.

12 Answers, 1 is accepted

answered on 15 Apr 2016, 08:10 AM

Hello Tuan,

Thank you for writing.

If each dictionary contains only one entry there is no point to add the dictionary objects to a list. You can directly bind the grid to the dictionary. For example:

var data = new Dictionary<string, MyObj>();

for (int i = 0; i < 20; i++)

{

data.Add(i.ToString(), new MyObj { Name = "Name " + i, Age = 30 });

}

radGridView1.DataSource = data;

This way the grid will display the Key and the Value in each row (those are the properties of the dictionary entry object).

If you want to display you custom business object properties you should bind the grid to a list of objects. For example:

public partial class RadForm1 : Telerik.WinControls.UI.RadForm

{

public RadForm1()

{

InitializeComponent();

var data = new List<MyObj>();

for (int i = 0; i < 20; i++)

{

data.Add( new MyObj { Name = "Name " + i, Age = 30 });

}

radGridView1.DataSource = data;

}

class MyObj

{

public string Name { get; set; }

public int Age { get; set; }

}

If this does not help could you please share the exact way that you are initializing your data structure (use some sample data), and perhaps you can specify how exactly you expect the grid to look like.

I am looking forward to your reply.

Regards,
Dimitar
Telerik

Do you need help with upgrading your AJAX, WPF or WinForms project? Check the Telerik API Analyzer and share your thoughts.

answered on 19 Apr 2016, 04:32 AM

Dear Dimitar,

I add sample code as below.

Thank for your reply.

Regards,

Tuan

------------------

private void InitializeGrid()
{
// Turn on the column auto generation, depend on return data from service.
this.radGridView1.AutoGenerateColumns = true;

// Setup grid's data. This is just simulation the return data from WebAPI service
//BindingList<Dictionary<string, object>> models = new BindingList(service.GetPersonalData())
BindingList<Dictionary<string,object>> models = new BindingList<Dictionary<string, object>>();

string[] names = new string[] { "ROOT", "Mark", "Piet", "Herre", "Ronald", "John", "Michael" };
Random rand = new Random();

for (int i = 0; i < 1000; i++)
{
Dictionary<string, object> row = new Dictionary<string, object>();

row["Id"] = i + 1;
row["Name"] = names[rand.Next(names.Length)];
row["Age"] = rand.Next(100);
row["Active"] = false;

models.Add(row);
}

// Bind return data to grid
this.radGridView1.DataSource = models;
}

Accepted

answered on 19 Apr 2016, 09:47 AM

1027239.zip

Hi Tuan,

Thank you for writing back.

There is no way to directly display such data in RadGridView, however, you can use RadVirtualGrid for this case. I have attached a small sample to show you how this works. More information about this control is available in the following articles:

Let me know if you have additional questions.

Regards,
Dimitar
Telerik

Do you need help with upgrading your AJAX, WPF or WinForms project? Check the Telerik API Analyzer and share your thoughts.