Need to Combind two fields into one drop down

[dhrehor]

Sorry for the newbie question, but I am just getting started.

I have a drop down list that I am trying to populate with data from two fields.

If in the dataTextField, I populate lastname, the drop down works fine and populates the lastname field in the drop down.

What I want is to do a lastname, firstname. MY SQL statement pulls the correct data, I just don't know how to get this into the drop down correctly.

Fields imported via the SQL statement ( lastname and firstname)

Also I am doing this in Visual Studio via C#.

Thanks

Don

 

[TipGiver]

You can modify your SQL clause like:

SELECT lastName + ', ' + firstNAme
AS name,
<other_fields>...
FROM <table_name>

... etc

 

[ca8msm]

The easiest method is to create a new field in tyour SQL Statement that is a combination of both fields and then bind your DropDownList display field to that combined field.


____________________________________________________________

Need help finding an answer?

Try the Search Facility or read FAQ222-2244 on how to get better results.

 

[dhrehor]

Worked great guys.

Thanks

Don