gridView1 创建列

最新推荐文章于 2024-10-02 10:53:34 发布

wushijun5200

最新推荐文章于 2024-10-02 10:53:34 发布

阅读量127

点赞数 1

文章标签： python

本文链接：https://blog.csdn.net/wushijun5200/article/details/135921692

版权

文章详细描述了如何在C#代码中使用DevExpressGrid组件创建列、设置选择模式、数据源绑定和表格自适应宽度的过程，针对cid参数动态查询数据库数据。

摘要由CSDN通过智能技术生成

 #region 读取Grid 
        GridColumn col1 = new GridColumn();
        GridColumn col2 = new GridColumn();
        GridColumn col3 = new GridColumn();
        GridColumn col4 = new GridColumn();
        GridColumn col5 = new GridColumn();
        GridColumn col6 = new GridColumn();
        void readxmGrid(string cid)
        {
            gridView1.OptionsSelection.MultiSelectMode = DevExpress.XtraGrid.Views.Grid.GridMultiSelectMode.RowSelect;//设置选中方
            this.gridView1.FocusRectStyle = DevExpress.XtraGrid.Views.Grid.DrawFocusRectStyle.RowFocus;
            this.gridView1.OptionsBehavior.Editable = false;
            this.gridView1.OptionsSelection.EnableAppearanceFocusedCell = false;


          
            col1.Caption = "id";
            col1.Visible = true;
            col1.FieldName = "jzuserid";

            //  delLinkHiper.ColumnEdit = stationDel;
            gridView1.Columns.Add(col1);
            col1.VisibleIndex = 1;

     
            col2.Caption = "名称";
            col2.Visible = true;
            col2.FieldName = "jzusername";
            gridView1.Columns.Add(col2);
            col2.VisibleIndex = 2;

            col3.Caption = "编号";
            col3.Visible = true;
            col3.FieldName = "jzuserbh";
            gridView1.Columns.Add(col3);
            col3.VisibleIndex = 3;

            col4.Caption = "状态";
            col4.Visible = true;
            col4.FieldName = "state";
            gridView1.Columns.Add(col4);
            col4.VisibleIndex = 4;

           

            gridControl1.DataSource = null;
            if(cid == "0")
            {
                DataTable DT = jzuserSER.QueryTABjzuser0().Tables[0];
                gridControl1.DataSource = DT;
            }
            else
            {
                DataTable DT = jzuserSER.QueryTABByjzuserbyjz(cid).Tables[0];
                gridControl1.DataSource = DT;
            }
            // this.gridView1.OptionsBehavior.Editable = true;
            this.gridView1.OptionsView.ColumnAutoWidth = false;
            this.gridView1.BestFitColumns();//自动调整所有字段宽度
            
        }

        #endregion