C# (CSharp) DAL SQLHelper.GetByClassName示例

示例#1

        public DataTable GetScoreByClassName()
        {
            string sql = "SELECT Students.StudentId,StudentName,ClassName,CSharp,SQLServerDB FROM Students ";

            sql += "INNER JOIN StudentClass ON Students.ClassId=StudentClass.ClassId ";
            sql += "INNER JOIN ScoreList ON ScoreList.StudentId=Students.StudentId ";

            return(SQLHelper.GetByClassName(sql));
        }