Question

我期待着一个能够表明我论坛中有多少答复专题的法典。我有一个重复(REPEATER_1),以显示与标题和案文一样对每个专题的其他信息。例如,为了获得所有权,我使用了:

<%# DataBinder.Eval(Container, "DataItem.title")%>

This works fine, but for counting replies, I need to access another table, and count all replies for this topic. I use the following SelectCommand:

"SELECT COUNT(ID) FROM [replies] WHERE parent= " & <%# DataBinder.Eval(Container, "DataItem.ID")%> & " ;"

But how do I execute this SelectCommand from within the Form (and within the repeater area) of the page using <%# XXXX.. %>

我知道有使用密码的替代品,但我正在采用这种方式;%# XXXX. %>

Also, what is it called when doing script inside a form using "<%# XXXX.. %>" ? It will make it easier for me to search on the web, as google or this website cannot search for "<%#"

Answer 1

I would do this in the ItemDataBound event of the Repeater.

www.un.org/Depts/DGACM/index_spanish.htm 我现在遵循你目前的做法,但你应回头来回答有关议题的提问。您以这种方式重启数据库,多次重提数据库。

protected void Repeater1_ItemDataBound(object sender, RepeaterItemEventArgs e)
{
    // !! use a parameterized query here to avoid SQL injection
    string query = String.Format("SELECT x FROM y WHERE z = {0}", DataBinder.Eval(e.Item.DataItem, "SomeColumn"));

    //execute your query to get reply count
    int replyCount = ExecuteQuery(query); // !! example

    Label lbl = e.Item.FindControl("ReplyCountLabel") as Label;
    if (lbl != null)
    {
        lbl.Text = replyCount.ToString()
    }
}

友情链接