Hello .Net Gurus
I need help in getting keyword new whenever new records added in
the Communication table I am displaying newly added communication items in
repeater control and I want to display that item as newly added for 36 hours
from the published date, any help would be appreciated.
Thank you,
<asp:Repeater ID ="rptItems" runat ="server" >
<HeaderTemplate >
<h1><span>Blue</span>Updates</h1>
</HeaderTemplate>
<ItemTemplate >
<ul id="subnavigation1">
<li>
<asp:HyperLink ID ="hyper1" runat ="server" NavigateUrl='<%#Eval("Communication_id","~/DetailsView.aspx?Communication_id={0}") %>' >
<%#DataBinder.Eval(Container.DataItem,"Communication_Title")%></asp:HyperLink>
</li>
</ul>
</ItemTemplate>
</asp:Repeater>
private void LoadData()
{
// using (OracleConnection conn = new OracleConnection(Connect))
using(SqlConnection conn = new SqlConnection(Connect))
{
try
{
conn.Open();
string query = "SELECT * FROM COMMUNICATIONS order by communication_id desc";
SqlDataAdapter da = new SqlDataAdapter(query, conn);
// OracleDataAdapter da = new OracleDataAdapter(query, conn);
DataTable dt = new DataTable();
da.Fill(dt);
conn.Close();
PagedDataSource pgitems = new PagedDataSource();
DataView dv = new DataView(dt);
pgitems.DataSource = dv;
pgitems.AllowPaging = true;
pgitems.PageSize = 5;
pgitems.CurrentPageIndex = PageNumber;
if (pgitems.PageCount > 1)
{
rptPages.Visible = true;
ArrayList pages = new ArrayList();
for (int i = 0; i < pgitems.PageCount; i++)
{
pages.Add((i + 1).ToString());
rptPages.DataSource = pages;
rptPages.DataBind();
}
}
else
rptPages.Visible = false;
rptItems.DataSource = pgitems;
rptItems.DataBind();
}
catch(Exception ex)
{
Response.Redirect("Error.aspx");
}
}
}