[2005]Merging 4 columns into 1 from a data table to combobox

[steve_rm]

Hello,

I have a data table that I have filled using typed datasets. Using the code below.

Private Sub FillIncidents()
        Try
            Me.TA_Incident_dsIncidents.Fill(Me.Incidents.Incident)

        Catch ex As Exception
            MsgBox(ex.Message)
        End Try
    End Sub

There are 9 columns, and I want to take 4 of them and merge them into a combo box.

I was thinking of having a new data table and using the concat to merge the 4 columns into 1 to fill them into a new data table.

Then using the binding source to bind the data table to the combo box.

Can anyone tell me if this is the best method to use.

Many thanks,

Steve

[wild_bill]

It would probably be easier to concatonate the data in your query.