Iteraiting through repeater

[Marc Llenas]

Hi there,

I have a repeater that returns x rows from a main table.

I need to display some info stored on a secondary table that is linked to
the main using a one-to-many relationship.

Instead of using a nested repeater, I would like to manually do some checks
and display (or not) info contained on the secondary table.

Apparently the code to do this would be something like:

While objDataReader.Read()

'Do my checks and write whatever is needed

End While

Now if I place this code within the cell where the output is supposed to be
written (within the repeater), it returns nothing.

Am I doing something wrong? Is there a better way to do this?.

Thanks,

Marc

[Eliyahu Goldin]

Marc,

You should use either ItemDataBound or PreRender event. In the ItemDataBound
event you get access to every item as it gets values from the database.
Based on this value, you can look into another table and modify the item
content. In the PreRender event all items are already fully built and you
can loop through them doing the same look up.

You should get the data from the second table inside a DataTable and look up
there, or, better use DataRelation class to link two tables.

Eliyahu
"Marc Llenas" <ml*****@randagroup.es> wrote in message
news:%2****************@TK2MSFTNGP12.phx.gbl...

Hi there,

I have a repeater that returns x rows from a main table.

I need to display some info stored on a secondary table that is linked to
the main using a one-to-many relationship.

Instead of using a nested repeater, I would like to manually do some
checks and display (or not) info contained on the secondary table.

Apparently the code to do this would be something like:

While objDataReader.Read()

'Do my checks and write whatever is needed

End While

Now if I place this code within the cell where the output is supposed to
be written (within the repeater), it returns nothing.

Am I doing something wrong? Is there a better way to do this?.

Thanks,

Marc

[Marc Llenas]

Thanks Eliyahu,
I implemented the ItemDataBound approach as you recommended.

Now, how do I retrieve a value from the repeater? I need to get the value of
an ID field on the repeater in order to use it as a filter for a query
against the DB.

I've tried storing that value on a hidden field and then retrieving the
field's value but doesn't work (returns nothing). Any ideas on how to solve
this?

Thanks and have a great weekend.

Marc
"Eliyahu Goldin" <re*************@monarchmed.com> escribió en el mensaje
news:ea*************@TK2MSFTNGP14.phx.gbl...

Marc,

You should use either ItemDataBound or PreRender event. In the
ItemDataBound event you get access to every item as it gets values from
the database. Based on this value, you can look into another table and
modify the item content. In the PreRender event all items are already
fully built and you can loop through them doing the same look up.

You should get the data from the second table inside a DataTable and look
up there, or, better use DataRelation class to link two tables.

Eliyahu
"Marc Llenas" <ml*****@randagroup.es> wrote in message
news:%2****************@TK2MSFTNGP12.phx.gbl...

Hi there,

I have a repeater that returns x rows from a main table.

I need to display some info stored on a secondary table that is linked to
the main using a one-to-many relationship.

Instead of using a nested repeater, I would like to manually do some
checks and display (or not) info contained on the secondary table.

Apparently the code to do this would be something like:

While objDataReader.Read()

'Do my checks and write whatever is needed

End While

Now if I place this code within the cell where the output is supposed to
be written (within the repeater), it returns nothing.

Am I doing something wrong? Is there a better way to do this?.

Thanks,

Marc

[chris]

This should do what you want I think.

foreach (RepeaterItem dataItem in rptCart.Items)
{
CheckBox ckDelete =
(CheckBox)dataItem.FindControl("ckDel1");
TextBox txtLineNumber =
(TextBox)dataItem.FindControl("txtLineNumber");
TextBox txtQuantity =
(TextBox)dataItem.FindControl("txtQty");
int linenbr = int.Parse(txtLineNumber.Text);
if (ckDelete.Checked)
{
//delete the item
}
else
{
//update the item
}
}

Chris

[Marc Llenas]

Thanks Chris, that pointed me to the right direction.

Cheers,

Marc

"chris" <ch***@cubed-c.com> escribió en el mensaje
news:11**********************@v46g2000cwv.googlegr oups.com...

This should do what you want I think.

foreach (RepeaterItem dataItem in rptCart.Items)
{
CheckBox ckDelete =
(CheckBox)dataItem.FindControl("ckDel1");
TextBox txtLineNumber =
(TextBox)dataItem.FindControl("txtLineNumber");
TextBox txtQuantity =
(TextBox)dataItem.FindControl("txtQty");
int linenbr = int.Parse(txtLineNumber.Text);
if (ckDelete.Checked)
{
//delete the item
}
else
{
//update the item
}
}

Chris