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

Multidimensional array (or similar) as ItemsSource

16 Answers 958 Views

GridView

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

This question is locked. New answers and comments are not allowed.

16 Answers, 1 is accepted

answered on 21 Apr 2009, 03:28 PM

Hello Francesco,

You can use List<Dictionary<string, object>> as ItemsSource:

XAML

    
            <UserControl x:Class="SilverlightApplication1.Page" 
        
                xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"  
        
                xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"  
        
                xmlns:telerik="clr-namespace:Telerik.Windows.Controls;assembly=Telerik.Windows.Controls.GridView"> 
        
                <Grid> 
        
                    <telerik:RadGridView x:Name="RadGridView1" IsReadOnly="True" AutoGenerateColumns="False" /> 
        
                </Grid> 
        
            </UserControl>

    
            using System; 
        
            using System.Collections.Generic; 
        
            using System.Linq; 
        
            using System.Net; 
        
            using System.Windows; 
        
            using System.Windows.Controls; 
        
            using System.Windows.Documents; 
        
            using System.Windows.Input; 
        
            using System.Windows.Media; 
        
            using System.Windows.Media.Animation; 
        
            using System.Windows.Shapes; 
        
            using System.Xml.Linq; 
        
            using System.Collections; 
        
            using System.Windows.Data; 
        
            using Telerik.Windows.Controls; 
        
            namespace SilverlightApplication1 
        
            { 
        
                public partial class Page : UserControl 
        
                { 
        
                    public Page() 
        
                    { 
        
                        InitializeComponent(); 
        
                        List<Dictionary<string, object>> source = new List<Dictionary<string, object>>(); 
        
                        for (int i = 0; i < 100; i++) 
        
                        { 
        
                            Dictionary<string, object> item = new Dictionary<string, object>(); 
        
                            for (int j = 0; j < 10; j++) 
        
                            { 
        
                                item[String.Format("Column{0}", j)] = String.Format("Cell {0} {1}", i, j); 
        
                            } 
        
                            source.Add(item); 
        
                        } 
        
                        for (int i = 0; i < 10; i++) 
        
                        { 
        
                            string propertyName = String.Format("Column{0}", i); 
        
                            GridViewDataColumn column = new GridViewDataColumn(); 
        
                            column.DataMemberBinding = new Binding() { Converter = new MyConverter(), ConverterParameter = propertyName }; 
        
                            column.HeaderText = propertyName; 
        
                            RadGridView1.Columns.Add(column); 
        
                        } 
        
                        RadGridView1.ItemsSource = source; 
        
                    } 
        
                } 
        
                public class MyConverter : IValueConverter 
        
                { 
        
                    #region IValueConverter Members 
        
                    public object Convert(object value, Type targetType, object parameter, System.Globalization.CultureInfo culture) 
        
                    { 
        
                        return ((Dictionary<string, object>) value)[(string) parameter]; 
        
                    } 
        
                    public object ConvertBack(object value, Type targetType, object parameter, System.Globalization.CultureInfo culture) 
        
                    { 
        
                        throw new NotImplementedException(); 
        
                    } 
        
                    #endregion 
        
                } 
        
            }

All the best,
Vlad
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.

answered on 23 Apr 2009, 07:56 PM

Vlad,

I found a solution that works in our case. It's not very straightforward but it does the job. The idea is to create the type at runtime, add a property for each one of my column and then (using reflection) create a list of these objects with my data.

something like this:
myData = array[n columns][ i rows]
Type tempType = [create a type with n properties ("column_0", "column_1", etc.)]
foreach row in myData
create an object of type TempType filling the properties column_0, column_1,etc. with myData[n][i], add the object to a list
set this list as itemsSource of the grid.

It works beautifully (and isn't even so slow), the only issue is that native sorting and grouping does not work, the grid seems to be unable to assign the CellItemType property (is this the right name? I don't have the code here right now), so it doesn't find the properties that define each column and cannot perform the sort/grouping. Probably it depends on the way the gridView looks for the properties in each row.
In practice the dataGrid thinks that each row is a System.Object instead of TempType, so it doesn't find the properties column_0, column_1, etc.

Sorting is not really a problem as I can use a custom sort, but for grouping I can't make it work.

Maybe if I post a small sample project you can give it a look and tell me if there is a way to perform grouping?

Thanks,
Francesco

Accepted