public void getNews()
{
niapsEntities1 db = new niapsEntities1();
// news ne = new news();
var msg = db.news.OrderByDescending(n => n.date);
StringBuilder sb = new StringBuilder();
int i = 1;
foreach (var value in msg)
{
sb.Append(string.Format(@"<table width='400px'>
<tr>
<td>Title:</td><td>{0} </td>
</tr>
<tr>
<td></td><td>{1}<a href=""newsRoom.aspx"">read more...</a></td>
</tr>
<tr>
<td>Author:</td><td>{2} Date: {3}</td>
</tr>
<tr>
<td></td><td></td>
</tr>
</table>" , value.postebBy, niaps_ver_1._0.truncString.TruncateAtWord(value.message, 70), value.newsBy, value.date.ToShortDateString()));
if (i.Equals(5))
{
break;
}
i++;
}
newsLabel.Text = sb.ToString();
db.Dispose();
}
protected void Page_Load(object sender, EventArgs e)
{
niapsEntities1 db = new niapsEntities1();
// news ne = new news();
var msg = db.news.OrderByDescending(n => n.date);
StringBuilder sb = new StringBuilder();
foreach (var value in msg)
{
sb.Append(string.Format(@"<table id=""box-table-a"">
<tr>
<td>Title:</td><td>{0} </td>
</tr>
<tr>
<td></td><td>{1}</td>
</tr>
<tr>
<td>Author:</td><td>{2} Date: {3}</td>
</tr>
</table>" , value.postebBy, value.message, value.newsBy, value.date.ToShortDateString()));
}
newsLabel.Text = sb.ToString();
db.Dispose();
}
