今天写作业碰到的问题,自己纠结,检查折腾了半小时,觉得实在不行了,开始百度,百度上也没有太确切的答案
,也不是没有答案,就是太难找到了,并且大神讲的太深奥,原理是没看懂,但是解决办法学会了,下面贴代码
StringBuilder strSql = new StringBuilder();
strSql.AppendLine("select stu.studentno,sub.subjectid,r.StudentResult,r.examdate,r.id");
strSql.AppendLine("from student as stu inner join result as r on (stu.studentNo=r.studentNo)");
strSql.AppendLine("inner join subject as sub on(r.subjectid=sub.subjectid) where 1=1");
if (subjectId != 0)
{
strSql.AppendLine("and r.subjectid=@subjectid");
}
if (name != "")
{
strSql.AppendLine(" and stu.studentname like
strSql.AppendLine("select stu.studentno,sub.subjectid,r.StudentResult,r.examdate,r.id");
strSql.AppendLine("from student as stu inner join result as r on (stu.studentNo=r.studentNo)");
strSql.AppendLine("inner join subject as sub on(r.subjectid=sub.subjectid) where 1=1");
if (subjectId != 0)
{
strSql.AppendLine("and r.subjectid=@subjectid");
}
if (name != "")
{
strSql.AppendLine(" and stu.studentname like