Private Sub TwoFieldInCombo()
Dim dt As New DataTable
Dim dc As New DataColumn("merge", GetType(String))
Dim dr As SqlDataReader
Dim cm As SqlCommand
Try
dt.Columns.Add(dc)
Dim str As String = "Select name,lname from table"
SqlConnection1.Open()
cm = New SqlCommand(str, SqlConnection1)
dr = cm.ExecuteReader
dt.Rows.Clear()
Do While dr.Read
dc = dt.Rows.Add(dr.Item("name") + dr.Item("lname"))
Loop
ComboBox1.DataSource = dt
ComboBox1.DisplayMember = "merge"
dr.Close()
SqlConnection1.Close()
cm.Dispose()
SqlConnection1.Dispose()
Catch ex As Exception
MsgBox(ex.Message, MsgBoxStyle.Critical, "General Error")
Catch ex As SqlException
MsgBox(ex.Message, MsgBoxStyle.Critical, "Sql Error")
End Try
End Sub