Select from another select statement to a repeater

Question

Hi,

I have a big problem, I hope you can help me with.

What I want:
A forum where there is 3 columns Subject, AnswersCount, LastAnswer

I have one table with all the data. And two selects functions, where I on the first, get all Subjects for all questions, and on the second select get the Count for all answers on a specific question (with input quiestionId). Both functions works perfect, when I use them seperatly.

But I have to go through all rows in the first selection to find the Count

What shall I do to that?

The code I have now is:

The Repeater, where I want to put all data into:

<asp:Repeater ID="repDebatIndlaeg" runat="server">

<HeaderTemplate>

<table border="0" cellpadding="0" cellspacing="0" width="100%">

<tr>

<td>

<table border="0" cellpadding="0" cellspacing="0" width="100%">

<tr style="background-color: #25933c; color: #ffffff">

<td style="vertical-align: top; text-align: right;">

Antal indlæg ialt:

<asp:Label ID="lblIndlaegIalt" runat="server" Text="Label"></asp:Label>

</td>

<td style="width: 10px"></td>

</tr>

</table>

</td>

</tr>

<tr>

<td>

<table border="0" cellpadding="0" cellspacing="0">

<tr>

<td style="height: 10px"></td>

</tr>

<tr>

<td style="width: 20px;"></td>

<td style="width: 400px">

<b>Emne</b>

</td>

<td style="width: 10px"></td>

<td style="width: 100px">

<b>Antal indlæg</b>

</td>

<td style="width: 10px"></td>

<td style="width: 200px">

<b>Seneste indlæg</b>

</td>

</tr>

<tr>

<td colspan="6">

<hr />

</td>

</tr>

</HeaderTemplate>

<ItemTemplate>

<tr >

<td style="width: 20px;"></td>

<td>

<asp:HyperLink ID="lnkEmne" runat="server" Text='<%# Eval("Overskrift") %>' NavigateUrl='<%# "~/Debat.aspx?id=" + Eval("DebatId") %>'></asp:HyperLink>

</td>

<td style="width: 10px"></td>

<td style="text-align: left;">

<asp:Label ID="lblAntalIndlaeg" runat="server" Text='<%# Eval("DebatNr") %>'></asp:Label>

</td>

<td style="width: 10px"></td>

<td>

<asp:Label ID="lblSenesteIndlaeg" runat="server" Text='<%# Eval("Dato") %>'></asp:Label>

</td>

</tr>

<tr>

<td colspan="6">

<hr />

</td>

</tr>

</ItemTemplate>

<FooterTemplate>

</table>

</td>

</tr>

</table>

</FooterTemplate>

</asp:Repeater>

The codebehind:

protected void Page_Load(object sender, EventArgs e)
{
DebatApi debatapi = new DebatApi();

if (!IsPostBack)
{
try
{
DataTable Debat = null;
if (debatapi.GetDebat(ref Debat) == Status.Success)
{
int tael = 0;

for (int i = 0; i < Debat.Rows.Count; i++)
{
tael = Convert.ToInt32(Debat.Rows[i]["DebatId"]);
DataTable DebatCount = null;

if (debatapi.GetCountAnswers(tael, ref DebatCount) == Status.Success)
{

}
}
repDebatIndlaeg.DataSource = Debat.DefaultView;
repDebatIndlaeg.DataBind();
}
}
catch
{
}
}

debatapi.Dispose();
}

What shall I put into here so I can write the output into the repeater:
if (debatapi.GetCountAnswers(tael, ref DebatCount) == Status.Success)
{

}

If it was a label outside an repeater, I would make something like:

lblAntalIndlaeg.Text = Convert.ToInt32(GetKontoplanFuld.Rows[i]["DebatNr"]);

But VS cann't finde the lblAntalIndlaeg

I hope someone can help me....Im pretty desperat....

Kind regards,
simsen :-)