ASP.NET: Can a MM:DataSet be "refilled" in a Repeater?

[sparky1962]

I'm trying to put a DataGrid inside a Repeater. The idea being that the DataSet
that the DataGrid is based on will be re-filled each Repeater loop iteration
with a parameter based on a "FieldValue" from the Repeater's DataSource.

<MM:DataSet id="SentinelsDataSet" CommandText='<%# "SELECT * FROM Sentinels
WHERE SiteIDFK = ?" %>' >
<Parameters>
<Parameter Name="@SiteIDFK" Value='<%#
SitesDataSet.FieldValue("SiteIDPK", Container) %>' Type="Integer" />

<ASP:Repeater runat="server" DataSource='<%# SitesDataSet.DefaultView %>'>
<ItemTemplate>
<asp:DataGrid id="SentinelsDataGrid"
DataSource="<%# SentinelsDataSet.DefaultView %>"

[Paul Whitham TMM]

I doubt that you can do this the way that you are envisaging. ASP.Net is
very particular about what controls can go inside others.

--
Regards

Paul Whitham
Macromedia Certified Professional for Dreamweaver MX2004
Valleybiz Internet Design
[url]www.valleybiz.net[/url]

Team Macromedia Volunteer for Ultradev/Dreamweaver MX
[url]www.macromedia.com/support/forums/team_macromedia[/url]

"sparky1962" <webforumsuser@macromedia.com> wrote in message
news:d0njl1$hf8$1@forums.macromedia.com...

> I'm trying to put a DataGrid inside a Repeater. The idea being that the

DataSet

> that the DataGrid is based on will be re-filled each Repeater loop

iteration

> with a parameter based on a "FieldValue" from the Repeater's DataSource.
>
> <MM:DataSet id="SentinelsDataSet" CommandText='<%# "SELECT * FROM

Sentinels

> WHERE SiteIDFK = ?" %>' >
> <Parameters>
> <Parameter Name="@SiteIDFK" Value='<%#
> SitesDataSet.FieldValue("SiteIDPK", Container) %>' Type="Integer" />
>
> <ASP:Repeater runat="server" DataSource='<%# SitesDataSet.DefaultView

%>'>

> <ItemTemplate>
> <asp:DataGrid id="SentinelsDataGrid"
> DataSource="<%# SentinelsDataSet.DefaultView %>"
>

[Kevin Marshall]

Set the DataGrids DataSource to a function that returns a datareader, you
can't use MM:DataSet though, its just too limiting, you need to write a
function the accepst dynamic SiteIDPK value as a parameter and returns the
appropriate data as a datareader using real code.

Without knowing which language your working in there is not much more I can
tell you.


--
Kevin Marshall
WebXeL.com Ltd
[url]http://www.webxel.com[/url]

ASP.NET Dreamweaver Extensions
[url]http://www.webxel-dw.co.uk[/url]
"sparky1962" <webforumsuser@macromedia.com> wrote in message
news:d0njl1$hf8$1@forums.macromedia.com...

> I'm trying to put a DataGrid inside a Repeater. The idea being that the
> DataSet
> that the DataGrid is based on will be re-filled each Repeater loop
> iteration
> with a parameter based on a "FieldValue" from the Repeater's DataSource.
>
> <MM:DataSet id="SentinelsDataSet" CommandText='<%# "SELECT * FROM
> Sentinels
> WHERE SiteIDFK = ?" %>' >
> <Parameters>
> <Parameter Name="@SiteIDFK" Value='<%#
> SitesDataSet.FieldValue("SiteIDPK", Container) %>' Type="Integer" />
>
> <ASP:Repeater runat="server" DataSource='<%# SitesDataSet.DefaultView %>'>
> <ItemTemplate>
> <asp:DataGrid id="SentinelsDataGrid"
> DataSource="<%# SentinelsDataSet.DefaultView %>"
>