I have this Code:

myConnection.Open()
CommandText = "SELECT * FROM Students ORDER BY Students.firsName"
myCommand = New SqlCommand(CommandText, myConnection)

chooseStudent.DataSource = myCommand.ExecuteReader(CommandBehavior.CloseConne ction)

'Here is the problem
chooseStudent.DataTextField = "firsName" + "|" + "familyName"

chooseStudent.DataValueField = "firsName"

chooseStudent.DataBind()


In this code "chooseStudent" is a DropDownList which contain all students name.

I want that the value of each option (ListItem) will be the first name, But I want that the text will be "firstName" + "|" + "familyName".
(Like "Brad|Pit", "Gorge|Bush" and so......)

How to do it???

Change the select query as follows

select Students.FirstName+'|'+familyName as FullName Students ORDER BY Students.firsName;

then at the DataTextField property set as follows

chooseStudent.DataTextField = "FullName"



It is not how much we do,
but how much love we put in the doing.

-Mother Theresa

But I want that:

chooseStudent.DataValueField = "firsName"

also


How to do booth???

SELECT firsName+'|'+familyName as FullName, firsName FROM Students ORDER BY firsName;

chooseStudent.DataTextField = "FullName"
chooseStudent.DataValueField = "firsName"