How to Resolve Time out Exception When Query take long Time
What I have tried:
I am Using Like Run procedure
_sql = "GetFinalResultFormula";
_parms = new SqlParameter[8];
_parms[0] = new SqlParameter("@ShiftID", SqlDbType.Int);
_parms[0].Value = shiftID == 0 ? null : (object)shiftID;
_parms[1] = new SqlParameter("@CourseID", SqlDbType.Int);
_parms[1].Value = courseID;
_parms[2] = new SqlParameter("@SpecializationID", SqlDbType.Int);
_parms[2].Value = specializationID;
_parms[3] = new SqlParameter("@InstituteID", SqlDbType.Int);
_parms[3].Value = instituteID;
_parms[4] = new SqlParameter("@SessionID", SqlDbType.Int);
_parms[4].Value = sessionID;
_parms[5] = new SqlParameter("@USERID", SqlDbType.Int);
_parms[5].Value = USERID;
_parms[6] = new SqlParameter("@EmpSubjectID", SqlDbType.Int);
_parms[6].Value = SubjectID;
_parms[7] = new SqlParameter("@pagenumber", SqlDbType.Int);
_parms[7].Value = pageno == 0 ? null : (object)pageno;
//_parms[7] = new SqlParameter("@FilterResultStatus", SqlDbType.Char);
//_parms[7].Value = FilterResultStatus == "(All)" ? null : (object)FilterResultStatus;
//_parms[8] = new SqlParameter("@FiltersubjectId", SqlDbType.Int);
//_parms[8].Value = Filtersubjectid == 0 ? null : (object)Filtersubjectid;
_dataSet = RunProcedure(_sql, _parms, true);