Beispiel #1
0
        public static DataTable Query_Data(string SYSTEM_ID, ref string _Msg)
        {
            sql  = " SELECT SYSTEM_ID,USER_NOTES,MAIL_ADS,IS_SEND,IS_MODIFY,IS_CC,Name";
            sql += " FROM EDA.dbo.Daily_Yield_OOC_MAIL_fortest";
            sql += " WHERE SYSTEM_ID='" + SYSTEM_ID + "'";
            sql += " AND 1 = 1";
            _msg = "ORDER BY ID;";

            dt = SQLCheck.GetDTable(connStr, sql, ref _msg);
            return(dt);
        }