code_junkie

Nested Datalists using stored procedure parameters

Nov 12th, 2011
69
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.61 KB | None | 0 0
  1. <%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Default.aspx.cs" Inherits="nhscsharprepeater._Default" %>
  2.  
  3. <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
  4.  
  5.  
  6. <%@ Import Namespace="System.Web" %>
  7. <%@ Import Namespace="System.Web.UI" %>
  8. <%@ Import Namespace="System.Data" %>
  9.  
  10. <script type="text/C#" runat="server">
  11.  
  12.  
  13.  
  14.  
  15.  
  16. protected void DataList1_ItemDataBound(object sender, DataListItemEventArgs e)
  17. {
  18.  
  19. DataList oList = (DataList)e.Item.FindControl("Datalist2");
  20. Label oLabel = (Label)e.Item.FindControl("lblSection");
  21.  
  22. DataList oList2 = (DataList)oList.FindControl("Datalist3");
  23.  
  24.  
  25. SqlDataSource2.SelectParameters.Clear();
  26. SqlDataSource2.SelectCommand = "report_DistinctSubSections";
  27. SqlDataSource2.SelectParameters.Add("Section",oLabel.Text.ToString());
  28.  
  29.  
  30.  
  31. oList.DataBind();
  32.  
  33. }
  34.  
  35.  
  36.  
  37. </script>
  38.  
  39. <html xmlns="http://www.w3.org/1999/xhtml" >
  40. <head runat="server">
  41. <title>Untitled Page</title>
  42. </head>
  43. <body>
  44. <form id="form1" runat="server">
  45. <div>
  46. <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:productfolioConnectionString %>"
  47. SelectCommand="report_DistinctSection" SelectCommandType="StoredProcedure"></asp:SqlDataSource>
  48. <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:productfolioConnectionString %>"
  49. SelectCommandType="StoredProcedure">
  50.  
  51. <SelectParameters>
  52. <asp:Parameter Name="Section" Type="String" />
  53. </SelectParameters>
  54.  
  55. </asp:SqlDataSource>
  56. <asp:SqlDataSource ID="SqlDataSource3" runat="server" ConnectionString="<%$ ConnectionStrings:productfolioConnectionString %>"
  57. SelectCommand="report_getReports" SelectCommandType="StoredProcedure">
  58. <SelectParameters>
  59. <asp:Parameter Name="SubSection" Type="String" />
  60. </SelectParameters>
  61. </asp:SqlDataSource>
  62. <asp:DataList ID="DataList1" runat="server" DataSourceID="SqlDataSource1" RepeatColumns="2" RepeatDirection="Horizontal" OnItemDataBound="DataList1_ItemDataBound">
  63. <ItemTemplate>
  64.  
  65. <asp:Label Runat="server" text='<%# DataBinder.Eval(Container.DataItem, "Section") %>' ID="lblSection">
  66. </asp:Label>
  67.  
  68. <br />
  69.  
  70. <asp:datalist id="Datalist2" runat="server" DataSourceID="SqlDataSource2">
  71. <ItemTemplate>
  72.  
  73. <asp:Label Runat="server" text='<%# DataBinder.Eval(Container.DataItem, "SubSection") %>' ID="lblSection">
  74. </asp:Label>
  75.  
  76. <br />
  77.  
  78. <asp:datalist id="Datalist3" runat="server" DataSourceID="SqlDataSource3">
  79. <ItemTemplate>
  80.  
  81. <!--<asp:Label Runat="server" text='<%# DataBinder.Eval(Container.DataItem, "Report") %>' ID="lblSection">
  82. </asp:Label>-->
  83.  
  84. </ItemTemplate>
  85. </asp:datalist>
  86.  
  87.  
  88. </ItemTemplate>
  89. </asp:datalist>
  90.  
  91.  
  92.  
  93. </ItemTemplate>
  94. </asp:DataList>
  95. </div>
  96. </form>
  97. </body>
  98. </html>
Add Comment
Please, Sign In to add comment