Nested Repeaters and SqlDataSource Parameters

asp.net sql sql-server repeater
Tony Peterson picture Tony Peterson · Jan 29, 2009 · Viewed 11.4k times · Source

I am using nested repeaters to build a table for reasons I won't discuss here, but what I'm looking to do is have two datasources, one for the top level repeater that will correspond to the rows, and one for the second level repeater that will return cells within a row.

What I'm wondering, however, is if I can somehow specify a parameter in the nested repeater's datasource that is set a field in the results from the first datasource?

Can I set a parameter to the value of a data binding expression?

The reason I want to do this is I have two stored procedures. When the page is loaded I have a session parameter I can use to run the first stored procedure, however, for the second stored procedure, I need to associate a value from each instance of the top level repeater with a call to the second stored procedure with a different parameter value.

Answer

Alexander Taylor picture Alexander Taylor · Mar 28, 2014

I did this by using a HiddenField to store a value to use as a parameter later. Gets the job done.

<asp:SqlDataSource ... />
<asp:Repeater ...>
    <ItemTemplate>

        <asp:HiddenField ID="txtOuterID" runat="server" Value='<%# Eval("ID") %>' Visible="false" />

        <asp:SqlDataSource ...>
            <SelectParameters>
                <asp:ControlParameter Name="OuterID" Type="Int32" ControlID="txtOuterID" PropertyName="Value" />
            </SelectParameters>
        </asp:SqlDataSource>

        <asp:Repeater ...>

    </ItemTemplate>
</asp:Repeater>

Related questions

Timeout expired with SqlBulkCopy

I'm using SqlBulkCopy to restore tables from xml backups. One of the table backup is ~200MB large and has a lot of records. I'm having error: Timeout expired. The timeout period elapsed prior to completion of the operation or the …

Read More
Insert byte array into SQL Server from C# and how to retrieve it

I'm trying to insert this byte array into a SQL Server database, the column data type is varbinary and this is my code in C# SqlParameter param = new SqlParameter("@buffer", SqlDbType.VarBinary, 8000); param.Value = buffer; string _query = "INSERT INTO [dbo].[…

Read More
ASP.NET SessionState with allowCustomSqlDatabase="true" doesn't call specified database

The Microsoft documentation here http://msdn.microsoft.com/en-us/library/h6bb9cz9(v=vs.90).aspx and several SO articles indicate that specifying allowCustomSqlDatabase="true" in the sessionState declaration of an ASP.NET web.config file will allow me to …

Read More