给DropDownList的DataTextField属性绑定两个字段

最新推荐文章于 2019-08-11 12:51:38 发布

灵雨飘零

最新推荐文章于 2019-08-11 12:51:38 发布

阅读量4.4k

点赞数 1

分类专栏：技术文档文章标签： table database server c# sql 2010

本文链接：https://blog.csdn.net/kingboy2008/article/details/6564966

版权

技术文档专栏收录该内容

102 篇文章 0 订阅

订阅专栏

本文介绍了两种将两个字段绑定到ASP.NET DropDownList控件的方法。方法一通过在SQL查询语句中拼接字段来实现；方法二则是在DataTable中新增一个字段进行拼接。两种方法均可实现将复合字段作为显示文本。

摘要由CSDN通过智能技术生成

给DropDownList的DataTextField属性绑定两个字段

2010年01月03日星期日 20:29

方法1：在SQL查询语句中拼接字段

C#代码

using (SqlConnection conn = new SqlConnection("server=(local);database=Northwind;user id=sa;password=sa;min pool size=4;max pool size=100;Connection Lifetime=30;"))
{
SqlDataAdapter adapter1 = new SqlDataAdapter("Select Top 10 ProductId,ProductName+','+convert(nvarchar,UnitPrice) Text FROM Products", conn);
DataTable table1 = new DataTable();
adapter1.Fill(table1);
DropDownList1.DataSource = table1.DefaultView;
DropDownList1.DataTextField = "Text";
DropDownList1.DataValueField = "ProductId";
DropDownList1.DataBind();
}

using (SqlConnection conn = new SqlConnection("server=(local);database=Northwind;user id=sa;password=sa;min pool size=4;max pool size=100;Connection Lifetime=30;"))
{
    SqlDataAdapter adapter1 = new SqlDataAdapter("Select Top 10 ProductId,ProductName+','+convert(nvarchar,UnitPrice) Text FROM Products", conn);
    DataTable table1 = new DataTable();
    adapter1.Fill(table1);

    DropDownList1.DataSource = table1.DefaultView;
    DropDownList1.DataTextField = "Text";
    DropDownList1.DataValueField = "ProductId";
    DropDownList1.DataBind();
}

方法2：在DataTable中新增一字段

C#代码

using (SqlConnection conn = new SqlConnection("server=(local);database=Northwind;user id=sa;password=sa;min pool size=4;max pool size=100;Connection Lifetime=30;"))
{
SqlDataAdapter adapter1 = new SqlDataAdapter("Select Top 10 ProductId,ProductName,UnitPrice FROM Products", conn);
DataTable table1 = new DataTable();
adapter1.Fill(table1);
table1.Columns.Add("Text", System.Type.GetType("System.String"), "ProductName+'-'+UnitPrice");
DropDownList1.DataSource = table1.DefaultView;
DropDownList1.DataTextField = "Text";
DropDownList1.DataValueField = "ProductId";
DropDownList1.DataBind();
}