Select from another select statement to a repeater
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 :-)
|