public CStuGradePage() { InitializeComponent(); using (SqlConnection conn = new SqlConnection("Data Source=.;Initial Catalog=ClassSystem;User ID=sa;Password=root")) { conn.Open(); using (SqlCommand cmd = conn.CreateCommand()) { cmd.CommandText = "select Sno,Sname,Cname,Grade from Stu_Grade"; SqlDataAdapter adapter = new SqlDataAdapter(cmd); DataSet dataset = new DataSet(); adapter.Fill(dataset); //把查询结果填充到dataset DataTable table = dataset.Tables[0]; DataRowCollection rows = table.Rows; List <StuGrade> t = new List <StuGrade>(); for (int i = 0; i < rows.Count; i++) { DataRow row = rows[i]; string Sno = (string)row["Sno"]; string Sname = (string)row["Sname"]; string Cname = (string)row["Cname"]; Int32 Grade = (Int32)row["Grade"]; StuGrade info = new StuGrade { Sno = Sno, Sname = Sname, Cname = Cname, Grade = Grade }; t.Add(info); } this.datagrid1.ItemsSource = t; } } }
private void BTN_SG_Search_Click(object sender, RoutedEventArgs e) { using (SqlConnection conn = new SqlConnection("Data Source=.;Initial Catalog=ClassSystem;User ID=sa;Password=root")) { conn.Open(); using (SqlCommand cmd = conn.CreateCommand()) { cmd.Parameters.Add(new SqlParameter("@S_SG", TB_SG.Text)); cmd.CommandText = "select Sno,Sname,Cname,Grade from Stu_Grade where Sno=@S_SG or Sname=@S_SG"; SqlDataAdapter adapter = new SqlDataAdapter(cmd); DataSet dataset = new DataSet(); adapter.Fill(dataset); //把查询结果填充到dataset DataTable table = dataset.Tables[0]; DataRowCollection rows = table.Rows; List <StuGrade> t = new List <StuGrade>(); for (int i = 0; i < rows.Count; i++) { DataRow row = rows[i]; string Sno = (string)row["Sno"]; string Sname = (string)row["Sname"]; string Cname = (string)row["Cname"]; Int32 Grade = (Int32)row["Grade"]; StuGrade info = new StuGrade { Sno = Sno, Sname = Sname, Cname = Cname, Grade = Grade }; t.Add(info); } this.datagrid1.ItemsSource = t; } } }
public string getRemoteGrade(string id, string pw) { if (!Validation.IDValidation(id)) return "Wrong Input"; try { ProjectDBEntities PDb = new ProjectDBEntities(); int count = PDb.StudentInfo.Where(s => s.SID == id).Count(); if (count == 0) return "False"; IQueryable<StuGrade> allGrades = from eve in PDb.StuGrade where eve.SID == id select eve; foreach (StuGrade item in allGrades) { PDb.StuGrade.Remove(item); } CookieContainer cookieContainer = new CookieContainer(); Encoding GB2312Encoding = Encoding.GetEncoding("GB2312"); // Login to JWC.CQU.EDU.CN // Note that this url changes from time to time string loginUrl = @"http://202.202.1.176/login.asp"; string loginParameters = "username="******"&password="******"; RequestHandler.SendSynchronousRequest(loginUrl, loginParameters, "POST", GB2312Encoding, cookieContainer); string getUrl = @"http://202.202.1.176/score/sel_score/sum_score_sel.asp"; string result = RequestHandler.SendSynchronousRequest(getUrl, loginParameters, "GET", GB2312Encoding, cookieContainer); //Regex GPARegex = new Regex(@"\d\.\d\d"); //var GPARegexMatches = GPARegex.Matches(result); //String GPA = GPARegexMatches[0].Value; //string CoursesRegexString = "/(?<= <td VALIGN=\"center\" width=\"210\" height=\"23\"> [^.][^.][^.][^.] ).*/g"; string CoursesRegexString = "(?<= <td VALIGN=\"center\" width=\"210\" height=\"23\"> \r\n ).*"; Regex CoursesRegex = new Regex(CoursesRegexString); var CoursesRegexMatches = CoursesRegex.Matches(result); string GradeRegexString = "(?<= <td align=\"center\" VALIGN=\"center\" width=\"43\" height=\"23\">\r\n).*"; Regex GradeRegex = new Regex(GradeRegexString); var GradeRegexMatches = GradeRegex.Matches(result); string CreditRegexString = "(?<= <td align=\"center\" VALIGN=\"center\" width=\"43\" height=\"23\"> \r\n ).*"; Regex CreditRegex = new Regex(CreditRegexString); var CreditRegexMatches = CreditRegex.Matches(result); string TypeRegexString = "(?<= <td align=\"center\" VALIGN=\"center\" width=\"53\" height=\"23\"> \r\n \r\n).*"; Regex TypeRegex = new Regex(TypeRegexString); var TypeRegexMatches = TypeRegex.Matches(result); string TeacherRegexString = "(?<= <td align=\"center\" VALIGN=\"center\" width=\"60\" height=\"23\"> \r\n ).*"; Regex TeacherTypeRegex = new Regex(TeacherRegexString); var TeacherTypeRegexMatches = TeacherTypeRegex.Matches(result); string TestTypeRegexString = "(?<= <td align=\"center\" VALIGN=\"center\" width=\"54\" height=\"23\"> \r\n).*"; Regex TestTypeRegex = new Regex(TestTypeRegexString); var TestTypeRegexMatches = TestTypeRegex.Matches(result); //System.Console.WriteLine(CreditRegexMatches.Count); //System.Console.WriteLine(CoursesRegexMatches.Count); //System.Console.WriteLine(GradeRegexMatches.Count); //System.Console.WriteLine(TypeRegexMatches.Count); //System.Console.WriteLine(TeacherTypeRegexMatches.Count); //System.Console.WriteLine(TestTypeRegexMatches.Count); List<GradeItem> gList = new List<GradeItem>(); for (int i = 0; i < CoursesRegexMatches.Count; i++) { GradeItem gi = new GradeItem(); gi.Name = CoursesRegexMatches[i].Value; gi.Name = gi.Name.Substring(0, gi.Name.Length - 1); gi.Grade = GradeRegexMatches[i].Value; gi.Grade = gi.Grade.Substring(1, gi.Grade.Length - 2); gi.Type = TypeRegexMatches[i].Value.Substring(3); gi.Credit = CreditRegexMatches[i].Value; gi.Credit = gi.Credit.Substring(0, gi.Credit.Length - 1); gi.Teacher = TeacherTypeRegexMatches[i].Value; gi.Teacher = gi.Teacher.Substring(0, gi.Teacher.Length - 1); gi.TestType = TestTypeRegexMatches[i].Value.Substring(1); gi.TestType = gi.TestType.Substring(0, gi.TestType.Length - 1); gList.Add(gi); } foreach (GradeItem item in gList) { StuGrade sg = new StuGrade { SID = id, G_NAME = item.Name, G_GRADE = item.Grade, G_CREDIT = item.Credit, G_TEACHER = item.Teacher, G_TYPE = item.Type, G_TESTTYPE = item.TestType }; PDb.StuGrade.Add(sg); } PDb.SaveChanges(); return "True"; } catch { return "False"; } }