How to Show primary key data?

Question

I have two tables: Transactions and Accounts.

Transaction has a foreign key IDAccount from Accounts Table.

I assign datasource property of Datasource property of Datagridview to Transactions Table.

I want to Accounts.description insead of IDAccount in Datagridview.

What must I do?

Do you mean datatable? normally the value should be available in the source for it to be displayed — V4Vendetta, Apr 12 '11 at 09:45

score 1 · Answer 1 · answered Apr 12 '11 at 11:39

There is a solution to this problem offered here which involves doing some custom code to inspect each property and determine if it belongs to the main bound object or to a child object.

This looks like a good solution except it doesn't support editing or sorting based on these properties.

Another approach (which I would probably recommend since it is simpler) is to introduce an AccountDescription property to your Transaction object.

public class Transaction
{
    private Account _account

    public string AccountDescription
    {
        get { return _account.description; }
        set { _account.description = value; }
    }
}

You might also need to implement some custom INotifyPropertyChanged code so databinding works nicely.

How to Show primary key data?

1 Answers1