or


<telerik:GridBoundColumn DataField="Whs" FilterControlAltText="Filter Whs column" HeaderText="Whs" SortExpression="Whs" UniqueName="Whs"> </telerik:GridBoundColumn> <telerik:GridAutoCompleteColumn DataTextField="ItemNo" DataValueField="ItemNo" DataField="ItemNo" DataSourceID="sqlDS_mitmas" Filter="StartsWith" InputType="Text" HeaderText="ItemNo" UniqueName="ItemNo"> </telerik:GridAutoCompleteColumn>Protected Sub RadGrid1_ItemDeleted(sender As Object, e As Telerik.Web.UI.GridDeletedEventArgs) Handles RadGrid1.ItemDeleted Dim dataItem As GridDataItem = CType(e.Item, GridDataItem) Dim whs As String = dataItem("Whs").Text Dim itemno As String = dataItem("ItemNo").Text Dim itemname As String = dataItem("ItemName").Text Dim deletedby = User.Identity.Name.ToString() InsertHistory(whs, itemno, itemname, deletedby) End Sub
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>