sajad_boj70
یک شنبه 26 شهریور 1391, 16:19 عصر
بابا خیلی ساده که.
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();
return dt;
}
Repeater1.DataSource = Top5_Topik_Database();
Repeater1.DataBind();
<asp:Repeater ID="Repeater1" runat="server" onitemdatabound="Repeater1_ItemDataBound">
<ItemTemplate>
<div id="link">
<asp:HyperLink ID="HyperLink1" runat="server"
NavigateUrl='<%# String.Format("~/Show/Display_PostID.aspx?TopicID={0}&Subject={1}" ,Eval("TopicID"), Eval("Subject")) %>'
Target="_blank">
<%# Fakhravary.Work_With_Strings.Text.SubStringText(Ev al("Subject"), 0, 48)%>
</asp:HyperLink>
</div>
</ItemTemplate>
</asp:Repeater>
آقای فخرآوری خیلی ممنون از راهنماییت.
ولی خداییش هر چی فکر کردم اصلا این تیکه کد رو متوجه نشدم چی به چیه و چیکار میکنه!!
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";
و منظور از :
onitemdatabound="Repeater1_ItemDataBound"
و
<%# Fakhravary.Work_With_Strings.Text.SubStringText(Ev al("Subject"), 0, 48)%>
چیه؟؟