protected void PopulateStudyDDL() { //DataTable dt = oSQL.DataTable_from_ProcName("spSEC_GetStudies_CanView_OR_Acess_by_User__Short__with_SelectStudy"); SQL_utils sql = new SQL_utils("backend"); string sqlcode = "select -1 as studyID, ' <select new study>' as StudyName " + "union select a.studyID, StudyName " + "from tblstudy a order by 2"; DataTable dt = sql.DataTable_from_SQLstring(sqlcode); sqluser.Text = String.Format("instantiate as:{0}<br/>viewable:{1}<br/>msg:{2}" , sql.InstantiateAs , sql.GetSessionContextViewableInfo() , sql.Errormsg ); ddl_Master_SelectStudyID.DataSource = dt; ddl_Master_SelectStudyID.DataBind(); }