How to join two tables using a datasouce tag

Hello,

I think deep loading is what you are looking for via (DeepLoadProperties) e.g. (http://docs.nettiers.com/FrequentlyAskedQuestions.ashx #2 and #3). The below should help give you an idea.

<data:ListDataSource ID="MainListDataSource" runat="server" SelectMethod="GetPaged"  EnableDeepLoad="true" EnablePaging="true">
    <DeepLoadProperties>
        <Types>
<data:ListProperty Name="ListType" />
        </Types>
    </DeepLoadProperties>
    <Parameters>
        <data:CustomParameter Name="OrderBy" DefaultValue="Type" />
        <data:SqlParameter Name="WhereClause" UseParameterizedFilters="false">
<Filters>
    <data:ListFilter Column="Type" ComparisionType="Contains" DefaultValue="1" />
</Filters>
        </data:SqlParameter>
    </Parameters>
</data:ListDataSource>

Thanks

-Blake Niemyjski