private void btnQuery_Click(object sender, EventArgs e) { string startNumber = txtStartNumber.Text; string count = txtEndNumber.Text; Student[] student = ScoreQuerier.GetClassmatesGPA(startNumber, Convert.ToUInt32(count)); //Sql Server OleDbConnection con = new OleDbConnection(@"Provider=SQLOLEDB;server=DESKTOP-OC99H24\SQLEXPRESS;Trusted_Connection=yes;Database=CS"); con.Open(); OleDbCommand com = new OleDbCommand(); com.Connection = con; foreach (Student stu in student) { string sql = string.Format("INSERT INTO CS(Name, GPA) VALUES('{0}', {1})", stu.Name, stu.GPA); com.CommandText = sql; com.ExecuteNonQuery(); } con.Close(); }
//获取成绩 /// <summary> /// 学生类的获取成绩方法,将自动从查询成绩的网页上获取成绩 /// </summary> /// <param name="schoolYear">查询指定学年的成绩</param> /// <param name="schoolTerm">查询指定学期的成绩</param> /// <returns>返回是否成功获取到成绩</returns> public bool GetSubjectScore(string schoolYear, SchoolTermOptions schoolTerm, string queryPurpose, string queryType) { return(ScoreQuerier.QueryStudentScore(this, schoolYear, schoolTerm, queryPurpose, queryType)); }