//c1TrueDBGrid 选择checkbox以后发生事件
private void c1TrueDBGrid1_AfterColEdit(object sender, C1.Win.C1TrueDBGrid.ColEventArgs e)
{
for (int i = 0; i < c1TrueDBGrid1.Splits[0].Rows.Count; i++)
{
if (c1TrueDBGrid1[i, "pState"].ToString() == "True")
a += decimal.Parse(c1TrueDBGrid1[i, "pMoney"].ToString());
}
}
(1) // 设置某列的是否显示
this.c1TrueDBGrid1.Splits[0].DisplayColumns["fieldName"].Visible = false;
(2) //c1TrueDBGrid 获得目前行数
int rows = this.c1TrueDBGrid2.Splits[0].Rows.Count;
(3)//c1TrueDBGrid 合计的做法
.写在load事件里的代码
int rows = this.c1TrueDBGrid1.Splits[0].Rows.Count;
int sum1 = 0;
for (int i = 0; i < rows; i++)
{
string unit1 = this.c1TrueDBGrid1[i, "aa"].ToString();
sum1 += Convert.ToInt32(unit1);
}
this.c1TrueDBGrid1.Columns["aa"].FooterText = sum1.ToString();
.c1TrueDBGrid1属性ColumnFooters设置为true
或者在load中加上 c1TrueDBGrid1.ColumnFooters = true;(截止)
(4) /// c1TrueDBGrid /设置某一列的背景颜色
this.c1TrueDBGrid1.Splits[0].DisplayColumns["bb"].Style.BackColor = System.Drawing.Color.Blue;
(5) // c1TrueDBGrid 设置某一列不允许取得焦点
this.c1TrueDBGrid1.Splits[0].DisplayColumns["bb"].AllowFocus = false;
(6) // c1TrueDBGrid 设置某一列不不能编辑
this.c1TrueDBGrid1.Splits[0].DisplayColumns["bb"].Locked = true;
(7) //c1TrueDBGrid 某一列的宽度设置为自适应宽度
this.c1TrueDBGrid1.Splits[0].DisplayColumns["aa"].AutoSize();
(8) //c1TrueDBGrid 冻结某一列
this.c1TrueDBGrid1.Splits[0].DisplayColumns["aa"].Frozen = true;
(9) 设置数据库状态。和CheckBox运用
(10) c1TrueDBGrid1设置绑定颜色设置[小于0显示红色]
private void c1TrueDBGrid1_FetchRowStyle(object sender, C1.Win.C1TrueDBGrid.FetchRowStyleEventArgs e)
{
if (c1TrueDBGrid1[e.Row, "bWnum"] != null)
{
//两种取值方法是一样的
int intTmp = int.Parse(c1TrueDBGrid1[e.Row, "bWnum"].ToString());
if (intTmp < 0)
{
e.CellStyle.BackColor = Color.Red;
}
}
}
C1.Win.C1TrueDBGrid.ValueItems items = this.c1TrueDBGrid1.Columns["Status"].ValueItems;
items.Translate = true;
items.CycleOnClick = true;
items.Presentation = C1.Win.C1TrueDBGrid.PresentationEnum.CheckBox;
items.Values.Clear();
items.Values.Add(new C1.Win.C1TrueDBGrid.ValueItem("0", false)); // unchecked
items.Values.Add(new C1.Win.C1TrueDBGrid.ValueItem("1", true)); // checked
//c1TrueDBGrid 选择checkbox以后发生事件
private void c1TrueDBGrid1_AfterColEdit(object sender, C1.Win.C1TrueDBGrid.ColEventArgs e)
{
for (int i = 0; i
{
}
}
(11)C1TrueDBGrid 列绑定下拉菜单的实现代码,,还需要在C1TrueDbGrid列设计器里将的Translate属性设置为true,它是一个子属性
DataTable dt = new DataTable();
dt.Columns.Add("ColumnName", typeof(string));//字段名
dt.Columns.Add("Compare", typeof(string));//比较
dt.Columns.Add("Values", typeof(string));//值
dt.Columns.Add("Logic", typeof(string));//逻辑
c1TrueDBGrid1.DataSource = dt;
BLL.SetCaptionNoInnerID(c1TrueDBGrid1, "字段名|比较|值|逻辑");
C1.Win.C1TrueDBGrid.ValueItems item = this.c1TrueDBGrid1.Columns["ColumnName"].ValueItems;
item.Translate = true;
item.Presentation = C1.Win.C1TrueDBGrid.PresentationEnum.ComboBox;
item.Values.Clear();
foreach (DataRow row in colDT.Rows)
{
item.Values.Add(new C1.Win.C1TrueDBGrid.ValueItem(row["name"].ToString(), row["value"].ToString()));
}
c1TrueDBGrid1.Splits[0].DisplayColumns["ColumnName"].Locked = false;//设置可编辑
(12) c1TrueDBGrid1列的合并 c1TrueDBGrid1.Splits[0].DisplayColumns["Batch"].Merge = true;
c1TrueDBGrid1.Splits[0].DisplayColumns["mProCode"].Merge = C1.Win.C1TrueDBGrid.ColumnMergeEnum.Free; 合并单元格