or
Hi all,
I test this case in 2009 Q3 1314 and 2010 Q1 but the result is same. All of products are binding to each of category master row. But my others web page does not occur this logical bug!
please advice, thank you.
| <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> |
| <html xmlns="http://www.w3.org/1999/xhtml"> |
| <head runat="server"> |
| <title></title> |
| </head> |
| <body> |
| <form id="form1" runat="server"> |
| <div> |
| <asp:ScriptManager ID="ScriptManager1" runat="server"> |
| </asp:ScriptManager> |
| <telerik:RadAjaxManager ID="RadAjaxManager1" runat="server"> |
| <AjaxSettings> |
| <telerik:AjaxSetting AjaxControlID="RadGrid1"> |
| <UpdatedControls> |
| <telerik:AjaxUpdatedControl ControlID="RadGrid1" |
| LoadingPanelID="RadAjaxLoadingPanel1" /> |
| </UpdatedControls> |
| </telerik:AjaxSetting> |
| </AjaxSettings> |
| </telerik:RadAjaxManager> |
| <telerik:RadAjaxLoadingPanel ID="RadAjaxLoadingPanel1" runat="server" Skin="Default"> |
| </telerik:RadAjaxLoadingPanel> |
| <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" runat="server" |
| DataFile="~/App_Data/dbmx_with_category.mdb" |
| SelectCommand="SELECT * FROM [Products] where isDelete= False"></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"> |
| <DetailTables> |
| <telerik:GridTableView runat="server" DataKeyNames="productID" |
| DataSourceID="AccessDataSource2"> |
| <ParentTableRelation> |
| <telerik:GridRelationFields DetailKeyField="categoryID" |
| MasterKeyField="categoryID" /> |
| </ParentTableRelation> |
| <RowIndicatorColumn> |
| <HeaderStyle Width="20px" /> |
| </RowIndicatorColumn> |
| <ExpandCollapseColumn> |
| <HeaderStyle Width="20px" /> |
| </ExpandCollapseColumn> |
| </telerik:GridTableView> |
| </DetailTables> |
| <RowIndicatorColumn> |
| <HeaderStyle Width="20px"></HeaderStyle> |
| </RowIndicatorColumn> |
| <ExpandCollapseColumn Visible="True"> |
| <HeaderStyle Width="20px"></HeaderStyle> |
| </ExpandCollapseColumn> |
| <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> |
| </div> |
| </form> |
| </body> |
| </html> |
| <telerik:RadSiteMap runat="server" ID="RadSiteMap1" |
| DataSourceID="SiteMapDataSource1" DataNavigateUrlField="Url" |
| DataTextField="Title"> |
| <LevelSettings> |
| <telerik:SiteMapLevelSetting Level="3" MaximumNodes="0"> |
| <NodeTemplate> |
| <a href="<%# DataBinder.Eval(Container.DataItem, "url") %>"> |
| <%# DataBinder.Eval(Container.DataItem, "title") %></a> |
| </NodeTemplate> |
| </telerik:SiteMapLevelSetting> |
| <telerik:SiteMapLevelSetting Level="4" MaximumNodes="0"> |
| <NodeTemplate> |
| <div> |
| <span class="qmdivider qmdividerx" ></span> |
| <a href="<%# DataBinder.Eval(Container.DataItem, "url") %>"> |
| <%# DataBinder.Eval(Container.DataItem, "title") %> |
| </a> |
| </div> |
| </NodeTemplate> |
| </telerik:SiteMapLevelSetting> |
| </LevelSettings> |
| </telerik:RadSiteMap> |