Exemple #1
0
        private void LoadStatusGrid()
        {
            //To be changed to InvoiceID

            //Add Master and detail to dataset
            //Create and add Master Table (Bind Data)
            dataSet = new DataSet();

            Order.LoadAll();
            DataTable dvOrder = Order.GetDataTable();

            dvOrder.TableName = "Order";
            dataSet.Tables.Add(dvOrder);

            //Create and add Detail Table to dataset
            Voucher.LoadAll();
            DataTable dvVoucher = Voucher.GetDataTable();

            dvVoucher.TableName = "Voucher";
            dataSet.Tables.Add(dvVoucher);

            GRV.LoadAll();
            DataTable dvGRV = GRV.GetDataTable();

            dvGRV.TableName = "GRV";
            dataSet.Tables.Add(dvGRV);


            //Get List Of Column to relate
            DataColumn keyColumn1        = dataSet.Tables[dvOrder.TableName].Columns["ID"];
            DataColumn foreignKeyColumn1 = dataSet.Tables[dvVoucher.TableName].Columns["POID"];
            DataColumn keyColumn2        = dataSet.Tables[dvVoucher.TableName].Columns["ID"];
            DataColumn foreignKeyColumn2 = dataSet.Tables[dvGRV.TableName].Columns["ReceiptInvoiceID"];


            //Create Master-detail relation (Bind Tables)
            dataSet.Relations.Add("OrderVoucher", keyColumn1, foreignKeyColumn1);
            dataSet.Relations.Add("VoucherGRV", keyColumn2, foreignKeyColumn2);

            //Bind to Grid:Tables and Relation
            gridMain.LevelTree.Nodes.Add("OrderVoucher", gridVoucherView);
            gridMain.LevelTree.Nodes.Add("VoucherGRV", gridGRVView);
            gridMain.DataSource = dataSet.Tables[dvOrder.TableName];
        }