multiple columns in DDList

[rothjm]

How do I bind multiple columns to a drop down list.
I run a stored procedure to find a patient name.
I want to show the first and last name in the drop down list.
Here's a snipet:


If Not Page.IsPostBack Then
objSQLCmd = New SqlCommand
With objSQLCmd
.CommandText = "sp_GetPatientByName"
.CommandType = CommandType.StoredProcedure
.Connection = objConnection
.Parameters.Add("@LName", SqlDbType.Char).Value = strLName
.Parameters.Add("@FName", SqlDbType.Char).Value = strFName
End With

objDataAdapter = New SqlDataAdapter(objSQLCmd)
objDataSet = New DataSet
objDataAdapter.Fill(objDataSet)
ddlTest.DataSource = objDataSet
ddlTest.DataTextField = ("Last_Name")
'ddlTest.DataTextField = ("Last_Name" & ", " & "First_Name")
ddlTest.DataBind()
ddlTest.Items.Insert(0, "Select a Patient")
End If


Thanks in Advance!