如何在下拉列表中显示他的姓名 [英] How Do I Show Persons Address Also With His Name In Dropdownlist

问题描述

我绑定人名从数据库下拉列表但我需要在下拉列表中显示地址请提供一些解决方案

i am binding persons name to dropdownlist from database but i need to show there address also in dropdown please provide some solution

推荐答案

var Company = from com in objJobDAO.GetAllCompany()
                             where com.Status = true && strCompanyIDs.Contains(com.CompanyID.ToString())
                             select new
                             {
                                 com.CompanyID,
                                 PersonInfo = com.name + " ; " + com.address 

                             };

               rddlJobCompanyJS.Items.Clear();
               rddlJobCompanyJS.DataSource = Company;
               rddlJobCompanyJS.DataTextField = "PersonInfo";
               rddlJobCompanyJS.DataValueField = "CompanyID";
               rddlJobCompanyJS.DataBind();

您可能有以下SQL语句

You may have SQL statement as below

select Name from YourTable 

更改它

change it to

select Name + '-'+ Address as NameAddress from YourTable 

然后你可以绑定 NameAddress

这篇关于如何在下拉列表中显示他的姓名的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！