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

td>

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

<td style="width: 100px">

<b>Antal indlægb>

td>

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

<td style="width: 200px">

<b>Seneste indlægb>

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