WINFORM - DevExpress -＞ (DEVEXPRESS[GRIDCONTROL])前、后端交互

 1.后端-->前端赋值

this.gridView1.SetRowCellValue(i,"COntext2", dt2.Rows[i][1]); 

2.后端获取前端值

((DataRowView)gridControl2.MainView.GetRow(j)).Row.ItemArray[1].ToString()

 gridView2.GetRowCellValue(i, gridView2.Columns[10]).ToString() 

DataRow dr = this.gridView1.GetDataRow(this.gridView1.FocusedRowHandle);//获取选中行

DevExpress.XtraGrid.Views.Grid.GridView currentView = (DevExpress.XtraGrid.Views.Grid.GridView)this.gridControl1.FocusedView;
DataRow focusRow = currentView.GetFocusedDataRow();

主从表--从表修改

var dr= gridView1.GetFocusedDataRow();

var MdCount = dr["MdCount"];

Dev中GridView筛选后的数据获取(https://www.cnblogs.com/selfcontrol/p/9488595.html)

主要代码
 var filteredDataView = new DataView(gridControl1.DataSource as DataTable);

                filteredDataView.RowFilter =

                    DevExpress.Data.Filtering.CriteriaToWhereClauseHelper.GetDataSetWhere(gridView1.ActiveFilterCriteria);

注:gridView1.FocusedRowHandle.ToString()

3.临时表

DataTable dtss = ((DataView)gridView1.DataSource).ToTable();

4.获取分组总数

只有一列的时候：this.sumrsum.SummaryItem.SummaryValue.ToString();
多列的时候:this.sumrsum.Summary[1].SummaryValue.ToString();

示例

1.指定单元格赋值

//下面是我要通过修改单元格中单价，数量，来自动生成合价的数据

private void gridView1_CellValueChanged(object sender, CellValueChangedEventArgs e)
{          
    int i = e.RowHandle; //行数，千万别用for循环来遍历gridview的行数
    object sl = gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "SL"); //获取指定列SL数据
    object dj = gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "DJ"); //获取指定列DJ数据
    if (sl != System.DBNull.Value && dj != System.DBNull.Value)    //判读object类型是否为空
    {
        int a = Convert.ToInt32(sl);
        Decimal b = Convert.ToDecimal(dj);                 
        this.gridView1.GetDataRow(i)["HJ"] = (a*b).ToString();
    }      
 }