DropDownList 绑定DataTable并给默认值

            string sql = @"SELECT FG_Id, FG_Name, FG_Sort, FG_IsDel FROM dbo.FirstGestation";
            DataTable FG_List = MySqlhelper.MySqlhelper.ExecuteDataTable(sql);
            FG_Id.DataSource = FG_List;
            FG_Id.DataTextField = "FG_Name";
            FG_Id.DataValueField = "FG_Id";
            FG_Id.DataBind();
            FG_Id.Items.Add(new ListItem("请选择", "", true));
            FG_Id.SelectedIndex = FG_Id.Items.Count - 1;

转载于:https://www.cnblogs.com/jinhaoObject/p/5335845.html