DropDownList的AppendDataBoundItems属性

 在ASP.NET 2.0中，可以在数据绑定时，通过设置DropDownList的AppendDataBoundItems属性为true,在数据绑定之前添加一个新的项目，并且这个新加的项目会保存在ViewState之中。下面就是一个实现的例子：

    protected void Page_Load(object sender, EventArgs e)
    ...{
        if (!IsPostBack)
        ...{
            //DropDownList的属性AppendDataBoundItems
            //功能：指示是否在数据绑定之前清除列表           
            DropDownList1.AppendDataBoundItems = true;

            DropDownList1.Items.Add(new ListItem("-- 请选择一个选择项 --", ""));

            DropDownList2.DataSource = DropDownList1.DataSource = CreateDataSource();

            DropDownList2.DataTextField = DropDownList1.DataTextField = "text";
            DropDownList2.DataValueField = DropDownList1.DataValueField = "id";

            DropDownList1.DataBind();
            DropDownList2.DataBind();
        }
    }

    //自定义数据源
    ICollection CreateDataSource()
    ...{
        DataTable dt = new DataTable();
        DataRow dr;
        dt.Columns.Add(new DataColumn("id", typeof(Int32)));
        dt.Columns.Add(new DataColumn("text", typeof(string)));
        for (int i = 0; i < 6; i++)
        ...{
            dr = dt.NewRow();
            dr[0] = i;
            dr[1] = "列表项目 " + i.ToString();
            dt.Rows.Add(dr);
        }
        DataView dv = new DataView(dt);
        return dv;
    }

    protected void Button1_Click(object sender, EventArgs e)
    ...{
        Response.Write("<li>DropDownList1 您选择的项目：" + DropDownList1.SelectedValue
          + " ; " + DropDownList1.SelectedItem.Text);
        Response.Write("<li>DropDownList2 您选择的项目：" + DropDownList2.SelectedValue
          + " ; " + DropDownList2.SelectedItem.Text);
    }

    //也可以这样添加
    /**//*
    protected void DropDownList1_DataBound(object sender, EventArgs e)
    {
        DropDownList1.Items.Insert(0, new ListItem("--请选择--", ""));
    }*/            <asp:DropDownList ID="DropDownList1" runat="server">
            </asp:DropDownList>
            <asp:DropDownList ID="DropDownList2" runat="server" AppendDataBoundItems="true">
                <asp:ListItem Text="请选择" Value=""></asp:ListItem>
            </asp:DropDownList>
            <asp:Button ID="Button1" runat="server" Text="得到选择的值" OnClick="Button1_Click" />
    另外，还可以使用下面的方法添加：

protected void DropDownList1_DataBound(object sender, EventArgs e)
{
DropDownList1.Items.Insert(0,new ListItem("--请选择--", ""));
}

本文来自CSDN博客，转载请标明出处：http://blog.csdn.net/High_Mount/archive/2008/02/29/2133693.aspx

 

也可以

SQLHelper sqlHelper = new SQLHelper(); string cmdText = "select * from T_GoodsType"; DataTable dt = new DataTable(); sqlHelper.RunSQL(cmdText, ref dt); ddl_Type.DataSource = dt; ddl_Type.DataTextField = "TypeName";//绑定的列 ddl_Type.DataValueField = "TypeID";//主键 ddl_Type.DataBind(); ddl_Type.Items.Insert(0, new ListItem("全部类别", "0"));//在最前面加上全部类别