行 46: string sqlstr = "select Place=(SELECT COUNT(DISTINCT totalScore) FROM T_TestMark WHERE a.totalScore >= a.totalScore) as 名次,b.userID as 用户名, a.totalScore as 成绩 FROM T_TestMark AS a INNER JOIN T_TestRecorder AS b ON a.recorderID = b.recorderID where testID=(select testID from T_Test where testName='" + DropDownList1.SelectedValue + "') ORDER BY Place";
行 47: SqlCommand comm = new SqlCommand(sqlstr, conn);
行 48: SqlDataReader dr = comm.ExecuteReader();
行 49: GridView1.DataSource = dr;
行 50: GridView1.DataBind();
提示在48行处出现问题
我应该怎么修改??代码是从书上打的,SQL语句是自己写的,不知道是否正确
sql语句的问题,where条件后面必须只能是条件表达式
因为48行才真正执行sql,所以问题才暴露出来。
select Place=(SELECT COUNT(DISTINCT totalScore) FROM T_TestMark WHERE a.totalScore >= a.totalScore)
这里应该不对,你可以把你的SQL放到对应数据库工具中执行一下,会报错的。