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();
}
}
{
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();
}
{
//要使此过滤生效,则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();
}