C# (CSharp) SQL_Project OLEDBHelper.GetTable Examples

Example #1

File: ClassMethods.cs Project: Shonedo25/11th-Grade-SQL-Project

        public static DataTable GetAllClassesForTeacher(string Id)
        {
            string com = "select * from Classes where TeacherId = '" + Id + "'";

            return(OLEDBHelper.GetTable(com));
        }

Example #2

        public static DataTable GetAllStudents()
        {
            string com = "select * from Students";

            return(OLEDBHelper.GetTable(com));
        }

Example #3

File: ClassMethods.cs Project: Shonedo25/11th-Grade-SQL-Project

        public static DataTable GetAllClasses()
        {
            string com = "select * from Classes";

            return(OLEDBHelper.GetTable(com));
        }

Example #4

File: TeacherMethods.cs Project: Shonedo25/11th-Grade-SQL-Project

        public static DataTable GetAllTeachers()
        {
            string com = "select * from Teachers";

            return(OLEDBHelper.GetTable(com));
        }