or
DataTable assets = new DataTable(); using (SqlConnection connection = new SqlConnection(ConnectionString)) { using (SqlCommand command = new SqlCommand("GetAssetHierarchyByUserId", connection)) { command.Parameters.Add(new SqlParameter("UserId", UserId)); command.CommandType = CommandType.StoredProcedure; SqlDataAdapter adapter = new SqlDataAdapter(command); connection.Open(); try { adapter.Fill(assets); } finally { connection.Close(); } }<telerik:RadMenuItem runat="server" Text="Home" Value="home" NavigateUrl="Default.aspx"> </telerik:RadMenuItem> <telerik:RadMenuItem runat="server" Text="Company" Value="about" NavigateUrl="about.aspx"> </telerik:RadMenuItem> <telerik:RadMenuItem runat="server" Text="Products" Value="products" PostBack="false" GroupSettings-OffsetX="-216"> <ContentTemplate> <div class="menuProductContent"> <table width="100%"> <tr> <td style="vertical-align:top;"> <h1><asp:Label runat="server" ID="labProductgroupsHeader" Text="Product groups"></asp:Label></h1> <telerik:RadSiteMap runat="server" ID="productIndex" EnableEmbeddedSkins="false" Skin="mrplant" DefaultLevelSettings-ListLayout-RepeatColumns="2" OnNodeDataBound="productIndex_NodeDataBound"> <Nodes> <telerik:RadSiteMapNode Text="Singlestems & sprays" NavigateUrl="products.aspx?productgroup=1"></telerik:RadSiteMapNode> <telerik:RadSiteMapNode Text="flowers" NavigateUrl="products.aspx?productgroup=2"></telerik:RadSiteMapNode> <telerik:RadSiteMapNode Text="Succulents & round shaped items" NavigateUrl="products.aspx?productgroup=3"></telerik:RadSiteMapNode> <telerik:RadSiteMapNode Text="Potted and hanging bushes" NavigateUrl="products.aspx?productgroup=4"></telerik:RadSiteMapNode> <telerik:RadSiteMapNode Text="Garlands" NavigateUrl="products.aspx?productgroup=5"></telerik:RadSiteMapNode> <telerik:RadSiteMapNode Text="Trees" NavigateUrl="products.aspx?productgroup=6"></telerik:RadSiteMapNode> <telerik:RadSiteMapNode Text="Candlerings & wreaths" NavigateUrl="products.aspx?productgroup=7"></telerik:RadSiteMapNode> </Nodes> </telerik:RadSiteMap> </td> <td style="text-align:right; vertical-align:top;"> <asp:Panel runat="server" ID="panSearch" DefaultButton="btnSearch"> <h1><asp:Label runat="server" ID="labSearchHeader" Text="Search"></asp:Label></h1> <telerik:RadTextBox runat="server" ID="txtSearch" EmptyMessage="Partno. / Description" EnableEmbeddedSkins="false" Skin="mrplant"></telerik:RadTextBox> <telerik:RadButton runat="server" ID="btnSearch" Text="Search" EnableEmbeddedSkins="false" Skin="mrplant" OnClick="btnSearch_Click"></telerik:RadButton> </asp:Panel> <br /> <asp:Panel runat="server" ID="panPage" DefaultButton="btnPage"> <%--<h1><asp:Label runat="server" ID="labPageHeader" Text="Page"></asp:Label></h1>--%> <telerik:RadNumericTextBox runat="server" ID="txtPage" NumberFormat-DecimalDigits="0" EmptyMessage="Catalogue page no." EnableEmbeddedSkins="false" Skin="mrplant"></telerik:RadNumericTextBox> <telerik:RadButton runat="server" ID="btnPage" Text="Go to" EnableEmbeddedSkins="false" Skin="mrplant" OnClick="btnPage_Click"></telerik:RadButton> </asp:Panel> </td> </tr> </table> </div> </ContentTemplate> </telerik:RadMenuItem>

