在运行时将字典列表绑定到WPF DataGrid

问题描述

您好，我正在使用WPF和MongoDB进行一项任务.我需要在运行时从字典列表"< string，string>生成WPF DataGrid(其他任何控件都可以，如果可以的话).这是简单的集合Dictionary，其中每个Dictionary具有不同的密钥对集.

到目前为止，我已经能够在运行时从Dictionary< string，string>生成列.具有最高的列数.生成所有列之后，任务是将数据放入DataGrid并显示.

字典列表< string，string>当我尝试使用DataContext和DataGrid的ItemsSource时，每个字典中包含不同的列集，但它会生成空的网格.

请提供您的想法

Hello, I am working on one assignment using WPF and MongoDB. I need to generate WPF DataGrid(any other control will be fine if it works) at runtime from List of Dictionary<string,string>. This is simple collection Dictionary where each Dictionary has different set of keypairs.

So far i am able to generate columns at runtime from Dictionary<string,string> having highest number of columns. After generating all columns, task is to put data into DataGrid and display.

List of Dictionary<string,string> contains different set of columns in each dictionary when i tried using DataContext and ItemsSource of DataGrid but it generates empty gird.

Please provide your thoughts

推荐答案

public class KeyValueHolder
{
 public string Key {get;set;}
 public string Value {get;set;}
} 

.

但是有一点需要考虑，从本质上来说，ObservableCollection不是安全的！！

因此，我认为在您的情况下，实施主从方法比较合适((您将有2个数据网格:-首先是通用的，代表您的词典数量，其次是通过KeyValueHolder列表详细列出)

.

But one moment to consider, by it''s nature ObservableCollection is not Thraed-safe!!

So , in your scenario i think , would be prafarable to implements master-details approach,(you will have 2 datagrids: - first is general, represent number of your dictionaries, and second one is detailed by list of KeyValueHolder)

table = new DataTable();
            dgSearchResult.Columns.Clear();
            string broker = string.Empty;
            string producttype = string.Empty;
            string currency = string.Empty;
            string productsubtype = string.Empty;

            if (cmbProductTypes.SelectedValue != null)
                producttype = cmbProductTypes.SelectedValue.ToString();
            else
                producttype = "";

            if (cmbBrokers.SelectedValue != null)
                broker = cmbBrokers.SelectedValue.ToString();
            else
                broker = "";

            if (cmbProductSubtype.SelectedValue != null)
                productsubtype = cmbProductSubtype.SelectedValue.ToString();
            else
                productsubtype = "";

            if (cmbCurrency.SelectedValue != null)
                currency = cmbCurrency.SelectedValue.ToString();
            else
                currency = "";
//Sample is a list of dict of string string
            List<dictionary><string,string>> sample = Models.RateCards.GetCard(producttype,broker,productsubtype,currency);

            foreach (Dictionary<string,> d in sample)
            {
                foreach (string key in d.Keys)
                {
                    Addcolumn(key);
                }

            }

            foreach (Dictionary<string,> d in sample)
            {
                //Addrow(d);

                row = table.NewRow();
                foreach (KeyValuePair<string,> keyValue in d)
                {
                    if (table.Columns.Contains(keyValue.Key))
                    {
                        if (keyValue.Key != "XMLDefinition")
                        {
                            if (keyValue.Value.Contains(","))
                            {
                                //if (keyValue.Key == "Volume Band Rates" || keyValue.Key == "Premium Band Rates")
                                    row[keyValue.Key] = RemoveSpecialCharacters(keyValue.Value.Replace("}, ", "}" + System.Environment.NewLine).Replace(",", ";").Replace("{", "").Replace("}", "").Replace("[", "").Replace("]", "").Replace("''''", ""));
                                //else
                                //    row[keyValue.Key] = RemoveSpecialCharacters(keyValue.Value.Replace(",", ";").Replace("{", "").Replace("}", "").Replace("[", "").Replace("]", "").Replace("''''", ""));
                            }
                            else
                                row[keyValue.Key] = RemoveSpecialCharacters(keyValue.Value);
                        }
                        else
                            row[keyValue.Key] = keyValue.Value;
                    }
                }

                table.Rows.Add(row);

            }

            dgSearchResult.ItemsSource= table.DefaultView;

       }

       private static string RemoveSpecialCharacters(string str)
        {
            StringBuilder sb = new StringBuilder();
            foreach (char c in str)
            {
                if (c != ''"'')
                {
                    sb.Append(c);
                }
            }
            return sb.ToString();
        }

        private void Addcolumn(string columnname)
        {
            if (!table.Columns.Contains(columnname))
            {

                DataGridTextColumn dgColumn = new DataGridTextColumn();
                dgColumn.Header = columnname;
                dgColumn.Binding = new Binding(string.Format("[{0}]", columnname));
                dgColumn.SortMemberPath = columnname;
                dgColumn.IsReadOnly = true;

                dgSearchResult.Columns.Add(dgColumn);

                DataColumn dtcolumn = new DataColumn();
                dtcolumn.Caption = columnname;
                dtcolumn.ColumnName = columnname;

                table.Columns.Add(dtcolumn);
                if (columnname == "_id" || columnname == "XMLDefinition")
                    dgColumn.Visibility = Visibility.Hidden;

            }
        }</dictionary>

这篇关于在运行时将字典列表绑定到WPF DataGrid的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！