基础数据绑定:用ListItem直接枚举出来,适用于不需要修改的类型列表。
<
asp:DropDownList ID
=
"
DropDownList1
"
runat
=
"
server
"
>
<
asp:ListItem Value
=
"
愿景
"
>
愿景
</
asp:ListItem
>
<
asp:ListItem Value
=
"
创建人
"
>
创建人
</
asp:ListItem
>
<
asp:ListItem Value
=
"
理论体系
"
>
理论体系
</
asp:ListItem
>
<
asp:ListItem Value
=
"
公司构架
"
>
公司构架
</
asp:ListItem
>
<
asp:ListItem Value
=
"
欣赏与感谢
"
>
欣赏与感谢
</
asp:ListItem
>
</
asp:DropDownList
>
SqlConnection conn
=
UtilitySqlClass.OperateDataBase.ReturnConn();
string
strSQL
=
"
select * from CompanyType
"
;
SqlDataAdapter ada
=
new
SqlDataAdapter(strSQL, conn);
DataSet ds
=
new
DataSet();
ada.Fill(ds,
"
CompanyType
"
);
DropDownList1.DataSource
=
ds.Tables[
"
CompanyType
"
].DefaultView;
DropDownList1.DataValueField
=
ds.Tables[
"
CompanyType
"
].Columns[
1
].ColumnName;
DropDownList1.DataTextField
=
ds.Tables[
"
CompanyType
"
].Columns[
1
].ColumnName;
DropDownList1.DataBind();
ds.Dispose();







动态绑定方法一:动态绑定数据库中的字段。










动态绑定方法二:利用DropDownList.Items.Add方法。
protected
void
Page_Load(
object
sender, EventArgs e)
{
if ( ! IsPostBack)
{
SqlConnection conn = UtilitySqlClass.OperateDataBase.ReturnConn();
try
{
conn.Open();
this .DropDownList1.Items.Add( "" );
string strSQL = " select CompanyType from CompanyType " ;
SqlCommand com = new SqlCommand(strSQL, conn);
SqlDataReader dr = com.ExecuteReader();
while (dr.Read())
{
this .DropDownList1.Items.Add(dr[ " CompanyType " ].ToString());
}
}
catch (Exception ex)
{
Response.Write( " <scirpt>alert(' " + ex.Message.ToString() + " ')</script> " );
}
finally
{
conn.Close();
}
}
}
{
if ( ! IsPostBack)
{
SqlConnection conn = UtilitySqlClass.OperateDataBase.ReturnConn();
try
{
conn.Open();
this .DropDownList1.Items.Add( "" );
string strSQL = " select CompanyType from CompanyType " ;
SqlCommand com = new SqlCommand(strSQL, conn);
SqlDataReader dr = com.ExecuteReader();
while (dr.Read())
{
this .DropDownList1.Items.Add(dr[ " CompanyType " ].ToString());
}
}
catch (Exception ex)
{
Response.Write( " <scirpt>alert(' " + ex.Message.ToString() + " ')</script> " );
}
finally
{
conn.Close();
}
}
}
说明:UtilitySqlClass.OperateDataBase.ReturnConn();返回的是一个打开的conn对象。数据库操作类在命名空间UtilitySqlClass中定义。此类我就不列出来了。o(∩_∩)o...哈哈
获取DropDownList下拉列表框值的方法是:DropDownList1.SelectedValue.ToString()