Can DropDownList Data Value text be concatenated by several query results?

Question

0.00/5 (No votes)

See more:

Suppose I have the following two tables in SQL Server database:

Table_Order
- idOrder (int)
- OrderNumber (int)
- fk_Customer (int)

Table_Customer
- idCustomer (int)
- CustomerName (nchar)

There is a foreign key fk_Customer in Table_Order that points to the primary key idCustomer in Table_Customer, so that I can pull associated CustomerName for an order.

So, I have a DropDownList that shows Orders with following attributes bound to it:
- Data Value Field: idOrder
- Data Text Field: OrderNumber

In the DropDownList, is it possible to also show the associated CustomerName along with the OrderNumber, for example:

C#

DDL.DataTextField = OrderNumber + " (" + CustomerName + ");

Posted 14-Jun-14 1:21am

Member 8179886

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Debabrata_Das · Accepted Answer · 2014-06-14T01:43:00

Solution 2

Hello friend, to achieve that you have to create a field concatenating two columns as per your need at the SQL level as follows:

SQL

SELECT O.idOrder, O.OrderNumber + '(' + C.CustomerName + ')' AS Order_Customer
FROM TableCustomer C INNER JOIN TableOrder O ON C.idCustomer = O.fk_Customer

Then you can set DataTextField as shown below:

C#

DDL.DataTextField = "Order_Customer"

- DD

Posted 14-Jun-14 1:43am

Debabrata_Das

Comments

Member 8179886 14-Jun-14 7:45am

Thank you, this was exactly what I looked for :)

Debabrata_Das 14-Jun-14 7:51am

WC :)

Peter Leow · Accepted Answer · 2014-06-14T01:38:00

Solution 1

first the select query:

select idorder, convert(varchar, ordernumber) + " (" + customername + ")" as orderno from order join customer on fk_customer = idcustomer

then the ddl:

Data Text Field: orderno

Posted 14-Jun-14 1:38am

Peter Leow

Comments

Nirav Prabtani 14-Jun-14 7:41am

my 5+

Peter Leow 14-Jun-14 8:27am

Thank you.