oracle 复选框,DevExpress GridControl使用教程：添加checkbox复选框

添加一列，FieldName为"check"，将ColumnEdit设置为复选框样式。gridview1 editable设置为true

将要绑定的DataTable添加列"check",Type为bool。

绑定DataTable到GridControl。

获取：

string value = gridview.GetDataRow(i)["check"].toString();

value == "true" ||  "" ("false")

设置为多选

gridView1 .OptionsSelection.MultiSelect = true;

gridView1 .OptionsSelection.MultiSelectMode = DevExpress.XtraGrid.Views.Grid.GridMultiSelectMode.RowSelect;

测试的例子如下：

给GridControl添加数据

string strConn = "###";

OracleConnection oconn = new OracleConnection(strConn);

string strComm = "select CITY_NAME,DISTRICT_NAME from CC_COMPLAINT_POINT";

OracleDataAdapter oda = new OracleDataAdapter(strComm, oconn);

DataSet ds = new DataSet();

try

{

oda.Fill(ds, "cx");

ds.Tables["cx"].Columns.Add("check",System.Type.GetType("System.Boolean"));

gridControl1.DataSource = ds.Tables["cx"];

//Rel.DataSource = ds.Tables["cx"];

//Rel.DisplayMember = "DISTRICT_NAME";

//Rel.ValueMember = "CITY_NAME";

}

catch(Exception ex)

{

MessageBox.Show(ex.ToString());

}

finally

{

oconn.Close();

}

点击测试check按钮响应如下事件(获取被check的数据)

private void buttonX3_Click(object sender, EventArgs e)

{

string value="";

string strSelected="";

for (int i = 0; i < gridView1.RowCount; i++)

{

value = gridView1.GetDataRow(i)["check"].ToString();

if (value == "True")

{

strSelected += gridView1.GetRowCellValue(i, "DISTRICT_NAME");

}

}

MessageBox.Show(strSelected);

}

运行结果如下：

转载自http://blog.csdn.net/weinierbian/article/details/6255402

标签：DevExpress.NET用户界面控件

本站文章除注明转载外，均为本站原创或翻译。欢迎任何形式的转载，但请务必注明出处、不得修改原文相关链接，尊重他人劳动成果

文章转载自：慧都控件网