Hi,

I am using DevExpress Grid for data entry. I am using BindingBusinessSource for data binding.

My question, how could I have additional column that show product description, for example after select product code?

Thank you

Include it in your SQL query or create a custom field.  I recommend the custom field which returns the description.  You can use a scalar method to pull the description from a FK table.  When you create a custom field, the BO treats it as though it belongs to that table.  You can see how to do this in the docs or the CRM sample for examples of how to achieve this.

Hi,

Do you meant to use ADO.NET code directly to retrieve the FK desciption?



Thank you

No.  You can create custom properties to a business object.  If you look at the tutorial documentation it shows you how to do this:

Application Framework -> Getting Started -> Creating a WinForms App -> Adding Custom Field Properties

You can then make this a Readonly property and then execute a scalar query to retrieve the data: