Combining two fields in a DataTextField. Is this possible?

Question

I have a dataset which I am binding to a listbox. However, I want to combine two of the fields to make up the DataTextField. Is this possible, or am I going to have to loop through the Data Rows?

lstAddressDropdown.DataSource = dsAddress;
lstAddressDropdown.DataTextField = "StreetAddress" + "Place";
lstAddressDropdown.DataBind();
lstAddressDropdown.Items.Insert(0, new ListItem("Please select"));

It's worth noting that the dataset comes back from a web service so I can't change any stored procedure to combine the columns there.

Answer 1

You can add an additional column to the datatable that is a computed column and use it as your datatextfield (docs: Multi-field Data Binding).

So for your example above you could do something like this:

dsAddress.Tables[0].Columns.Add("StreetAndPlace",typeof(string),"StreetAddress + Place");
lstAddressDropdown.DataSource = dsAddress;
lstAddressDropdown.DataTextField = "StreetAndPlace";
lstAddressDropdown.DataBind();
lstAddressDropdown.Items.Insert(0, new ListItem("Please select"));

To add a space between the StreetAddress and Place replace the expression string shown above with "StreetAddress + ' ' + Place"

Answer 2

Modify your query as per your requirement in Oracle

SELECT
'<B>'||SHORTNAME||'</B><br/>('||DEPARTMENT||')' AS USERNAME
FROM TABLE

In above query Name will show in bold and below it department will display like:

<b>Mr. Jagdeep Mankotia</b><br>
(Web Application Development)