绑定下拉框

    /// <summary>
    /// 绑定下拉框的数据
    /// </summary>
    /// <param name="sql">取数据的sql语句</param>
    /// <param name="ddl">绑定数据的下拉框</param>
    /// <param name="text">绑定下拉框的text</param>
    /// <param name="value">绑定下拉框的value</param>
    private void BindDLL(string sql, DropDownList ddl, string text, string value)
    {
        for (int i = ddl.Items.Count - 1; i >= 0; i--)
        {
            ddl.Items.Remove(ddl.Items[i]);
        }
        ddl.ClearSelection();
        DM dm = new DM();
        DataSet ds = dm.getsql(sql);
        ListItem li = new ListItem();
        if (ds.Tables[0].Rows.Count > 0)
        {
            for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
            {
                li = new ListItem();
                li.Text = ds.Tables[0].Rows[i]["" + text + ""].ToString();
                li.Value = ds.Tables[0].Rows[i]["" + value + ""].ToString();
                ddl.Items.Add(li);
            }
        }
        ddl.DataBind();
    }