1、在sql语句中添加空白行，如select c1,c2 null c3 from xxx;
2、将sql语句查询结果与gdc绑定CmmFrm.BestFitGridViewColumnsWidth(gdc_lines, sql,2);
3、将上述空白列绑定为RepositoryItemCheckEdit控件，并添加事件
RepositoryItemCheckEdit re = new RepositoryItemCheckEdit();
re.QueryCheckStateByValue += new DevExpress.XtraEditors.Controls.QueryCheckStateByValueEventHandler(Re_QueryCheckStateByValue);//定义这个事件是关键,因为就靠它了
gdv_lines.Columns[2].ColumnEdit = re;
4、事件实现：
void Re_QueryCheckStateByValue(object sender, DevExpress.XtraEditors.Controls.QueryCheckStateByValueEventArgs e)
{ string val = ""; if (e.Value != null) { val = e.Value.ToString(); } else { val = "";//默认为不选中 } switch (val) { case"True": e.CheckState = CheckState.Checked; break; case"False": e.CheckState = CheckState.Unchecked; break; case"Yes": goto case"True"; case"No": goto case"False"; case"1": goto case"True"; case"0": goto case"False"; default: e.CheckState = CheckState.Unchecked; //默认状态，如果默认选择，则改为Checked break; } e.Handled = true; }5、整个gdv控件要设为可编辑，但除了chekbox列外，其它列要禁止出现编辑，这要靠gdc控件的ShowingEditor事件实现
private void gdv_lines_ShowingEditor(object sender, CancelEventArgs e)
{
if (gdv_lines.FocusedColumn.AbsoluteIndex != 2)
e.Cancel = true;
}
6、遍历、检索
for (int i = 0; i < gdv_lines.DataRowCount; i++)
{ DataRow dr=gdv_lines.GetDataRow(i); string ck = dr[2].ToString(); if (ck == "True") {...
}
7、程序设置选择状态
bool res = true;
if (gdv_lines.GetDataRow(0)[2].ToString() == "True") res = false;
for (int i = 0; i < gdv_lines.DataRowCount; i++) gdv_lines.GetDataRow(i)[2] = res;
///
另外，添加CombBox的方法，还不完善
// gdvLevel.BeginUpdate(); //开始视图的编辑，防止触发其他事件
// gdvLevel.BeginDataUpdate(); //开始数据的编辑
CmmFrm.BestFitGridViewColumnsWidth(gdcLevel, lvels, 1, false, false);
gdcLevel.DataSource = lvels;
gdvLevel.Columns[0].Visible = false;
RepositoryItemComboBox riCombo = new RepositoryItemComboBox();
riCombo.Items.AddRange(new string[] { "夏", "目视", "目视以下", "(含)以下" });
gdcLevel.RepositoryItems.Add(riCombo);
gdvLevel.Columns["其它"].ColumnEdit = riCombo;
//目前这种添加combbox的方法有缺陷，主要表现在1、不能设置为DorpDownList样式。2、选择后要敲回车，选择才能现在Cell中，否则焦点移走，选择就消失。
//有两篇文章解决这个问题，有时间梳理下
//https://yq.aliyun.com/articles/55052
//https://www.cnblogs.com/lonelyxmas/p/3906496.html
RepositoryItemCheckEdit riCkbox = new RepositoryItemCheckEdit();
riCkbox.ValueChecked = false;
gdcLevel.RepositoryItems.Add(riCkbox);
gdvLevel.Columns["选择"].ColumnEdit = riCkbox;
gdvLevel.EndDataUpdate();//结束数据的编辑
gdvLevel.EndUpdate(); //结束视图的编辑