Asp.net – I want to exit both foreach loop and while loop when opdnew<0
protected void btnOPDDetect_Click(object sender, EventArgs e) { SqlConnection con1 = GetConnection(); SqlConnection con = GetConnection(); DataTable dt = new DataTable(); double opdnew; string batchNo = lblIdforReport.Text; SqlCommand cmd = new SqlCommand("Select ExpenseSheetNo,FurtherDetail,FurtherDetailBy,Id,VoucherStatus,Convert(nvarchar(50),Date,106) As Date,ProcessType,ProgramDepartment,CompanyPerson,PreparedBy,RecommendedStatus,Convert(nvarchar(50),PreparedDate,106) As PreparedDate,SubmittedBy,Convert(nvarchar(50),SubmittedDate,106) As SubmittedDate,RecommendedBy,Convert(nvarchar(50),RecommendedDate,106) As RecommendedDate,FurtherDetailBy,Supervisior,TotalAmount…