木子屋
 

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

作者: dnawo

日期: 2009-05-08 04:19 PM

分类: Web编程

内容: 方法1：在SQL查询语句中拼接字段
复制内容到剪贴板 程序代码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中新增一字段
复制内容到剪贴板 程序代码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();
}

+ 查看当前日志评论 (0)

 

登录

────────────

木子屋

PJBlog3 v3.2.9.518 Inside.

Processed In 0.033 ms

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

你没有权限发表评论

────────────

木子屋

PJBlog3 v3.2.9.518 Inside.

Processed In 0.033 ms

暂无评论

返回

────────────

木子屋

PJBlog3 v3.2.9.518 Inside.

Processed In 0.048 ms