Hello friend, to achieve that you have to create a field concatenating two columns as per your need at the SQL level as follows:
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:
DDL.DataTextField = "Order_Customer"
- DD