c1TrueDBGrid 常用属性

1.获取总行数

this.c1TrueDBGrid2.RowCount;

2.获取当前行某列值

 this.c1TrueDBGrid2.Columns["系统编号"].CellText(this.c1TrueDBGrid2.Row).ToString().Trim();

3.合并指定列

this.c1TrueDBGrid2.Splits[0].DisplayColumns["系统编号"].Merge = ColumnMergeEnum.Restricted;

4. c1TrueDBGrid自动列宽

public void GridColAuto(C1TrueDBGrid grid)
        {
            foreach (C1.Win.C1TrueDBGrid.C1DisplayColumn item in grid.Splits[0].DisplayColumns)
            {
                item.AutoSize();
            }
        }

5.设置某行自动列宽

c1TrueDBGrid1.Splits[0].DisplayColumns["系统编号"].AutoSize();

6.设置筛选功能

this.c1TrueDBGrid1.FilterBar = true;

7.锁定某列字段

c1TrueDBGrid1.Splits[0].DisplayColumns["系统编号"].Locked = true;

8.锁定整个c1TrueDBGrid

c1TrueDBGrid1.Splits[0].Locked = true;

9.隐藏某列

 c1TrueDBGrid1.Splits[0].DisplayColumns["系统编号"].Visible = true;

10.设置某列颜色

this.c1TrueDBGrid2.Splits[0].DisplayColumns["系统编号"].Style.BackColor = System.Drawing.Color.Blue;

11.模糊搜索

private void dgSelect_FilterChange(object sender, EventArgs e)
        {
            //要使此过滤生效，则c1TrueDBGrid2的属性AllowFilter设为False  
            System.Text.StringBuilder sb = new System.Text.StringBuilder();
            string ColName = "";
            string ColValue = "";
            foreach (C1.Win.C1TrueDBGrid.C1DataColumn dc in this.dgSelect.Columns)
            {
                if (dc.FilterText.Length > 0)
                {
                    ColName = dc.DataField.ToString().Trim();
                    ColValue = dc.FilterText.ToString().Trim();


                    if (sb.Length > 0) sb.Append(" AND ");


                    sb.Append(ColName.Trim() + " like " + "'%" + ColValue.Trim() + "%'");
                }
            }
            // filter the data
            ((DataTable)this.dgSelect.DataSource).DefaultView.RowFilter = sb.ToString();
        }