how to create an unbound column relate to a foreign key inside a grid

Question

i would like to create dynamically an unbound column in an Xtragrid control devexpress ; there is the scenario : i have a grid bound with data from Payment Datatable , fields are " Payment_ID , Customer_ID " so on and so forth , what i would like to do is , instead of having Customer_ID which is the foreign in this table , i want to have in it ,Customer_Name related to Customer_ID , to avoid confusion . someone Help Thanks(using winforms C#). below code used ; to populate the grid

          using System;
          using System.Collections.Generic;
          using System.ComponentModel;
          using System.Drawing;
          using System.Data;
          using System.Linq;
          using System.Text;
          using System.Windows.Forms;
          using System.Data.SqlClient;

          namespace YoungWoman
            {
               public partial class Payment2 : UserControl
                   {
                          DataSet ds3 = new DataSet();
                          SqlDataAdapter dapayment = new SqlDataAdapter();
                          SqlConnection conne = SqlCoonectionSEtup.GetConnection;
                          BindingSource PaymentBinding = new BindingSource();

               public Payment2()
                {
                   InitializeComponent();
                }

               private void AddPayment_Click(object sender, EventArgs e)
            {
               Paymentfrm payent = new Paymentfrm(Utils.Formtype.add, 0);
               payent.PaymentEvent += new EventHandler(RefreshingGrid);
               payent.PayentlabelsEvent += new EventHandler(RefresHlabels);

               payent.ShowDialog();

            }

               private void EditPayment_Click(object sender, EventArgs e)
              {
                 Paymentfrm pyt = new Paymentfrm(Utils.Formtype.edit, 1);
               pyt.ShowDialog();
              }
                   void RefreshingGrid(object sender, EventArgs e)
             {
                  ds3.Tables["tblPaymentYW"].Clear();
                  SqlCommand cmd = new SqlCommand("SELECT * FROM PaymentYW", conne);

                       dapayment.SelectCommand = cmd;
                        dapayment.Fill(ds3, "tblPaymentYW");
                        DgPaymentYW.DataSource = ds3.Tables["tblPaymentYW"];
                        DgPaymentYW.RefreshDataSource();
             }
    void RefresHlabels(object sender, EventArgs e)
    {
        LoadData();
    }


    private void Payment2_Load(object sender, EventArgs e)
    {
        LoadData();



    }

    private void LoadData()
    {
        SqlCommand cmd = new SqlCommand("SELECT *FROM PaymentYW ORDER BY PaymentId ", conne);
        dapayment.SelectCommand = cmd;
        ds3.Clear();
        dapayment.Fill(ds3, "tblPaymentYW");
        PaymentBinding.DataSource = ds3.Tables["tblPaymentYW"];
        DgPaymentYW.DataSource = PaymentBinding;

        this.PaymentIdlabelContro.DataBindings.Clear();
        this.PaymentIdlabelContro.DataBindings.Add(new Binding("Text", PaymentBinding, "PaymentId"));
        ReservationIdlabelControl.DataBindings.Clear();
        this.ReservationIdlabelControl.DataBindings.Add(new Binding("Text", PaymentBinding, "ReservationId"));
        LesseeIdlabelControl.DataBindings.Clear();
        this.LesseeIdlabelControl.DataBindings.Add(new Binding("Text", PaymentBinding, "LesseeId"));

        DatelabelControl.DataBindings.Clear();

        this.DatelabelControl.DataBindings.Add(new Binding("Text", PaymentBinding, "PaymentDate"));
        AmountlabelControl.DataBindings.Clear();
        this.AmountlabelControl.DataBindings.Add(new Binding("Text", PaymentBinding, "AmountPaid"));
        BalancelabelControl.DataBindings.Clear();
        this.BalancelabelControl.DataBindings.Add(new Binding("Text", PaymentBinding, "Balance"));
        gridView1.Columns[1].Visible = false;
        gridView1.Columns[6].Visible = false;


        DevExpress.Utils.FormatInfo fi = new DevExpress.Utils.FormatInfo();
        fi.FormatType = DevExpress.Utils.FormatType.Numeric;
        fi.FormatString = "c2";
        gridView1.Columns[5].DisplayFormat.Assign(fi);
        gridView1.Columns[4].DisplayFormat.Assign(fi);
        Rowcount();
        Priveleges();


    }

    void Rowcount()
    {
        RecordlabelControl.Text = " Records : " + (gridView1.RowCount);

    }
    void Priveleges()
    {
        if (SqlCoonectionSEtup.Priveleges == "User")
        {
            AddPayment.Enabled = false;
            EditPayment.Enabled = false;
            CancelBtn.Enabled = false;
        }
        else
        {

            AddPayment.Enabled = true;
            EditPayment.Enabled = true;
            CancelBtn.Enabled = true;

        }
    }

}

}

by "Create dynamically an unbound column" i mean creating by code a column coming from another table linked by its primary key , which is a foreign key in a particular table. — Derek Eminence Lombela, Aug 15 '12 at 16:54
The approach from Jerry should work. I would still call it a bound column. — paparazzo, Aug 15 '12 at 17:44

score 1 · Answer 1 · answered Aug 15 '12 at 15:22

1

In your Select statement, could you join the PaymentYW table with the Customer table on the customer_ID field? Then all the customer fields would be available and you could include the Customer_Name column in the DataGrid.

answered Aug 15 '12 at 15:22

Jerry

6,357
8
35
50

score 0 · Answer 2 · answered Aug 22 '12 at 06:58

if my understanding is correct you want to display equivalent customer_name in place of customner_id. You can achieve this behavior by using RepositoryItemLookUpEdit.

First add a repositoryItemLookUpEdit as column editor to the column mapped with "Customer_ID"

Get customer information from customer table and assign it to repositoryItemLookUpEdit datasource.

"Select Customer_ID,Customer_Name from Customers" - Like this you can get your customer details.

Add two column to repositoryItemLookUpEdit for id(Customer_ID) and name(Customer_Name) and give them field names appropriately. Assign the "Customer_ID" field as value member and "Customer_name" field as display member to the repositoryItemLookUpEdit. This will satisfy your requirement.

For more good presentation you can make the id column visibility false in repositoryItemLookUpEdit.

how to create an unbound column relate to a foreign key inside a grid

2 Answers2