深入DropDownList用法的一些学习总结分析

SqlConnection cOnn= system.Configuration.ConfigurationSettings.AppSettings["SqlConnection"].ToString();
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();

//其中datavaluefield属性是控件的一个关键属性，cs页面通过value值获取；
//而datatextfield是显示在视图页面的文本。

protected void Page_Load(object sender, EventArgs e)
{
    if (!IsPostBack)
    {
        SqlConnection cOnn= system.Configuration.ConfigurationSettings.AppSettings["SqlConnection"].ToString();
        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());
        //或者
        //DropDownList_name.Items.Add(new ListItem(TEXT, Value));
    }
}
catch (Exception ex)
{
    Response.Write("alert('" + ex.Message.ToString() + "')");
}
finally
{
    conn.Close();
}
}
}

protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
    {
        DropDownList2.Items.Clear();
        if (DropDownList1.Items[0].Selected)
        {
DropDownList2.Items.Add("陆小凤");
DropDownList2.Items.Add("楚留香");
        }
        else
        {
DropDownList2.Items.Add("杨过");
DropDownList2.Items.Add("小龙女");
        }
    }

DataSet Ds = null;
string SqlStr = null;
SqlServer sqlserverDB = new SqlServer();
SqlStr = "select name,account from qdvc_usersimple";
Ds = sqlserverDB.DataSetRun(null, SqlStr, "qdvc_usersimple");
foreach (DataRow dataRow in Ds.Tables[0].Rows)
{
    object[] itemArray = dataRow.ItemArray; //获取dataRow的所有的单元格里的数据Array
    // itemArray[0].ToString()是"name",itemArray[1].ToString()是"account"
    DropDownList_name.Items.Add(new ListItem(itemArray[0].ToString(), itemArray[1].ToString()));
}