webform 关于DropDownList的问题？

[orson]

m_DropDownList.DataSource = ds.Tables["ProductType"].DefaultView;
m_DropDownList.DataTextField = "TypeName";
m_DropDownList.DataValueField = "TypeID";
m_DropDownList.DataBind();

之后，DropDownList中可以显示TypeName字段的值了，
但我现在想显示　TypeID 与TypeName　两个字段的值，该怎么做？

[saucer]

then you should change your sql to

select typeid + ' ' + typenme as tid from yourtable

m_DropDownList.DataSource = ds.Tables["ProductType"].DefaultView;
m_DropDownList.DataTextField = "Tid";
m_DropDownList.DataBind();

or just do

forech(DataRow dr in ds.Tables["ProductType"].Rows)
{
m_DropDownList.Items.Add(dr["TypeID"].ToString() + " " + dr["TypeName"].ToString());
}

[orson]

多谢！

[Eddie005]

在创建这个DataTable的时候处理
Select typeid,typename,'' + typeid + typename as type from Table1 （注：sql server）
那么
m_DropDownList.DataTextField = "Type";

当然选项的文字是可以改的,但并不是太好
foreach(ListItem tmpItem in m_DropDownList.Items)
{
tmpItem.Text += tmpItem.Value;
}