Hi programmers.
I have a table in my database that contains ID, Name and Family fields. I want to put values of name and family fields in a Dropdownlist in my ASP.NET Project. I set the Datavaluefield of Dropdownlist to "ID" but i don't know how to set the Datatextfield property of my Dropdownlist to show both Name and Family fields?
Please help me.

Hi there,

You can't do that directly in the control. The easiest way around this is this:

Add an additional column in your query that combines the two fields:

SELECT ID, Name, Family, Name + ' ' + Family AS FamilyName

This combines the two fields on the fly and gives you a new column called FamilyName that you can use in the drop down list.

HtH,

Imar
---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004
Want to be my colleague? Then check out this post.

Thank you very much comrade. You offered a very good idea....
in my c# code i write:
dropdownlist.datatextfield="FamilyName";
dropdownlist.datavaluefield="ID";

is this true?

thanks again my friend.

Why don't you try it out and see for yourself?

But yes, it's true. The new column is available the same way as you would access other columns, so you can set things like DataTextField and DataValueField.

Imar
---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004
Want to be my colleague? Then check out this post.

If you want a more columnar layout -- and not just concatenated fields -- there are some good third-party controls out there like http://easylistbox.com/demoColumns.aspx?rl=wp2p .

Thanks Peter, but i prefer to do Imar's offer.

Thanks Imar!