StrataFrame Forum » StrataFrame Application Framework - V1 » WinForms (How do I?) » Editing data using DevExpress

Editing data using DevExpress

Chan — Fri, 16 Feb 2007 09:37:58 GMT

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

RE: Editing data using DevExpress

Trent L. Taylor — Fri, 16 Feb 2007 09:37:58 GMT

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:

[codesnippet]Public Readonly Property MyCustomProperty As String
    Get
        '-- Establish Locals
        Dim loCommand As New SqlCommand()
        loCommand.CommandText = "SELECT MyDescriptionField FROM MyTable WHERE MyFK=@MyFK")
        loCommand.Parameters.Add("@MyFK",SqlDataType.Int)
        loCommand.Parameters("@MyFK").Value = Me.MyFKField
        Return CType(Me.ExecuteScalar(loCommand), String)
    End Get
End Property[/codesnippet]

RE: Editing data using DevExpress

Chan — Fri, 16 Feb 2007 09:28:45 GMT

[quote] You can use a scalar method to pull the description from a FK table.[/quote]

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

Thank you

RE: Editing data using DevExpress

Trent L. Taylor — Thu, 15 Feb 2007 10:01:19 GMT

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.