Telerik Forums
UI for ASP.NET AJAX Forum
or
Ask question
All Questions
Unanswered
Answered
110,789 questions
1 answer
86 views
hierarchical radgrid structure expanded state

I have the following hierarchical radgrid structure.i have a linkbutton inside the inner grid.i need to keep the expanded state of the grid once i click on the link button and rebind the grid. i have tried the http://www.telerik.com/community/code-library/aspnet-ajax/grid/retain-expanded-selected-state-in-hierarchy-on-rebind.aspx post but on the post back inner grid doesn't appear.plz help 

  <telerik:RadGrid ID="RadGrid1" OnPreRender="RadGrid1_PreRender" DataSourceID="SqlDataSource1"  
        runat="server" AutoGenerateColumns="False" AllowSorting="True" AllowMultiRowSelection="False"  Skin="Office2007" 
        AllowPaging="True" PageSize="5" GridLines="None" ShowGroupPanel="true" OnItemCreated="RadGrid1_ItemCreated"
        OnItemCommand="RadGrid1_ItemCommand" OnDataBound="RadGrid1_DataBound">
        <PagerStyle Mode="NumericPages"></PagerStyle>
        <MasterTableView DataSourceID="SqlDataSource1" DataKeyNames="ProjectID" AllowMultiColumnSorting="True"
            GroupLoadMode="Server">
            <NestedViewTemplate>
                <asp:Panel runat="server" ID="InnerContainer" CssClass="viewWrap" Visible="false">
                    <telerik:RadTabStrip runat="server" ID="TabStip1" MultiPageID="Multipage1" SelectedIndex="0" >
                        <Tabs>
                            <telerik:RadTab runat="server" Text="Major Release" PageViewID="PageView1">
                            </telerik:RadTab>
                            <telerik:RadTab runat="server" Text="Minor Release" PageViewID="PageView2">
                            </telerik:RadTab>
                          
                        </Tabs>
                    </telerik:RadTabStrip>
                    <telerik:RadMultiPage runat="server" ID="Multipage1" SelectedIndex="0" RenderSelectedPageOnly="false">
                        <telerik:RadPageView runat="server" ID="PageView1">
                            <asp:Label ID="Label1" Font-Bold="true" Font-Italic="true" Text='<%# Eval("ProjectID") %>'
                                Visible="false" runat="server" />
                            <telerik:RadGrid runat="server" ID="OrdersGrid" DataSourceID="SqlDataSource2" ShowFooter="true"  
                                AllowSorting="true" EnableLinqExpressions="false">
                                <MasterTableView ShowHeader="true" AutoGenerateColumns="False" AllowPaging="true"
                                    DataKeyNames="VersionID" PageSize="7" HierarchyLoadMode="ServerOnDemand">
                                    <DetailTables>
                                        <telerik:GridTableView AutoGenerateColumns="false" DataKeyNames="VersionID" DataSourceID="SqlDataSource3"
                                            Width="100%">
                                            <ParentTableRelation>
                                                <telerik:GridRelationFields DetailKeyField="VersionID" MasterKeyField="VersionID" />
                                            </ParentTableRelation>
                                            <Columns>
                                                <telerik:GridBoundColumn SortExpression="ItemCode" HeaderText="Item Code" HeaderButtonType="TextButton"
                                                    DataField="ItemCode" UniqueName="ItemCode">
                                                </telerik:GridBoundColumn>
                                                <telerik:GridBoundColumn SortExpression="ItemDescription" HeaderText="Item Description" HeaderButtonType="TextButton"
                                                    DataField="ItemDescription" UniqueName="ItemDescription">
                                                </telerik:GridBoundColumn>
                                               
                                            </Columns>
                                            <SortExpressions>
                                                <telerik:GridSortExpression FieldName="ItemCode" SortOrder="Descending"></telerik:GridSortExpression>
                                            </SortExpressions>
                                        </telerik:GridTableView>
                                    </DetailTables>
                                    <Columns>
                                        <telerik:GridBoundColumn SortExpression="VersionNo" HeaderText="Version No." HeaderButtonType="TextButton"
                                            DataField="VersionNo" UniqueName="VersionNo">
                                        </telerik:GridBoundColumn>
                                         <telerik:GridBoundColumn SortExpression="ModuleName" HeaderText="Module Name" HeaderButtonType="TextButton"
                                            DataField="ModuleName" UniqueName="ModuleName">
                                        </telerik:GridBoundColumn>
                                          <telerik:GridBoundColumn SortExpression="ApplicationName" HeaderText="Application Name" HeaderButtonType="TextButton"
                                            DataField="ApplicationName" UniqueName="ApplicationName">
                                        </telerik:GridBoundColumn>
                                         <telerik:GridBoundColumn SortExpression="Date" HeaderText="Relase Date" HeaderButtonType="TextButton"
                                            DataField="Date" UniqueName="Date"  DataFormatString="{0:dd/MM/yyyy}">
                                        </telerik:GridBoundColumn>
                                        <%-- <telerik:GridBoundColumn SortExpression="Confirmation" HeaderText="Confirmation" HeaderButtonType="TextButton"
                                            DataField="Confirmation" UniqueName="Confirmation">
                                        </telerik:GridBoundColumn>--%>
                                       <telerik:GridTemplateColumn HeaderText="Confirmation">
                                       <ItemTemplate>
                                       
                                          <asp:LinkButton ID="lbConfirmaton" runat="server" CommandArgument='<%# Eval("VersionID")%>' Text='<%# Eval("Confirmation") %>' OnCommand="lbConfirmaton_Click"></asp:LinkButton>
                                      
                                       </ItemTemplate>
                                       </telerik:GridTemplateColumn>
                                    </Columns>
                                </MasterTableView>
                            </telerik:RadGrid>
                            <asp:SqlDataSource ID="SqlDataSource2" ConnectionString="<%$ ConnectionStrings:ConVersionControl %>"
                                ProviderName="System.Data.SqlClient" SelectCommand="select p.ProjectID,p.ProjectName,v.VersionID,
                                v.VersionNo,v.Date,v.Confirmation,v.VersionType,v.ModuleID,m.ModuleName,a.ApplicationName  
from 
tblProject p inner join tblApplication a on a.ProjectID=p.ProjectID inner join
 tblVersion v on a.ApplicationID=v.ApplicationID inner join tblModule m
on m.ModuleID=v.ModuleID
where p.ProjectID=@ProjectID and v.VersionType='Major'
 order by m.ModuleName asc"
                                runat="server">
                                <SelectParameters>
                                    <asp:ControlParameter ControlID="Label1" PropertyName="Text" Type="String" Name="ProjectID" />
                                </SelectParameters>
                            </asp:SqlDataSource>
                            <asp:SqlDataSource ID="SqlDataSource3" ConnectionString="<%$ ConnectionStrings:ConVersionControl %>"
                                ProviderName="System.Data.SqlClient" SelectCommand="
                               select p.ProjectID,p.ProjectName,v.VersionID,v.VersionNo,v.Date,v.Confirmation,v.VersionType,v.Confirmation
,m.ModuleID,t.ItemID,t.ItemCode,t.ItemDescription,m.ModuleName,a.ApplicationName
 from
tblProject p inner join tblApplication a
 on a.ProjectID=p.ProjectID inner join
 tblVersion v on a.ApplicationID=
v.ApplicationID
inner join tblItem t on t.VersionID=v.VersionID
inner join tblModule m on m.ModuleID=v.ModuleID
where v.VersionType='Major' and v.VersionID=@VersionID and p.ProjectID=@ProjectID"
                                runat="server">
                                <SelectParameters>
                                    <asp:SessionParameter Name="VersionID" SessionField="VersionID" Type="Int32" />
                                      <asp:ControlParameter ControlID="Label1" PropertyName="Text" Type="String" Name="ProjectID" />
                                </SelectParameters>
                            </asp:SqlDataSource>
                        </telerik:RadPageView>
                        <telerik:RadPageView runat="server" ID="PageView2">
                           <telerik:RadGrid runat="server" ID="RadGrid2" DataSourceID="SqlDataSource5" ShowFooter="true" 
                                AllowSorting="true" EnableLinqExpressions="false">
                                <MasterTableView ShowHeader="true" AutoGenerateColumns="False" AllowPaging="true"
                                    DataKeyNames="VersionID" PageSize="7" HierarchyLoadMode="ServerOnDemand">
                                    <DetailTables>
                                        <telerik:GridTableView AutoGenerateColumns="false" DataKeyNames="VersionID" DataSourceID="SqlDataSource6"
                                            Width="100%">
                                            <ParentTableRelation>
                                                <telerik:GridRelationFields DetailKeyField="VersionID" MasterKeyField="VersionID" />
                                            </ParentTableRelation>
                                            <Columns>
                                                <telerik:GridBoundColumn SortExpression="ItemCode" HeaderText="Item Code" HeaderButtonType="TextButton"
                                                    DataField="ItemCode" UniqueName="ItemCode">
                                                </telerik:GridBoundColumn>
                                                <telerik:GridBoundColumn SortExpression="ItemDescription" HeaderText="Item Description" HeaderButtonType="TextButton"
                                                    DataField="ItemDescription" UniqueName="ItemDescription">
                                                </telerik:GridBoundColumn>
                                               
                                            </Columns>
                                            <SortExpressions>
                                                <telerik:GridSortExpression FieldName="ItemCode" SortOrder="Descending"></telerik:GridSortExpression>
                                            </SortExpressions>
                                        </telerik:GridTableView>
                                    </DetailTables>
                                    <Columns>
                                        <telerik:GridBoundColumn SortExpression="VersionNo" HeaderText="Version No." HeaderButtonType="TextButton"
                                            DataField="VersionNo" UniqueName="VersionNo">
                                        </telerik:GridBoundColumn>
                                         <telerik:GridBoundColumn SortExpression="ModuleName" HeaderText="Module Name" HeaderButtonType="TextButton"
                                            DataField="ModuleName" UniqueName="ModuleName">
                                        </telerik:GridBoundColumn>
                                         <telerik:GridBoundColumn SortExpression="ApplicationName" HeaderText="Application Name" HeaderButtonType="TextButton"
                                            DataField="ApplicationName" UniqueName="ApplicationName">
                                        </telerik:GridBoundColumn>
                                         <telerik:GridBoundColumn SortExpression="Date" HeaderText="Relase Date" HeaderButtonType="TextButton"
                                            DataField="Date" UniqueName="Date"  DataFormatString="{0:dd/MM/yyyy}">
                                        </telerik:GridBoundColumn>
                                         <%--<telerik:GridBoundColumn SortExpression="Confirmation" HeaderText="Confirmation" HeaderButtonType="TextButton"
                                            DataField="Confirmation" UniqueName="Confirmation">
                                        </telerik:GridBoundColumn>--%>
                                        <telerik:GridTemplateColumn HeaderText="Confirmation">
                                       <ItemTemplate>
                                           <asp:LinkButton ID="lbConfirmaton" runat="server" CommandArgument='<%# Eval("VersionID")%>' Text='<%# Eval("Confirmation") %>' OnCommand="lbConfirmaton_Click"></asp:LinkButton>
                                       </ItemTemplate>
                                       </telerik:GridTemplateColumn>
                                    </Columns>
                                </MasterTableView>
                            </telerik:RadGrid>
                            <asp:SqlDataSource ID="SqlDataSource5" ConnectionString="<%$ ConnectionStrings:ConVersionControl %>"
                                ProviderName="System.Data.SqlClient" SelectCommand="select p.ProjectID,p.ProjectName,v.VersionID,v.VersionNo,v.Date,v.Confirmation,
                                v.VersionType,v.ModuleID,m.ModuleName,a.ApplicationName  
from 
tblProject p inner join tblApplication a
 on a.ProjectID=p.ProjectID inner join
 tblVersion v on a.ApplicationID=
v.ApplicationID inner join tblModule m
on m.ModuleID=v.ModuleID
where p.ProjectID=@ProjectID and v.VersionType='Minor'
 order by m.ModuleName asc"
                                runat="server">
                                <SelectParameters>
                                    <asp:ControlParameter ControlID="Label1" PropertyName="Text" Type="String" Name="ProjectID" />
                                </SelectParameters>
                            </asp:SqlDataSource>
                            <asp:SqlDataSource ID="SqlDataSource6" ConnectionString="<%$ ConnectionStrings:ConVersionControl %>"
                                ProviderName="System.Data.SqlClient" SelectCommand="
                               select p.ProjectID,p.ProjectName,v.VersionID,v.VersionNo,v.Date,v.Confirmation,v.VersionType
,m.ModuleID,t.ItemID,t.ItemCode,t.ItemDescription,m.ModuleName
 from
tblProject p inner join tblApplication a
 on a.ProjectID=p.ProjectID inner join
 tblVersion v on a.ApplicationID=
v.ApplicationID
inner join tblItem t on t.VersionID=v.VersionID
inner join tblModule m on m.ModuleID=v.ModuleID
where v.VersionType='Minor' and v.VersionID=@VersionID and p.ProjectID=@ProjectID"
                                runat="server">
                                <SelectParameters>
                                    <asp:SessionParameter Name="VersionID" SessionField="VersionID" Type="Int32"/>
                                      <asp:ControlParameter ControlID="Label1" PropertyName="Text" Type="String" Name="ProjectID" />
                                </SelectParameters>
                            </asp:SqlDataSource>
                        </telerik:RadPageView>
                       
                    </telerik:RadMultiPage>
                </asp:Panel>
            </NestedViewTemplate>
            <Columns>
                <telerik:GridBoundColumn SortExpression="ProjectName" HeaderText="Project Name" HeaderButtonType="TextButton"
                    DataField="ProjectName" UniqueName="ProjectName">
                </telerik:GridBoundColumn>
                <telerik:GridBoundColumn SortExpression="VersionNo" HeaderText="Latest Version No." HeaderButtonType="TextButton"
                    DataField="VersionNo" UniqueName="VersionNo">
                </telerik:GridBoundColumn>
                <telerik:GridBoundColumn SortExpression="RelaseDate" DataFormatString="{0:dd/MM/yyyy}"
                    HeaderText="Relase Date" HeaderButtonType="TextButton" DataField="RelaseDate" UniqueName="RelaseDate">
                </telerik:GridBoundColumn>
               
            </Columns>
        </MasterTableView>
        <ClientSettings AllowDragToGroup="true" />
    </telerik:RadGrid>
General Discussions
Radoslav
Telerik team
 answered on 12 Sep 2012
4 answers
131 views
[Solved] Check if event was cancelled after calling client side updateItem
Is there a way to find out if the event was cancelled on the server after calling grid table view updateItem method from the client?
Grid
Hosney
Top achievements
Rank 1
 answered on 12 Sep 2012
3 answers
197 views
Contextmenu in empty grid
Hi,

    I have a tree view with folder structure. when i double click on any folder it displays all files and folder in a grid. that grid consisiting of context menu with some options. now my question is how to display context menu on grid when i double click on folder if that folder contains no records and folders(means displaying context menu on empty Rad Grid).

Thanks in adv
usha.
General Discussions
Antonio Stoilkov
Telerik team
 answered on 12 Sep 2012
0 answers
46 views
User control Properties
hello people.
i have created an User Control in which i am using telerik grid and all its properties(ascx page)
Now if i am create one aspx page in the same solution and try to use that control its working all fine

but when i copy all the control files in some other solution
some properties are working, some are not like(filtering,paging and skin)
please help me out

thanks
Prince
Grid
Prince
Top achievements
Rank 1
 asked on 12 Sep 2012
2 answers
288 views
Unable to add empty item in combobox on prerender
I load a RadCombo box via a store procedure.  To that list I want to add an "All" item at position 0.

I tried doing it this way:

 
protected void rcbYear_PreRender(object sender, EventArgs e)
        {
            RadComboBox combo = sender as RadComboBox;
            if (ViewState[combo.ClientID] != null)
            {
                var rcbi = new RadComboBoxItem();
                rcbi.Attributes.Add("0", "All");
                combo.Items.Insert(0, rcbi);
                combo.DataBind();
            }
        }

I verified that when the combo box comes in has the values from the store proc.  The method runs normally but the combo ends with the same items as when it came in.

Any ideas?

ComboBox
a.wilks
Top achievements
Rank 1
 answered on 12 Sep 2012
1 answer
142 views
[Solved] Radgrid and Javascript 
<telerik:RadGrid ID="rgLabelManager" runat="server" Skin="ARC" AutoGenerateColumns="false" 
GridLines="None" AllowSorting="true" AllowPaging="true" PageSize="10"  
OnNeedDataSource="LabelManager_NeedDataSource" OnItemDataBound="LabelManager_ItemDataBound" 
OnUpdateCommand="LabelManager_UpdateCommand" OnInsertCommand="LabelManager_InsertCommand"> 
<PagerStyle Mode="NextPrevAndNumeric" />         
<MasterTableView Width="100%" AutoGenerateColumns="false" EditMode="InPlace" 
CommandItemDisplay="TopAndBottom"> 
<Columns> 
<telerik:GridTemplateColumn  UniqueName="ContactName" SortExpression="LastName" HeaderText="Contact Name" 
ItemStyle-Width="60%" ItemStyle-HorizontalAlign="Left"> 
<ItemTemplate> <%#((String)DataBinder.Eval(Container.DataItem, "FirstName")).Substring(0,1).ToUpper()%>
<%#((String)DataBinder.Eval(Container.DataItem, "FirstName")).Substring(1).ToLower()%>    
<%#((String)DataBinder.Eval(Container.DataItem, "LastName")).Substring(0,1).ToUpper()%>
<%#((String)DataBinder.Eval(Container.DataItem, "LastName")).Substring(1).ToLower()%> 
</ItemTemplate> 
<EditItemTemplate> 

<telerik:RadComboBox ID="rcbContactName" runat="server" EnableVirtualScrolling="true" 
ShowMoreResultsBox="true" ItemsPerRequest="10" EnableLoadOnDemand="true" Width="400" 
OnClientItemsRequesting="GenericRadCombo_OnClientItemsRequesting"  
OnClientItemsRequested="rcbLookupContact_OnClientItemsRequested" 
OnClientDropDownClosing="rcbLookupContact_OnClientDropDownClosing"> 
<WebServiceSettings Method="LookupContact" Path="~/service/scriptservice.asmx" /> 
</telerik:RadComboBox> &nbsp;&nbsp; 
<asp:LinkButton runat="server" ID="lbAdd" Text="Add New Contact" style="display:none;" 
OnClick="lnkAddContact_Click"></asp:LinkButton>
</EditItemTemplate> 
</telerik:GridTemplateColumn> 

I want to access "lbAdd" from Javascript and keep getting error that lbAdd in not in the context.  I've tried 
$find('<%=lbAdd.ClientID %>')  and 
document.getElementById("<%=lbAdd.ClientID %>")

Please let me know if I'm missing something to access lbAdd - I need to change the display based on different conditions.
General Discussions
Princy
Top achievements
Rank 2
 answered on 12 Sep 2012
3 answers
139 views
Vertical Docking for RadSplitContainer
Hi All,

      How to make a StackPanel dockable vertically.

Thanks in Advance.
General Discussions
Princy
Top achievements
Rank 2
 answered on 12 Sep 2012
3 answers
194 views
Setting DropDownWidth of GridDropDownColumn
Hello everyone,
I'm searching for a solution to set a DropDownWidth in my GridDropDownColumn.
I'm loading the Grid dynamically, just like this demo and I want to be able to edit and insert data in this Grid.
So there are this GridDropDownColumns and the text is showing in two lines, but I want to be able to set the width so that the text is in one line and the Combobox of this GridDropDownColumns is larger. Is there a solution for this problem?

Thanks in advance,
Esmi
Grid
Shinu
Top achievements
Rank 2
 answered on 12 Sep 2012
3 answers
105 views
Custom Filtering then radgrid filter
here my code:
KTFrameworkCusEntities dcc = new KTFrameworkCusEntities();
IQueryable<udv_Articles> _udvResult;
    public IEnumerable<udv_Articles> getAllArticleByCat(int catid)
    {
  
        //KTFrameworkCusEntities dc = new KTFrameworkCusEntities();
        //_udvPro = null;
        _udvResult = dcc.udv_Articles.Include("udv_Categories").Where(t => t.ArticleID == 99999999);
        loadArticlebyCate(catid);
        return _udvResult.OrderByDescending(t => t.UpdatedDate).ToList();
    }
  
    protected IQueryable<udv_Articles> loadArticlebyCate(int caid)
    {
        //KTFrameworkCusEntities dc = new KTFrameworkCusEntities();
  
        Func<KTFrameworkCusEntities, IQueryable<udv_Articles>> _IEProList = CompiledQuery.Compile((KTFrameworkCusEntities ne) => ne.udv_Articles.Include("udv_Categories").Where(t => t.udv_Categories.CateID == caid));
  
        if (_IEProList(dcc).Count() > 0)
        {
            _udvResult = _udvResult.Concat(_IEProList(dcc));
        }
        IEnumerable<udv_Categories> _IECatList = dcc.udv_Categories.Where(c => c.ParentID == caid);
        if (_IECatList.Count() > 0)
        {
            foreach (var item in _IECatList)
            {
                loadArticlebyCate(item.CateID);
            }
        }
  
        return _udvResult;
    }
 
IQueryable<udv_Categories> _udvResult2;
    public IEnumerable<udv_Categories> getAllCategoriesByCat(int catid)
    {
        //KTFrameworkCusEntities dc = new KTFrameworkCusEntities();
        //_udvPro = null;
        _udvResult2 = dcc.udv_Categories.Where(t => t.CateID == 99999999);
        loadCategorybyCate(catid);
        return _udvResult2.Where(t => t.IsActive == true).OrderBy(t => t.DisplayOrder).ToList();
    }
 
    protected IQueryable<udv_Categories> loadCategorybyCate(int caid)
    {
        //KTFrameworkCusEntities dc = new KTFrameworkCusEntities();
 
        Func<KTFrameworkCusEntities, IQueryable<udv_Categories>> _IEProList = CompiledQuery.Compile((KTFrameworkCusEntities ne) => ne.udv_Categories.Where(t => t.ParentID == caid));
 
        //IEnumerable<udv_Categories> _IEProList = dc.udv_Categories.Where(t => t.ParentID == caid);
        //IEnumerable<udv_Articles> _IEProList = from c in dc.udv_Articles where c.udv_Categories.CateID == caid select c;
        if (_IEProList(dcc).Count() > 0)
        {
            _udvResult2 = _udvResult2.Concat(_IEProList(dcc));
        }
        IEnumerable<udv_Categories> _IECatList = dcc.udv_Categories.Where(c => c.ParentID == caid);
        if (_IECatList.Count() > 0)
        {
            foreach (var item in _IECatList)
            {
                loadCategorybyCate(item.CateID);
            }
        }
        return _udvResult2;
 
    }

<telerik:RadGrid ID="RadGrid1" AllowFilteringByColumn="true" PageSize="20" ShowFooter="True"
    AllowPaging="True" AutoGenerateColumns="false" GridLines="None" ShowStatusBar="true"
    runat="server" OnItemDataBound="RadGrid1_ItemDataBound">
    <GroupingSettings CaseSensitive="false" />
    <MasterTableView EditMode="InPlace" AllowFilteringByColumn="True" ShowFooter="True"
        DataKeyNames="ArticleID" TableLayout="Fixed">
        <Columns>
            <telerik:GridBoundColumn DataField="Title" HeaderText="Tiêu đề" AutoPostBackOnFilter="true"
                CurrentFilterFunction="Contains" ShowFilterIcon="false">
                <HeaderStyle Width="25%" />
            </telerik:GridBoundColumn>
 
           <telerik:GridTemplateColumn DataField="CateID" HeaderText="Danh mục" UniqueName="CateID"
                    HeaderStyle-Width="200px" SortExpression="DisplayOrder">
                    <FilterTemplate>
                        <telerik:RadComboBox ID="RadComboBoxCategories" DataTextField="Title"
                        
                            DataValueField="CateID" Height="100px" AppendDataBoundItems="true"
                            runat="server" >
                            <Items>
                                <telerik:RadComboBoxItem Text="All" />
                            </Items>
                        </telerik:RadComboBox>                          
                    </FilterTemplate>
                    <ItemTemplate>
                       <%# Eval("udv_Categories.Title") %>
                    </ItemTemplate>
                </telerik:GridTemplateColumn>
        </Columns>
    </MasterTableView>
</telerik:RadGrid>

if(!ispostback){
  RadGrid1.DataSource = getAllArticleByCat(113);
                RadGrid1.DataBind();
}
 
protected void RadGrid1_ItemDataBound(object sender, Telerik.Web.UI.GridItemEventArgs e)
    {
        if (e.Item is GridFilteringItem)
        {
            GridFilteringItem item = (GridFilteringItem)e.Item;
            RadComboBox combo = (RadComboBox)item.FindControl("RadComboBoxCategories");
            using (dmsFunction dmsf = new dmsFunction())
            {
                combo.DataSource = getCategoryByParent(113).ToList();
                combo.DataBind();
                combo.AutoPostBack = true;
                combo.SelectedIndexChanged += new RadComboBoxSelectedIndexChangedEventHandler(combo_SelectedIndexChanged);
            }
        }
    }
 
    void combo_SelectedIndexChanged(object sender, RadComboBoxSelectedIndexChangedEventArgs e)
    {
       // Custom Filter: Call getAllArticleByCat(Convert.ToInt32(combo.SelectedValue)) to get all Article by Categories
       // Then RadGrid Filter
          // Teach me how... Thanks
    }
Grid
Shinu
Top achievements
Rank 2
 answered on 12 Sep 2012
0 answers
90 views
Problem in grid Hierarchy
Hi guys,

I have a problem in displaying the data from an sql table in an hierarchic way, as you can see in the screenshot (http://agileprecis.com/db-diagram.jpg), the table tasks will contain endless sub tasks for each task and it's using the referewnce ParentTaskID.

The problem in the grid display is it is displaying the subTasks as a normal row, wil it shouldn't appear unless i expand the specific node.

below is the code i'm using:
<telerik:RadGrid ID="DataGrid" runat="server" ShowStatusBar="True" AllowFilteringByColumn="True"                    AllowAutomaticUpdates="false" Width="100%" AllowAutomaticInserts="false" AllowAutomaticDeletes="false"
AllowPaging="True" PageSize="7" ShowGroupPanel="True">
<MasterTableView AutoGenerateColumns="False" AllowSorting="true" CommandItemDisplay="Top"
AllowAutomaticUpdates="false" AllowAutomaticInserts="false" AllowAutomaticDeletes="false"
HierarchyDefaultExpanded="false" HierarchyLoadMode="Client" DataKeyNames="TaskID, ParentTaskID" Width="100%">
                                                                
<SelfHierarchySettings ParentKeyName="ParentTaskID" KeyName="TaskID" />
<HeaderStyle HorizontalAlign="Center" /><FilterItemStyle HorizontalAlign="Center" />
<NoRecordsTemplate>No Records Found.</NoRecordsTemplate>
<Columns>
<telerik:GridButtonColumn UniqueName="Edit" CommandName="Edit" ButtonType="ImageButton"
 ImageUrl="~/Styles/images/icon_edit.gif" Text="Edit" HeaderText="Edit">
<HeaderStyle Width="35px" HorizontalAlign="center" />
 </telerik:GridButtonColumn>
 
<telerik:GridBoundColumn DataField="TaskID" Visible="True" HeaderText="TaskID" ReadOnly="True"
SortExpression="TaskID" UniqueName="TaskID"></telerik:GridBoundColumn>
                                                                     
<telerik:GridBoundColumn DataField="TaskTitle" HeaderText="TaskTitle" SortExpression="TaskTitle"
UniqueName="TaskTitle"> </telerik:GridBoundColumn>
                                                                     
<telerik:GridBoundColumn DataField="ParentTaskID" HeaderText="ParentTaskID" SortExpression="ParentTaskID"
Visible="True" UniqueName="ParentTaskID"> </telerik:GridBoundColumn>
                                                                 
</Columns>
</MasterTableView>
</telerik:RadGrid>

Thanks for your support
Grid
Mike_T
Top achievements
Rank 1
 asked on 11 Sep 2012
Narrow your results
Done
Selected tags
Tags
Grid
General Discussions
Editor
Scheduler
ComboBox
Ajax
Window
TreeView
Menu
Calendar
Chart (Obsolete)
TabStrip
Input
Dock
ToolTip
Upload (Obsolete)
AsyncUpload
WebParts for SharePoint
PanelBar
FileExplorer
Splitter
ListBox
Chart (HTML5)
Rotator
ListView
Button
ToolBar
TreeList
Sharepoint Integration
FormDecorator
Filter
Slider
ScriptManager and StyleSheetManager
UI for ASP.NET AJAX in ASP.NET MVC
AutoCompleteBox
PivotGrid
Installer and VS Extensions
Spell
Documentation and Tutorials
ImageEditor
Captcha
RibbonBar
DropDownList
OrgChart
Visual Style Builder
DropDownTree
Gantt
ColorPicker
Notification
BinaryImage
SkinManager
TileList
Wizard
SearchBox
Spreadsheet
Map
ImageGallery
Rating
DatePicker
MediaPlayer
XmlHttpPanel
Diagram
Compression
DataPager
SiteMap
CloudUpload
LightBox
Gauge
PageLayout
AjaxLoadingPanel
Navigation
SocialShare
DataForm
Persistence Framework
ClientExportManager
ProgressArea
CheckBox
TagCloud
AjaxPanel
Barcode
ClientDataSource
NumericTextBox
PdfViewer
DateTimePicker
MultiColumnComboBox
MultiSelect
RadioButtonList
MaskedTextBox
Theme Builder
Styling
ProgressBar
DateInput
Chat
Licensing
ODataDataSource
MonthYearPicker
TimePicker
LinkButton
ToggleButton
Accessibility
Label
Localization
DateRangePicker
Security
TreeMap
ImageButton
InputManager
Timeline
Card
Drawer
PushButton
Ticker
Signature
Avatar
Switch
OTPInput
Breadcrumb
SplitButton
DragDropManager
Stepper
FloatingActionButton
Chip
ChipList
AIPrompt
Badge
SpeechToText
SmartPasteButton
+? more
Top users last month
Bohdan
Top achievements
Rank 3
Iron
Iron
Iron
Rob
Top achievements
Rank 3
Bronze
Bronze
Iron
Elliot
Top achievements
Rank 1
Iron
Iron
Iron
Sunil
Top achievements
Rank 1
Cynthia
Top achievements
Rank 1
Iron
Iron
Iron
Want to show your ninja superpower to fellow developers?
Learn how
3630 3631
3632
3633 3634
Top users last month
Bohdan
Top achievements
Rank 3
Iron
Iron
Iron
Rob
Top achievements
Rank 3
Bronze
Bronze
Iron
Elliot
Top achievements
Rank 1
Iron
Iron
Iron
Sunil
Top achievements
Rank 1
Cynthia
Top achievements
Rank 1
Iron
Iron
Iron
Want to show your ninja superpower to fellow developers?
Learn how
Want to show your ninja superpower to fellow developers?
Learn how