Hey all. Below is the nested syntax on how to make a "codeless" nested
gridview embedded within another gridviews templatefield column. Only
problem is that it loads slow. REAL SLOW. There has to be a better way.
Suggestions anyone? By the way, I'm not opposed to coding, it just
seems like this should be easily doable on the aspx side of things.
Summary:
I'm stuffing the 3 three key fields from each row in the master
gridview into invisible labels, then pulling that data from them into
the nested sqldatasource which is in turn bound to the nested gridview.
Code:
<asp:TemplateFi eld>
<ItemTemplate >
<asp:Label ID="t1" runat="server" Text='<%#Eval(" van") %>'
Visible="false" />
<asp:Label ID="t2" runat="server" Text='<%#Eval(" tcon") %>'
Visible="false" />
<asp:Label ID="t3" runat="server" Text='<%#Eval(" carr") %>'
Visible="false" />
<asp:SqlDataSou rce ID="SqlDataSour ce1" runat="server"
ConnectionStrin g="<%$ ConnectionStrin gs:PATConnectio nString %>"
SelectCommand=" ww_nested" SelectCommandTy pe="storedproce dure">
<SelectParamete rs>
<asp:ControlPar ameter ControlID="t1" Name="van" Type="string" />
<asp:ControlPar ameter ControlID="t2" Name="tcon" Type="string" />
<asp:ControlPar ameter ControlID="t3" Name="carr" Type="string" />
</SelectParameter s>
</asp:SqlDataSour ce>
<asp:GridView ID="GridView2" runat="server" AutoGenerateCol umns="False"
DataSourceID="s qldatasource1" DataKeyNames="U ID" AllowPaging="fa lse"
AllowSorting="f alse">
<Columns>
<asp:BoundFie ld DataField="UID" HeaderText="UID " ReadOnly="True"
Visible="false"/>
<asp:BoundFie ld DataField="EVEN T_DESCRIPTION" HeaderText="Eve nt
Description" />
<asp:BoundFie ld DataField="Even t" HeaderText="Eve nt" />
<asp:BoundFie ld DataField="Even tDt" HeaderText="Eve ntDt" />
<asp:BoundFie ld DataField="Even tLocation" HeaderText="Loc ation" />
<asp:BoundFie ld DataField="Ship Name" HeaderText="Shi p Name" />
</Columns>
</asp:GridView>
</ItemTemplate>
</asp:TemplateFie ld>
