示例#1
0
        public static DataTable GetPersonelsWithFullName()
        {
            string sql = "SELECT id ,name +' ' + surname FullName From personnel";

            return(NativeSqlDb.ExecuteReader(sql));
        }
示例#2
0
        public static DataTable GetDepartments()
        {
            string sql = "SELECT DepID,Department FROM DEPARTMENTS Order by Department";

            return(NativeSqlDb.ExecuteReader(sql));
        }
示例#3
0
        public static DataTable GetSemesters()
        {
            string sql = "SELECT id ,semester FROM semster";

            return(NativeSqlDb.ExecuteReader(sql));
        }