namespace dxExample
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
// Create data
ds = new DataSet();
ds.Tables.Add(GetOrderData());
ds.Tables.Add(GetCustomerData());
gridControl1.DataSource = ds.Tables[0];
// Hide the customerID column
gridView1.Columns["customerID"].Visible = false;
// Add an unbound column
GridColumn col = gridView1.Columns.AddField("custID");
col.Visible = true;
col.UnboundType = DevExpress.Data.UnboundColumnType.String;
col.OptionsColumn.AllowEdit = false;
// event for populating this column with data
gridView1.CustomUnboundColumnData += new DevExpress.XtraGrid.Views.Base.CustomColumnDataEventHandler(gridView1_CustomUnboundColumnData);
}
DataSet ds;
void gridView1_CustomUnboundColumnData(object sender, DevExpress.XtraGrid.Views.Base.CustomColumnDataEventArgs e)
{
if (e.Column.FieldName == "custID")
{
if (e.IsGetData)
{
object custID = gridView1.GetRowCellValue(e.ListSourceRowIndex, "customerID"); // Get customer ID from the Orders table
e.Value = ds.Tables["Customers"].Rows.Find(custID)["customerName"]; // set the required value
}
}
}
DataTable GetOrderData()
{
DataTable dt = new DataTable();
dt.TableName = "Orders";
dt.Columns.Add("orderID", typeof(int));
dt.Columns.Add("orderName", typeof(string));
dt.Columns.Add("customerID", typeof(int));
dt.Rows.Add(1, "Order1", 1);
dt.Rows.Add(2, "Order2", 1);
dt.Rows.Add(3, "Order3", 2);
dt.Rows.Add(4, "Order4", 2);
dt.Rows.Add(5, "Order5", 1);
return dt;
}
DataTable GetCustomerData()
{
DataTable dt = new DataTable();
dt.TableName = "Customers";
dt.Columns.Add("customerID", typeof(int));
dt.Columns.Add("customerName", typeof(string));
dt.Rows.Add(1, "Alfred");
dt.Rows.Add(2, "Matt");
DataColumn[] keys = new DataColumn[1];
keys[0] = dt.Columns[0];
dt.PrimaryKey = keys;
return dt;
}
}
}