public string populateGoalText() { try { StringBuilder sb = new StringBuilder(); //Select Goal Info DataProvider dp = new DataProvider(); DataTable dt = dp.getGoalInfo(goalID); if (dt.Rows.Count > 0) { sb.Append("<p>"); sb.Append(dt.Rows[0]["textGoal"].ToString()); sb.Append("</p>"); sb.Append("<p>"); sb.Append("<b>Goal Date: </b>"); sb.Append(dt.Rows[0]["dateGoal"].ToString()); sb.Append("</p>"); } else { //No Data found sb.Append("<p>"); sb.Append("An Error Occurred, No Data Found!"); sb.Append("</p>"); } //Over return sb.ToString(); } catch (Exception ex) { throw ex; } }