C# DevExpress GridControl手动添加数据
【方法一】绑定自定义的DataTable作为数据源:
private void 窗体名_Load(object sender, EventArgs e)
{
DataTable dt = new DataTable();
SetDataTable(dt, new string[] { "test","aa" }, new List<object[]>() { new object[] {"1",0}, new object[] { "2",1 } });
gridControl1.DataSource = dt;
}
private void SetDataTable(DataTable dt,string[] colNames,List<object[]> rowValues)
{
foreach (string s in colNames)
dt.Columns.Add(s);
foreach (object[] ls in rowValues)
dt.Rows.Add(ls);
return dt;
}
【方法二】调用GridView的SetRowCellValue方法:
private void 窗体名_Load(object sender, EventArgs e)
{
string[] gcNames = {"test","aa"};
BindDataToGridView(gcNames, new List<object[]>() { new object[] { "1", 0 }, new object[] { "2", 1 } }, gridControl1,gridView1);
}
public void BindDataToGridView(string[] colNames,List<object[]> rowValues,GridControl gridControl,GridView gv)
{
for (int i = 0; i < colNames.Length; i++)
{
GridColumn gc = new GridColumn();
gc.FieldName = colNames[i];
gc.VisibleIndex = i;
gc.Visible = true;
gv.Columns.Add(gc);
}
DataTable dt = new DataTable();
foreach(string s in colNames)
dt.Columns.Add(new DataColumn(s));
gridControl.DataSource = dt;
for (int i = 0; i < rowValues.ToArray().Length; i++)
{
gv.AddNewRow();
for (int j = 0; j < rowValues.ToArray()[i].Length; j++)
{
gv.SetRowCellValue(gv.FocusedRowHandle, gv.Columns[colNames[j]], rowValues.ToArray()[i][j].ToString());
}
}
}
总结:不管是哪个方法,都借助到 DataTable 进行数据绑定,只不过方法一是直接对数据源进行内容修改,方法二是绑定空的 DataTable 再调用 GridView 的 SetRowCellValue 方法对行进行遍历插值。由此可见,当需要对 GridControl 控件进行数据自定义时,不能直接操作。