public ActionResult PathologyPatientReport(string date_from, string date_to) { List <PathologyPatientReport> PathologyPatientReport = new List <PathologyPatientReport>(); Property p = new Property(); DataSet ds = new DataSet(); p.OnTable = "FetchPathologyPatientReport"; p.Condition1 = date_from; p.Condition2 = date_to; ds = dl.FetchPathologyPatientReport_sp(p); try { foreach (DataRow item in ds.Tables[0].Rows) { PathologyPatientReport m = new PathologyPatientReport(); m.TestName = item["TestName"].ToString(); m.Description = item["Description"].ToString(); m.ChargeCategoryName = item["ChargeCategoryName"].ToString(); m.AppliedCharge = item["AppliedCharge"].ToString(); m.ReportingDate = item["ReportingDate"].ToString(); m.DoctorName = item["DoctorName"].ToString(); m.PatientName = item["PatientName"].ToString(); PathologyPatientReport.Add(m); } ViewBag.PathologyPatientReport = PathologyPatientReport; } catch (Exception ex) { } return(View()); }