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:

<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:

</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">
Emne
</td>
<td style="width: 10px"></td>
<td style="width: 100px">
Antal indlæg
</td>
<td style="width: 10px"></td>
<td style="width: 200px">
Seneste indlæg
</td>
</tr>
<tr>
<td colspan="6">

--------------------------------------------------------------------------------

</td>
</tr>
</HeaderTemplate>

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

</td>
<td style="width: 10px"></td>
<td style="text-align: left;">

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

</td>
</tr>
<tr>
<td colspan="6">

--------------------------------------------------------------------------------

</td>
</tr>


</table>
</td>
</tr>
</table>



The codebehind:

[i]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["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:

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

But VS cann't finde the lblAntalIndlaeg

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

Kind regards,
simsen :-)