The question is, what is the best way to I populate comboxes using Strataframe in those cases?

TIA,

Alex

You can still use an enum but show a single letter (or a full name) to the user. Our enum BO's just have the following code:

    Private Sub boenBatchTypes_ParentFormLoading() Handles Me.ParentFormLoading
        Dim ColDesc As String = "Description"
        Dim dt As New Data.DataTable

        dt = MicroFour.StrataFrame.Tools.Common.BuildDataTableFromEnum(GetType(UtilEnums.clsEnum.BatchTypes))

        ' Localise Batch names
        For i As Integer = 0 To dt.Rows.Count - 1
            dt.Rows.Item(i).Item(ColDesc) = UtilLocalisation.clsLocalise.Localise(dt.Rows.Item(i).Item(ColDesc).ToString)
        Next

        dt.DefaultView.Sort = ColDesc
        Me.CopyDataFrom(dt.DefaultView.ToTable, MicroFour.StrataFrame.Business.BusinessCloneDataType.ClearAndFillFromCompleteTable)

        dt = Nothing
    End Sub

In this example:

.BuildDataTableFromEnum - standard SF function to extract our "batch name" enums and creates a data table

UtilLocalisation.. - is our own function to localise the enum description.

Me.CopyDataFrom - standard SF sub to load the populate the BO.

Easy as and works a treat.

Cheers, Peter

I am still a newbie so I can' t tell from reading your code if your technique stores a number or a character in the table?  I'd like to store a character in the table.

Similar problem with optionbuttons.  How do you handle that one?

Thanks,

Alex

We store the enum (integer) value so the above wouldn't work for you.

I've never had to do the same with an option group so I can't help with that one.

Cheers, Peter

Alex

You can use any data type you need as it relates to binding.  In this example you may not want to use an enum, as these will always be stored as an integer.  You will want to create your data source manually:

You will bind to the combo just as you would for an enum, the difference is that the SelectedValue or value member of the combo will bind to the [value] field in the table which you have defined as a string, which in return will allow you to bind to a character field, which ultimately gets saved back to the database as character.  Hope this helps.