sql exception (Incorrect syntax near ')'.)
what is the above error please correct it
string cmd = @"SELECT * FROM [tbl_students] WHERE course_id=@courseId
AND branch_id IN(" + b开发者_运维知识库ranchId + @")
AND (@firstYrPercent is null OR first_year_percent>=@firstYrPercent
AND (@secondYrpercent is null OR second_year_percent>=@secondYrPercent)
AND (@thirdYrPercent is null OR third_year_percent>=@thirdYrPercent)
AND (@finalYearpercent is null OR final_year_percent>=@finalYearpercent)
AND (@currentDegeePercentage is null OR current_degree_percent>=@currentDegeePercentage)
AND (@passoutYear is null OR passing_year>=@passoutYear)
AND (@currentBacklog is null OR current_backlog<=@currentBacklog)
AND gender=@sex
AND (@eGap is null OR gapin_education<=@eGap)
AND (@highSchoolPercentge is null OR highschool_percentage>=@highSchoolPercentge)
AND (@higherSchoolPercentage is null OR ssc_percentage>=@higherSchoolPercentage)
AND (@grauationPercentage is null OR graduation_percentage>=@grauationPercentage)
AND (@diplomaPercentage is null OR diploma_percentage>=@diplomaPercentage)
AND (@noOfAtkt is null OR number_of_ATKT<=@noOfAtkt)
AND (@date is null OR DOB>=@date)";
You have a missing closing parenthesis at the end of the 3rd line:
AND (@firstYrPercent is null OR first_year_percent>=@firstYrPercent
Following line has no closing parenthesis
AND (@firstYrPercent is null OR first_year_percent>=@firstYrPercent
精彩评论