DEV GridControl控件的使用总结

去掉GridControl控件上面的

Drag a column header here to group by that column

Options/OptionsView/ShowGroupPanel         True----->False

提交当前行的修改

using DevExpress.XtraGrid;

using DevExpress.XtraGrid.Views.ｂａｓｅ;

using System.Data.Common;

//...

public void UpdateDatasource(GridControl grid) {

    //Save the latest changes to the bound DataTable

    ColumnView view = (ColumnView)grid.FocusedView;

    view.CloseEditor();

    if(!view.UpdateCurrentRow()) return;   

    //Update the dataｂａｓｅ's Suppliers table to which oleDBDataAdapter1 is connected

    DoUpdate(oleDbDataAdapter1, dataSet11.Tables["Suppliers"]);

    //Update the dataｂａｓｅ's Products table to which the oleDbDataAdapter2 is connected

    DoUpdate(oleDbDataAdapter2, dataSet11.Tables["Products"]);

}
public void DoUpdate(DbDataAdapter dataAdapter, System.Data.DataTable dataTable) {
    try {
        dataAdapter.Update(dataTable);
    } catch(Exception ex) {
        MessageBox.Show(ex.Message);
    }
}


 
从非绑定数据源得到数据
private void Form1_Load(object sender, System.EventArgs e) 
{   // Create an unbound column.
   GridColumn unbColumn = gridView1.Columns.Add("Total");
   unbColumn.VisibleIndex = gridView1.Columns.Count;
   unbColumn.UnboundType = DevExpress.Data.UnboundColumnType.Decimal;
   // Disable editing.
   unbColumn.OptionsColumn.AllowEdit = false;
   // Specify format settings.
   unbColumn.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
   unbColumn.DisplayFormat.FormatString = "c";
   // Customize the appearance settings.
   unbColumn.AppearanceCell.BackColor = Color.LemonChiffon;
} 
// Returns the total amount for a specific row.
decimal getTotalValue(ColumnView view, int rowHandle) {
   decimal unitPrice = Convert.ToDecimal(view.GetRowCellValue(rowHandle, "UnitPrice"));
   decimal quantity = Convert.ToDecimal(view.GetRowCellValue(rowHandle, "Quantity"));
   decimal discount = Convert.ToDecimal(view.GetRowCellValue(rowHandle, "Discount"));
   return unitPrice * quantity * (1 - discount);
} 
// Provides data for the Total column.
private void gridView1_CustomUnboundColumnData(object sender, DevExpress.XtraGrid.Views.ｂａｓｅ.CustomColumnDataEventArgs e) {
   if(e.Column.FieldName == "Total" &&  e.IsGetData) e.Value = getTotalValue(sender as ColumnView, e.RowHandle);
}


 
运行时绑定到实现Ilist接口的数据源
public class Record {
   int id, age;
   string name;
   public Record(int id, string name, int age) {
      this.id = id;
      this.name = name;
      this.age = age;
   }
   public int ID { get { return id; } }
   public string Name {
      get { return name; }
      set { name = value; }
   }
   public int Age {
      get { return age; }
      set { age = value; }
   }
}
ArrayList listDataSource = new ArrayList();
listDataSource.Add(new Record(1, "Jane", 19));
listDataSource.Add(new Record(2, "Joe", 30));
listDataSource.Add(new Record(3, "Bill", 15));
listDataSource.Add(new Record(4, "Michael", 42));
gridControl1.DataSource = listDataSource;
gridControl1.MainView.PopulateColumns();
自定义列:
[C#]
 
DevExpress.XtraGrid.Views.ｂａｓｅ.ColumnView view = gridControl1.MainView as DevExpress.XtraGrid.Views.ｂａｓｅ.ColumnView;
DialogResult answer = MessageBox.Show("Do you want to create columns for all fields?", "Confirmation", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (answer == DialogResult.Yes)
   view.PopulateColumns();
else {
   string[] fieldNames = new string[] {"ProductID", "ProductName", "QuantityPerUnit", "UnitPrice"};
   DevExpress.XtraGrid.Columns.GridColumn column;
   view.Columns.Clear();
   for (int i = 0; i < fieldNames.Length; i++) {
      column = view.Columns.Add(fieldNames[i]);
      column.VisibleIndex = i;
   }
}
GridColumn主要属性

    
    

Property 
 
 
 

Description 
 
 
 

GridColumn.Name 
 
 
 

设计时定义的列名 
 
 
 

GridColumn.FieldName 
 
 
 

绑定到的数据源中的列名 
 
 
 

GridColumn.AbsoluteIndex 
 
 
 

在grid中的绝对位置索引 
 
 
 

GridColumn.ColumnHandle 

指定关联数据源列名的标识，它不一定是唯一的，因为一个数据源列可以关联到一个Grid中的多个列. 

 
手动创建Band
// obtaining the main view and clearing its bands collection
BandedGridView view = gridControl1.MainView as BandedGridView;
view.Bands.Clear();
// creating the bands layout
GridBand bandGeneral = view.Bands.Add("General Info");
GridBand bandTechnical = view.Bands.Add("Technical Info");
GridBand bandEngine = bandTechnical.Children.Add("Engine Info");
GridBand bandTransmission = bandTechnical.Children.Add("Transmission Info");
// assigning columns to bands
colTrademark.OwnerBand = bandGeneral;
colModel.OwnerBand = bandGeneral;
colLiter.OwnerBand = bandEngine;
colCylinders.OwnerBand = bandEngine;
colSpeedCount.OwnerBand = bandTransmission;
colTransmission.OwnerBand = bandTransmission;


 
如何定位和查找指定列显示值的行(注意是列的实显示值，而不是关联数据源列值)
using DevExpress.XtraGrid.Views.ｂａｓｅ;
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.ｂａｓｅ.ColumnView view = gridControl1.MainView as DevExpress.XtraGrid.Views.ｂａｓｅ.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(); }