• GridControl UnboundColumn使用其它表列


    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;
            }        
        }
    }
    

      

  • 相关阅读:
    欧拉函数 || [SDOI2008]仪仗队 || BZOJ 2190 || Luogu P2158
    欧拉函数 || Calculation 2 || HDU 3501
    并查集+时光倒流 || [JSOI2008]星球大战starwar || BZOJ 1015 || Luogu P1197
    并查集+启发式合并+LCA思想 || 冷战 || BZOJ 4668
    并查集+优先队列+启发式合并 || 罗马游戏 || BZOJ 1455 || Luogu p2713
    BZOJ-USACO被虐记
    #1
    BZOJ2441: [中山市选2011]小W的问题
    BZOJ2726: [SDOI2012]任务安排
    BZOJ1492: [NOI2007]货币兑换Cash
  • 原文地址:https://www.cnblogs.com/perock/p/3531866.html
Copyright © 2020-2023  润新知