public string populateCommentsTable()
{
try
{
Users usr = new Users();
StringBuilder sb = new StringBuilder();
DataProvider dp = new DataProvider();
DataTable dt = dp.getComments(goalID);
if (dt.Rows.Count > 0)
{
sb.Append("<table id=\"tableComments\">");
sb.Append("<thead>");
sb.Append("<tr>");
sb.Append("<th></th>");
sb.Append("<th></th>");
sb.Append("</tr>");
sb.Append("</thead>");
sb.Append("<tbody>");
for (int i = 0; i < dt.Rows.Count; i++)
{
sb.Append("<tr>");
sb.Append("<td>");
sb.Append("<img src='"+ usr.getProfilePic(dt.Rows[i]["OwnerID"].ToString()) + "' alt='PP' style='width:50px;'/>");
sb.Append("</td>");
sb.Append("<td>");
sb.Append(dt.Rows[i]["CommentText"].ToString());
sb.Append("</td>");
sb.Append("</tr>");
}
sb.Append("</tbody>");
sb.Append("</table>");
sb.Append("<script>");
sb.Append("$(document).ready(function(){");
sb.Append("$('#tableComments').DataTable();");
sb.Append("});");
sb.Append("</script>");
}
else
{
sb.Append("<h3>No Comments...</h3>");
}
return sb.ToString();
}
catch (Exception ex)
{
throw ex;
}
}
