根据特定列的结果设置单元格的颜色:RowCellStyle事件
//结果列的值为成功则设置为绿色否则为红色
private void gridView1_RowCellStyle(object sender, DevExpress.XtraGrid.Views.Grid.RowCellStyleEventArgs e)
{
GridView View = sender as GridView;
if (e.Column.FieldName == "importResult")//设背景
{
DataRow dr = gridView1.GetDataRow(e.RowHandle);
if (dr["importResult"].ToString() == "成功")
e.Appearance.BackColor = Color.LightGreen;
if (dr["importResult"].ToString() != "成功" && dr["importResult"].ToString() != "")
{
e.Appearance.BackColor = Color.Red;
}
}
}
根据某一单元格的值设置单元格所在行是否可编辑:ShowingEditor事件
private void gridView1_ShowingEditor(object sender, CancelEventArgs e)
{
DataRow row = this.gridView1.GetDataRow(this.gridView1.FocusedRowHandle);
if (row != null)
{
string ss = row["status"].ToString();
if (row["status"].ToString() == "已入库")//当status字段为已入库的时候
{
e.Cancel = true;//该行不可编辑
}
}
}