遍历List<T>包含字典Dictionary和其他字段dataGridView绑定数据

解决WinForm中字典类型在dataGridView中显示问题
本文详细介绍了在使用WinForm时,如何处理并展示字典类型数据到dataGridView中,解决了单元格仅显示集合而不显示具体数据的问题。通过动态创建列名并正确绑定数据,实现了字典的Key和Value在dataGridView中的有效展示。

以前做WinForm接触的不多字典类型而且返回在List<T>中,在dataGridView绑定的时候遇到问题,单元格显示集合并不显示数据,在窗体上放一个dataGridView,

下面是类:

public class Certification
    {
        Dictionary<String, String> Descrribed;
        public Dictionary<String, String> Descrribed1
        {
            get { return Descrribed; }
            set { Descrribed = value; }
        }

        String CertificationStatus;
        public String CertificationStatus1
        {
            get { return CertificationStatus; }
            set { CertificationStatus = value; }
        }


        public Certification(Dictionary<String, String> _dic, String _status)
        {
            this.Descrribed1 = _dic;
            this.CertificationStatus1 = _status;
        }
    }


在窗体Load事件中加上

  动态创建列名:

           DataGridViewTextBoxColumn txtKey = new DataGridViewTextBoxColumn();

            txtKey.Name = "txtKey";

           txtKey.HeaderText = "txtKey";

            this.dataGridView2.Columns.Add(txtKey);


            DataGridViewTextBoxColumn txtValue = new DataGridViewTextBoxColumn();
            txtValue.Name = "txtValue";
            txtValue.HeaderText = "txtValue";
            this.dataGridView2.Columns.Add(txtValue);


            DataGridViewTextBoxColumn txtStatus = new DataGridViewTextBoxColumn();
            txtStatus.Name = "txtStatus";
            txtStatus.HeaderText = "txtStatus";
            this.dataGridView2.Columns.Add(txtStatus);

            泛型:
            List<Certification> l_Test = new List<Certification>();

Certification cer = new Certification();
            cer.Descrribed1 = new Dictionary<String, String>();
            cer.Descrribed1.Add("123", "aaa");
            cer.Descrribed1.Add("456", "bbb");
            cer.Descrribed1.Add("789", "ccc");
            
            cer.CertificationStatus1 = "离开";
            cer.CertificationStatus1 = "在线";
            cer.CertificationStatus1 = "忙碌";
            l_Test.Add(cer);
      

           绑定数据:

this.dataGridView2.Columns["txtKey"].DataPropertyName = "Descrribed1";               
                this.dataGridView2.Columns["txtStatus"].DataPropertyName = "CertificationStatus1";

this.dataGridView2.DataSource = l_Test;

   显示效果:

                

              不能显示dictionary的Key和Value

              最后用循环处理,但是数据量大不好处理:

泛型添加数据:

Dictionary<String, String> dicDescribe = new Dictionary<String, String>();
            dicDescribe.Add("标题", "描述");
            Dictionary<String, String> dicName = new Dictionary<String, String>();
            dicName.Add("名称", "内容");
            
            l_Test.Add(new Certification(dicDescribe, "离开"));
            l_Test.Add(new Certification(dicName, "忙碌"));
            l_Test.Add(new Certification(null, "在线"));
 

循环写入数据:

            String sKey = String.Empty;
            String sValue = String.Empty;
            int nRow = 0;
            
            foreach (Certification l_cer in l_Test)
            {

               //添加行
                DataGridViewRow dbRow = new DataGridViewRow();
                this.dataGridView2.Rows.Add(dbRow);
                String sStatus = l_cer.CertificationStatus1.ToString();
                if (l_cer.Descrribed1 != null)
                {
                    foreach (KeyValuePair<String, String> item in l_cer.Descrribed1)
                    {
                        sKey = item.Key.ToString();
                        sValue = item.Value.ToString();
                    }
                }
                else
                {
                    sKey = "";
                    sValue = "";
                }
                this.dataGridView2.Rows[nRow].Cells[0].Value = sKey;
                this.dataGridView2.Rows[nRow].Cells[1].Value = sValue;
                this.dataGridView2.Rows[nRow].Cells[2].Value = sStatus;
                nRow++;
            }    

显示:

各位老大谁有更好的办法处理?

简化下树形菜单加载的代码【 /// <summary> /// 加载数据初始化 /// </summary> private void LoadShowtab() { //dataGridView绑定 table.TableName = "DocData"; table.Columns.Add("DocID"); table.Columns.Add("DocName"); table.Columns.Add("DocAuto"); table.Rows.Add(Guid.NewGuid().ToString("N"), "激活", "未绑定列"); table.Rows.Add(Guid.NewGuid().ToString("N"), "未激活", "未绑定列"); dataGridView1.AutoGenerateColumns = false; dataGridView1.DataSource = table; //下拉框绑定 comboBox1.DataSource = table; comboBox1.ValueMember = "DocID"; comboBox1.DisplayMember = "DocName"; //listview成组 listView1.View = View.Details; listView1.ShowGroups = true; listView1.FullRowSelect = true; listView1.Groups.Add(new ListViewGroup("技术部", HorizontalAlignment.Left)); listView1.Groups.Add(new ListViewGroup("市场部", HorizontalAlignment.Left)); listView1.Columns.Clear(); listView1.Columns.Add("姓名", 120); listView1.Columns.Add("年龄", 80); listView1.Columns.Add("11", 80); ListViewItem item = new ListViewItem(new[] { "1","2","3"}); var group = listView1.Groups.Cast<ListViewGroup>().FirstOrDefault(g => g.Header == "技术部"); if (group != null) { item.Group = group; } listView1.Items.Add(item); //树形菜单递归 trees = new List<treeViewClass>() { new treeViewClass{父节点="A0",节点="A1",Name="食物" }, new treeViewClass{父节点="A1",节点="A_1",Name="馒头" }, new treeViewClass{父节点="A1",节点="A_2",Name="面" }, new treeViewClass{父节点="B0",节点="B1",Name="水果" }, new treeViewClass{父节点="B1",节点="B1_1",Name="榴莲" }, new treeViewClass{父节点="B1_1",节点="B1_2",Name="榴莲核" }, }; // 构建父节点字典(Key为父节点ID,Value为子节点集合) var parentDict = trees .GroupBy(t => t.父节点) .ToDictionary( g => g.Key, g => g.ToList() ); var allNodeIds = new HashSet<string>(trees.Select(t => t.节点)); var trees_ = trees.Where(t => !allNodeIds.Contains(t.父节点)); // 添加根节点(父节点不在所有节点中的项) foreach (var rootItem in trees_) { TreeNode rootNode = new TreeNode(rootItem.Name) { Tag = rootItem.节点 }; treeView1.Nodes.Add(rootNode); BuildChildNodes(rootNode, parentDict); } } private void BuildChildNodes(TreeNode parentNode, Dictionary<string, List<treeViewClass>> parentDict) { var currentId = parentNode.Tag?.ToString(); if (string.IsNullOrEmpty(currentId)) return; if (parentDict.TryGetValue(currentId, out var children)) { foreach (var child in children) { TreeNode childNode = new TreeNode(child.Name) { Tag = child.节点 }; parentNode.Nodes.Add(childNode); BuildChildNodes(childNode, parentDict); // 递归构建子树 } } }】
04-01
private void btnSaveIm_Click(object sender, EventArgs e) { if (gvDataIm.Rows.Count == 0) return; bindingNavigator1.Enabled = false; Dictionary<string, string> saveInfor = new Dictionary<string, string>(); for (int i = 0; i < gvDataIm.RowCount; i++) { saveInfor.Clear(); for (int j = 0; j < gvDataIm.Columns.Count; j++) { saveInfor.Add(gvDataIm.Columns[j].Name, gvDataIm.Rows[i].Cells[j].Value.ToString()); } try { string tempMsg; var keylist = saveInfor.Keys.ToArray(); bool flagCheckSql = true; for (int j = 0; j < saveInfor.Count; j++) { //检查非空checksql if (!CheckItemData(keylist[j], saveInfor[keylist[j]], out tempMsg)) { showMsg(keylist[j] + tempMsg); flagCheckSql = false; break; } } if (!flagCheckSql) { break; } string msg; bool DoubleFlag = false; if (!_ctrl.CheckSaveInforDouble(saveInfor, "Append", null, out string DoubleMsg)) { DoubleFlag = true; } //这里因为要用breakcontinue来跳过或者打断for循环,所以不能用switch,否则逻辑会冲突 if (MParams.menuListModelCurrent.OPTION1 == "导入重复覆盖") { if (!_ctrl.SaveInfor(saveInfor, "Import", null, out msg)) { showMsg("第" + (i + 1) + "行导入失败:" + msg); break; } else { if (DoubleFlag) { showMsg("第" + (i + 1) + $"行导入成功,数据重复已覆盖:{DoubleMsg}"); } else { showMsg("第" + (i + 1) + "行导入成功。"); } } } else if (MParams.menuListModelCurrent.OPTION1 == "导入重复中断") { if (DoubleFlag) { showMsg("第" + (i + 1) + $"行数据重复已中断导入:{DoubleMsg}"); break; } else { if (!_ctrl.SaveInfor(saveInfor, "Import", null, out msg)) { showMsg("第" + (i + 1) + "行导入失败:" + msg); break; } else { showMsg("第" + (i + 1) + "行导入成功。"); } } } else if (MParams.menuListModelCurrent.OPTION1 == "导入重复跳过") { if (DoubleFlag) { showMsg("第" + (i + 1) + $"行数据重复已跳过该行:{DoubleMsg}"); continue; } else { if (!_ctrl.SaveInfor(saveInfor, "Import", null, out msg)) { showMsg("第" + (i + 1) + "行导入失败:" + msg); break; } else { showMsg("第" + (i + 1) + "行导入成功。"); } } } else { if (!_ctrl.SaveInfor(saveInfor, "Import", null, out msg)) { showMsg("第" + (i + 1) + "行导入失败:" + msg); break; } else { if (DoubleFlag) { showMsg("第" + (i + 1) + "行导入成功,数据重复已覆盖"); } else { showMsg("第" + (i + 1) + "行导入成功。"); } } } } catch (Exception ee) { showMsg("第" + (i + 1) + "行导入失败:"+ ee.Message); break; } } }
最新发布
07-10
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

hefeng_aspnet

你的鼓励将是我创作的最大动力

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付:¥1
获取中
扫码支付

您的余额不足,请更换扫码支付或充值

打赏作者

实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值