代码增加表头

该篇文章详细描述了如何使用DevExpress的SearchLookUpEdit控件进行数据源绑定,包括设置默认值、填充列、设置列属性、数据源和显示选项。同时展示了如何创建TreeList的列并填充数据。
摘要由CSDN通过智能技术生成
 SearchLookUpEdit

        public void compBindSource()
        {

            txt_wtcomp.EditValue = null; ;//清空数据源
                                          //下拉框和数据库的实现


                                                                                                            //默认值
            txt_wtcomp.Properties.NullText = "------请选择------";
        
            是否显示底部
             txt_wtcomp.Properties.ShowFooter = false;
 
            //填充列

          
            txt_wtcomp.Properties.View.PopulateColumns();
            txt_wtcomp.Properties.View.Columns.Add(new GridColumn { FieldName = "wtcompid", VisibleIndex = 1, Caption = "id", } );
            txt_wtcomp.Properties.View.Columns.Add(new GridColumn { FieldName = "wtcompname", VisibleIndex = 1, Caption = "类别代码", });



            //设置列属性


            DataTable dt = wtcompSER.QueryTABwtcomp().Tables[0];
            txt_wtcomp.Properties.DataSource = dt;
            txt_wtcomp.Properties.DisplayMember = "wtcompname";
            txt_wtcomp.Properties.ValueMember = "wtcompid";
            // txt_wtcomp.Properties.View.EndInit();


            //txt_wtcomp.Properties.View.Columns[1].Width = 120;
            // txt_wtcomp.Properties.View.Columns[0].DisplayFormat.FormatString = "000000";//列格式设置

            下拉框自适应宽度
            //  txt_wtcomp.Properties.BestFitMode = DevExpress.XtraEditors.Controls.BestFitMode.BestFitResizePopup;
            // txt_wtcomp.Properties.View.BestFitColumns();

            或者设置总宽度
            // txt_wtcomp.Properties.PopupFormWidth = 500;//或者设置总宽度
            //txt_wtcomp.Properties.TextEditStyle = TextEditStyles.Standard;
            选择第一项
            txt_wtcomp.Properties.View.SelectRow(0);
             txt_wtcomp.Properties.View.EndUpdate();
            txt_wtcomp.Properties.View.BestFitColumns();
            txt_wtcomp.Properties.ShowFooter = false;
            txt_wtcomp.Properties.View.OptionsView.ShowAutoFilterRow = true; //显示不显示grid上第一个空行,也是用于检索的应用
            txt_wtcomp.Properties.View.OptionsFilter.AllowFilterEditor = false;
            //txt_wtcomp.Properties.CustomizeAutoCompleteSource = false;
            txt_wtcomp.Properties.ImmediatePopup = true;
            txt_wtcomp.Properties.PopupFilterMode = DevExpress.XtraEditors.PopupFilterMode.Contains;
            txt_wtcomp.Properties.TextEditStyle = DevExpress.XtraEditors.Controls.TextEditStyles.Standard; //配置,用于像文本框




        }

treelist
  

  private void CreateColumns(TreeList tl)
        {
            //RepositoryItemComboBox cbbEnd = new RepositoryItemComboBox();
            //DataTable dt = unitSER.QueryTABunit().Tables[0];
            //cbbEnd.Items.Clear();
            //foreach (DataRow item in dt.Rows)
            //{
            //    string str = item["unit_name"].ToString();
            //    string strID = item["unit_id"].ToString();
            //    cbbEnd.Items.Add(str);
            //}

            // Create three columns.
            //tl.BeginUpdate();
            tl.Columns.Add();
            tl.Columns[0].Caption = "id";
            tl.Columns[0].VisibleIndex = 0;
            tl.Columns[0].FieldName = "id";

            tl.Columns.Add();
            tl.Columns[1].Caption = "样品名称";
            tl.Columns[1].VisibleIndex = 1;
            tl.Columns[1].Width = 150;

            //tl.Columns.Add();
            //tl.Columns[2].Caption = "试验称";
            tl.Columns[0].FieldName = "id";
            //tl.Columns[2].VisibleIndex = 2;
            //tl.Columns[2].Width = 30;


            // // 添加根节点
            // TreeListNode root = tl.AppendNode(null, null);
            // root.SetValue("Name", "Root Node");
            // root.Tag = "root";

            // // 添加子节点
            // TreeListNode child = tl.AppendNode(null, root);
            // child.SetValue("Name", "Child Node");

             tl.PopulateColumns();//加这一句

            List<ypkuZD> Tzl = ypkuSER.Getmoreypku();

            for (int s = 0; s < Tzl.Count; s++)
            {
                TreeListNode node2 = tl.AppendNode(null, null);
                node2.SetValue(tl.Columns[0], Tzl[s].ypku_id);
                node2.SetValue(tl.Columns[1], Tzl[s].ypku_bigname + "[" + "]");
                node2.Tag = Tzl[s].ypku_id;
                //node2.SetValue(treeList1.Columns[2], Tzl[s].yptest_price);
                //node2.SetValue(treeList1.Columns[3], "0");
                /*

                //设置第二层
                List<yptestkuzxmZD> szl = yptestkuzxmSER.Getmoreyptestkuzxmbyt(Tzl[s].yptestku_id.ToString());

                for (int t = 0; t < szl.Count; t++)
                {

                    //设置第三层
                    TreeListNode node3 = treeList1.AppendNode(test, node2);
                    node3.SetValue(treeList1.Columns[0], szl[t].yptestkuzxm_id);
                    node3.SetValue(treeList1.Columns[1], szl[t].yptestkuzxm_name);
                    node3.SetValue(treeList1.Columns[2], szl[t].yptestkuzxm_price);
                    node3.Tag = "1";

                }

                */

            }




            tl.Columns[0].Visible = true;
            // tl.OptionsView.ShowCheckBoxes = true; //是否显示CheckBox
            tl.RowHeight = 20;
            tl.ExpandAll();
            tl.Columns[1].OptionsColumn.ReadOnly = true;
            tl.Columns[1].OptionsColumn.AllowEdit = false;
            //tl.Columns[2].OptionsColumn.AllowEdit = false;
            //tl.Columns[3].OptionsColumn.AllowEdit = false;
           // tl.EndUpdate();







        }

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

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

余额充值