fakhravari
جمعه 10 خرداد 1392, 14:41 عصر
<asp:Repeater ID="Repeater1" runat="server" onitemdatabound="Repeater1_ItemDataBound">
<ItemTemplate>
<div id="link" dir="rtl">
<font class="content">
<asp:Image border="0" ID="Image1" ImageUrl="~/gg_files/li000000.gif" runat="server" />
<asp:HyperLink ID="HyperLink1" runat="server"
NavigateUrl='<%# String.Format("~/Show/Display_PostID.aspx?TopicID={0}&Subject={1}" ,Eval("TopicID"), Eval("Subject")) %>'
Target="_blank">
<%# Eval("Subject")%>
</asp:HyperLink>
</font>
</div>
</ItemTemplate>
</asp:Repeater>
protected void Page_Load(object sender, EventArgs e)
{
Repeater1.DataSource = Top5_Topik_Database();
Repeater1.DataBind();
}
public DataTable Top5_Topik_Database()
{
SqlConnection con = new SqlConnection(ConnectionString);
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandText = "select top (5) B_Topics.Subject , B_Topics.TopicID from B_Categories Left join B_Forums on B_Categories.CategoryID = B_Forums.CategoryID Left join B_Topics on B_Forums.ForumID = B_Topics.ForumID where B_Categories.CategoryID = " + 2 + " ORDER BY TopicID DESC";
con.Open();
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
con.Close();
if (dt.Rows.Count > 0)
{
//this.Img = dt.Rows[0]["Img"].ToString();
//this.Message = dt.Rows[0]["Message"].ToString();
//this.Time = dt.Rows[0]["Time"].ToString();
//this.Date = dt.Rows[0]["Date"].ToString();
this.Subject = dt.Rows[0]["Subject"].ToString();
//this.Atach = dt.Rows[0]["Atach"].ToString();
//this.ForumID = Int32.Parse(dt.Rows[0]["ForumID"].ToString());
this.TopicID = Int32.Parse(dt.Rows[0]["TopicID"].ToString());
}
else
{
lasteror = "موردی یافت نشد";
}
return dt;
}