初始化下拉列表

#region 初始化下拉列表
     public static void InitDDL(string sSQL, DropDownList ddl, string sFieldID, string sFieldName, string sSelectFieldNameValue, bool bAll)
     {
         string sError = "";
         DataTable dt = RB.SqlHelper.RunQuery(CommandType.Text, sSQL, null, out sError);
         if (sError.Equals(""))
         {
             ddl.Items.Clear();
             ddl.DataSource = dt;
             ddl.DataTextField = sFieldName;
             ddl.DataValueField = sFieldID;
             ddl.DataBind();
             if (bAll) ddl.Items.Insert(0, new ListItem("---请选择---", ""));
             if (!sSelectFieldNameValue.Equals("")) ddl.SelectedIndex = ddl.Items.IndexOf(ddl.Items.FindByText(sSelectFieldNameValue));
         }
     }
     public static void InitDDL(object list, DropDownList ddl, string sFieldID, string sFieldName, string sSelectFieldNameValue)
     {
         ddl.Items.Clear();
         ddl.DataSource = list;
         ddl.DataTextField = sFieldName;
         ddl.DataValueField = sFieldID;
         ddl.DataBind();
         ddl.Items.Insert(0, new ListItem("请选择", ""));
         ddl.SelectedValue = sSelectFieldNameValue;    }
     #endregion