//查询某个用户成绩 public DataSet QueryUserScore(string XUserID) { SqlParameter[] Params = new SqlParameter[1]; DataBase DB = new DataBase(); string strsql = "SELECT Users.UserID,Users.UserName,Scoretb.ID,Scoretb.Score,Scoretb.ExamTime,Scoretb.JudgeTime,Scoretb.PingYu,Paper.PaperID,Paper.PaperName FROM Users,Scoretb,Paper WHERE Users.UserID=Scoretb.UserID and Scoretb.PaperID=Paper.PaperID and Users.UserID=@UserID order by Scoretb.ExamTime"; Params[0] = DB.MakeInParam("@UserID", SqlDbType.VarChar, 20,XUserID); return DB.GetStrDataSet(strsql, Params); }