How to bind Navigation Property (second level model's two properties) in DataGridView's single column using BindingSource?

Question

I have faced problem to show the values in grid view using binding source. I have two models as Company and Partners.

I have PartnerId in Company Model,
and Partner model has FirstName and LastName.

I have showed the company info and partner's first name as shown above.

Now, I need to show both partner's first name and last name in single column as PartnerName. Could any one help me resolve this?

is it possible to achieve this without using any event handlers? — Balagurunathan Marimuthu, Apr 21 '16 at 06:43
could you please give some example stuff to do this? since, i am very new to this concept — Balagurunathan Marimuthu, Apr 21 '16 at 06:47
You should not put UI related stuff in entity classes. Use `CellFormatting` event as @RezaAghaei suggested. See http://stackoverflow.com/questions/36549062/hide-certain-properties-of-a-class-in-datagridview/36552399#36552399 and related. — Ivan Stoev, Apr 21 '16 at 06:51
ok. is there any possible to do at design time? like data property name in combo box column — Balagurunathan Marimuthu, Apr 21 '16 at 07:04
@BalagurunathanGM Again yes, but it needs to add a new property to `Partner` class which is not your option and you said in [comments](http://stackoverflow.com/questions/36760909/how-to-bind-second-level-models-two-columns-value-as-single-column-in-datagridv/36761711?noredirect=1#comment61101840_36761108) — Reza Aghaei, Apr 21 '16 at 07:11
@RezaAghaei Ok. Thanks for the solution. Let me do this by using the way that you have suggested. — Balagurunathan Marimuthu, Apr 21 '16 at 07:35

score 3 · Accepted Answer · answered Apr 21 '16 at 06:48

3

Option 1 - CellFormatting

As an option you can use CellFormatting event of DataGridView and show desired value:

void dataGridView1_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
{
    //I Suppose you want to show full name in column at index 3
    if(e.RowIndex>=0 && e.ColumnIndex==3)
    {
        var company = (Company)(this.dataGridView1.Rows[e.RowIndex].DataBoundItem);
        if (company != null && company.Partner != null)
            e.Value = string.Format("{0} {1}", company.Partner.FirstName,
                                                company.Partner.LastName);
    }
}

Option 2 - ToString()

As another option you can override ToString() method of Partner class and show the Partner in a column:

public override string ToString()
{
    return string.Format("{0} {1}", this.FirstName, this.LastName);
}

answered Apr 21 '16 at 06:48

Reza Aghaei

120,393
18
203
398

Option 1 == +1. Option 2 == no option for me :) – Ivan Stoev Apr 21 '16 at 07:03
@IvanStoev Thank you for your feedback. A meaningful `ToString()` override is really useful. I think it's not a UI code. We can use it in `ComboBox`, In `DataGridView` or wherever we need a meaningful string representation of an entity. – Reza Aghaei Apr 21 '16 at 07:06
Only if the class is some sort of a ViewModel. Other than that, `ToString` is just for debugging purposes. – Ivan Stoev Apr 21 '16 at 07:09
1

I will go with the option 1. Thanks both you. – Balagurunathan Marimuthu Apr 21 '16 at 07:37

score 0 · Answer 2 · answered Apr 21 '16 at 06:16

0

Make property which returns formated full name and bind this one to grid cell. You could use multibinding but that needs additional converter which returns (as your additional property) formated string - for example.

answered Apr 21 '16 at 06:16

Elektryczny

56
4

could you please give any example for this? – Balagurunathan Marimuthu Apr 21 '16 at 06:37
In your model class: private string FirstName; private string LastName; public string FullName { get { if (!string.IsNullOrEmpty(FirstName) && !string.IsNullOrEmpty(LastName)) return string.Format("{0} {1}", FirstName, LastName); else return string.Empty; } } And you bind FullName instead of FirstName/LastName – Elektryczny Apr 21 '16 at 06:44

How to bind Navigation Property (second level model's two properties) in DataGridView's single column using BindingSource?

2 Answers2