dev grid 常用方法

绑定数据源

public void Data()
{
DataTable td = new DataTable();
DataRow row = td.NewRow();
foreach (GridColumn item in gridView1.Columns)
{
DataColumn it = new DataColumn(item.FieldName, typeof(String));
if (item.FieldName == "check")//添加复选框
{
td.Columns.Add(item.FieldName, Type.GetType("System.Boolean"));
td.Columns[item.FieldName].DefaultValue = Boolean.FalseString;
continue;
}
td.Columns.Add(it);
}

gridControl1.DataSource = td;
}

//重要

列标题字体设置
Appearences》HeaderPanel

1、获取选中行的某列的值：object ojb =GridView1.getrowcellvalue(GridView1.focusedrowhandle,"列名");

获取选中行的某列的值
this.gridView1.GetRowCellValue(0, gridView1.Columns["StorkCode"]);
//赋值
this.gridView1.SetRowCellValue(i, gridView1.Columns["jianshu"], gdjianshu.ToString());

2、设置标头居中，只需要设置Views-->Appearance-->HeaderPanel-->TextOptions.HAlignment=Center。内容居中设置:Columns-->AppearanceCell-->TextOptions.HAlignment=Center。上图第一列设置了内容居中。

3、设置Gridview控件，列头不可排序

this.gridDataDetail.gridView1.OptionsCustomization.AllowSort = false;

4、使Gridview控件，失去选中焦点

this.gridData.gridView1.FocusedRowHandle = -1

5、判断Gridview是否选中了数据

int index= this.gridData.gridView1.GetFocusedDataSourceRowIndex() ;

如果index小于0，证明没有选中行，否则就选中了行数据

6、获取选中Gridview的行数据

DataRow vCurrenRow = this.gridData.gridView1.GetFocusedDataRow();

7、删除选中Gridview行数据

this.gridDataDetail.gridView1.DeleteRow(this.gridDataDetail.gridView1.FocusedRowHandle);

8、Gridview新增一条编辑行

DataRow vDetailRow = this.DataDetailSourceTable.Rows.Add(); //这是新增加了一行
vDetailRow["primary_key"] = ""; primary_key为数据库绑定到Gridview中的字段，后面可以对其进行赋值。

9、获取GridView中所有的选中的行号

int[] iRowId = this.gridData.gridView1.GetSelectedRows();

在表格添加一列按钮
在column properties-->buttons--->将属性kind选为Glyph,然后将Caption设为把ButtonEdit的TextEditStyle设为HideTextEditor然后Button，第一个button的Caption写GO，Kind设为Glyph

在Gridview的OptionCustomization里面，有个属性叫"AllowColumnMoving"，把这个关闭，就不会显示Column Chooser的菜单了。

//选中行的下标
int index = this.gridView1.FocusedRowHandle;
//判断是否为回车
if (e.KeyChar == Keys.Enter.GetHashCode())
{
//视图内是否有数据,并且当前下标是否在最后一行
if (gridView1.Columns.View.RowCount != 0 && index < gridView1.Columns.View.RowCount - 1)
{
//如果大于0就从下标行开始
if (index > 0)
{
//TO DO
}
}
else {
// SubjectQuotaRowAdd();
}
}
//这是我写的回车代表新建也能够代替Tab跳格键我现在只能做出回车焦点定位到某行而不能定位到某行的某单元

4、获取RadioGroup上选择的是哪一个，代码如下：
private void radioGroup1_SelectedIndexChanged(object sender, EventArgs e)
{
if (radioGroup1.SelectedIndex == 1)
{
MessageBox.Show("未发送");
}
if (radioGroup1.SelectedIndex == 0)
{
MessageBox.Show("已发送");
}
if (radioGroup1.SelectedIndex == 2)
{
MessageBox.Show("发送失败");
}
}

在gridview的CustomDrawCell事件中，添加如下代码，则可实现行数据的颜色控制。

if (gvData.GetDataRow(e.RowHandle) == null) return;

if (gvData.GetDataRow(e.RowHandle)["列名"].ToString()=="1" )

{

//该行数据的该列的值为1时,其背景色为gray

e.Appearance.BackColor = Color.Gray;

}

else

{

e.Appearance.BackColor = Color.Blue;

}

if (e.RowHandle == gvData.FocusedRowHandle)

{

e.Appearance.ForeColor = Color.White;

e.Appearance.BackColor = Color.RoyalBlue;

｝

private void gridView2_RowCellStyle(object sender, DevExpress.XtraGrid.Views.Grid.RowCellStyleEventArgs e)

{

if(e.RowHandle == 2 && e.Column.FieldName == "NAME")

{

e.Appearance.ForeColor = Color.Red;

}

知道DevExpress XtraGrid是如何定位和查找指定列显示值的行吗？注意是列的实显示值，而不是关联数据源列值。

下面将给出两个查找实例的代码，供大家一起来分享：

using DevExpress.XtraGrid.Views.Base; using DevExpress.XtraGrid.Columns; // ... string searchText = "Japan"; // obtaining the focused view ColumnView view = (ColumnView)gridControl1.FocusedView; // obtaining the column bound to the Country field GridColumn column = view.Columns["Country"]; if(column != null) { // locating the row //如果用数据源中的列值，请用ColumnView.LocateByValue int rhFound = view.LocateByDisplayText(view.FocusedRowHandle + 1, column, searchText); // focusing the cell if(rhFound != GridControl.InvalidRowHandle) { view.FocusedRowHandle = rhFound; view.FocusedColumn = column; } }

DevExpress.XtraGrid.Views.Base.ColumnView view = gridControl1.MainView as DevExpress.XtraGrid.Views.Base.ColumnView; view.BeginUpdate(); try { int rowHandle = 0; DevExpress.XtraGrid.Columns.GridColumn col = view.Columns["Category"]; while(true) { // locating the next row rowHandle = view.LocateByValue(rowHandle, col, "SPORTS"); // exiting the loop if no row is found if (rowHandle == DevExpress.XtraGrid.GridControl.InvalidRowHandle) break; // perform specific operations on the row found here // ... rowHandle++; } } finally { view.EndUpdate(); }