or
| Protected Sub RadGrid1_NeedDataSource(ByVal source As Object, ByVal e As GridNeedDataSourceEventArgs) Handles RadGrid1.NeedDataSource |
| Dim cmd As New SqlCommand |
| cmd.CommandText = "SELECT * FROM Products where CategoryID = @CategoryID" |
| RadGrid1.DataSource = GetDataTable(cmd) |
| End Sub |
| Public Function GetDataTable(ByVal query As SqlCommand) As DataTable |
| Dim ConnString As String = ConfigurationManager.ConnectionStrings("DBMXCatePro").ConnectionString |
| Dim conn As SqlConnection = New SqlConnection(ConnString) |
| Dim adapter As SqlDataAdapter = New SqlDataAdapter |
| query.Connection = conn |
| adapter.SelectCommand = query |
| Dim table1 As New DataTable |
| conn.Open() |
| Try |
| adapter.Fill(table1) |
| Finally |
| conn.Close() |
| End Try |
| Return table1 |
| End Function |
| <asp:AccessDataSource ID="AccessDataSource1" runat="server" |
| DataFile="~/App_Data/dbmx_with_category.mdb" |
| SelectCommand="SELECT * FROM [Categories] where isDelete = false"></asp:AccessDataSource> |
| <asp:AccessDataSource ID="AccessDataSource2" DataFile="~/App_Data/dbmx_with_category.mdb" |
| SelectCommand="SELECT * FROM [Products] where CategoryID= ? and IsDelete=false" runat="server"> |
| <SelectParameters> |
| <asp:Parameter Name="CategoryID" Type="Int32" /> |
| </SelectParameters> |
| </asp:AccessDataSource> |
| <telerik:RadGrid ID="RadGrid1" runat="server" AutoGenerateDeleteColumn="True" |
| AutoGenerateEditColumn="True" DataSourceID="AccessDataSource1" GridLines="None"> |
| <MasterTableView AutoGenerateColumns="False" DataKeyNames="categoryID" |
| DataSourceID="AccessDataSource1" HierarchyLoadMode="ServerBind"> |
| <RowIndicatorColumn> |
| <HeaderStyle Width="20px"></HeaderStyle> |
| </RowIndicatorColumn> |
| <SelfHierarchySettings KeyName="categoryID" ParentKeyName="categoryParentID" /> |
| <Columns> |
| <telerik:GridBoundColumn DataField="categoryID" DataType="System.Int32" |
| HeaderText="categoryID" ReadOnly="True" SortExpression="categoryID" |
| UniqueName="categoryID"> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn DataField="categoryTitle" HeaderText="categoryTitle" |
| SortExpression="categoryTitle" UniqueName="categoryTitle"> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn DataField="categoryIcon" HeaderText="categoryIcon" |
| SortExpression="categoryIcon" UniqueName="categoryIcon"> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn DataField="categorySequence" DataType="System.Int32" |
| HeaderText="categorySequence" SortExpression="categorySequence" |
| UniqueName="categorySequence"> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn DataField="categoryParentID" DataType="System.Int32" |
| HeaderText="categoryParentID" SortExpression="categoryParentID" |
| UniqueName="categoryParentID"> |
| </telerik:GridBoundColumn> |
| <telerik:GridCheckBoxColumn DataField="isDelete" DataType="System.Boolean" |
| HeaderText="isDelete" SortExpression="isDelete" UniqueName="isDelete"> |
| </telerik:GridCheckBoxColumn> |
| </Columns> |
| </MasterTableView> |
| </telerik:RadGrid> |
| <%@ Register assembly="Telerik.Web.UI, Version=2010.1.216.35, Culture=neutral, PublicKeyToken=121fae78165ba3d4" namespace="Telerik.Web.UI" tagprefix="telerik" %> |
| <%@ Register assembly="Telerik.Web.UI, Version=2010.1.309.40, Culture=neutral, PublicKeyToken=121fae78165ba3d4" namespace="Telerik.Web.UI" tagprefix="telerik" %> |

| <telerik:RadTreeView runat="server" ID="RadTreeView1" EnableDragAndDrop="True" OnClientMouseOver="onTreeViewMouseOver" |
| OnClientMouseOut="onTreeViewMouseOut" OnClientContextMenuItemClicking="onClientContextMenuItemClicking" |
| OnClientNodeDragStart="onTreeViewDragStart" OnDataBinding="RadTreeView1_DataBinding" |
| OnClientNodeDropping="onTreeViewDropping" OnClientContextMenuShowing="onClientContextMenuShowing" |
| OnNodeDrop="RadTreeView1_NodeDrop" OnNodeDataBound="RadTreeView1_NodeDataBound" |
| OnClientNodeDragging="onTreeViewDragging" OnNodeEdit="RadTreeView1_NodeEdit" |
| oncontextmenuitemclick="RadTreeView1_ContextClick" |
| AppendDataBoundItems="True"> |
| <ContextMenus> |
| <telerik:RadTreeViewContextMenu ID="MainContextMenu" OnDataBinding="MainContextMenu_DataBinding" runat="server"> |
| <Items> |
| <telerik:RadMenuItem Value="Rename" Text="Rename ..." Enabled="false" ImageUrl="~/Images/rename.gif" PostBack="false"></telerik:RadMenuItem> |
| <telerik:RadMenuItem Value="NewRootUnit" Text="New ..." ImageUrl="~/Images/newfolder.gif"></telerik:RadMenuItem> |
| <telerik:RadMenuItem Value="Delete" Text="Delete ..." ImageUrl="~/Images/deletefolder.gif"></telerik:RadMenuItem> |
| <telerik:RadMenuItem IsSeparator="true"></telerik:RadMenuItem> |
| <telerik:RadMenuItem Value="SetAsDefault" Text="Set as default ..." ImageUrl="~/Images/default.png"></telerik:RadMenuItem> |
| </Items> |
| <CollapseAnimation Type="InCubic" /> |
| </telerik:RadTreeViewContextMenu> |
| </ContextMenus> |
| </telerik:RadTreeView> |
| Attributes = new Dictionary<string, object> { { "TypeAttribute", "Type1" } } |