Hi,

I'm working radGridView control for displaying self referencial and hierarchal data, i'm using the latest telerik binaries (i.e.WPF Q1 2010 SP2).

With my current code, this displays as:

Task 1
-- Task101
-- Task102
Task 2
-- Task201
-- Task202
Task101
Task102
Task201
Task202

I dont want to display Task101,Task102,Task201,Task202 in the main hirerarchy list, as those are the childs to Task1 and Task2

Code Pasted Below:

XAML:

 <Grid>
        <telerik:RadGridView x:Name="RadGridView1"
             DataLoading="RadGridView1_DataLoading" RowLoaded="RadGridView1_RowLoaded" GridLinesVisibility="Horizontal"
            CanUserFreezeColumns="False" IsReadOnly="True" AutoGenerateColumns="False"  >

            <telerik:RadGridView.Columns>
                <telerik:GridViewDataColumn  DataMemberBinding="{Binding TaskId}"  />
               
                <telerik:GridViewDataColumn Header="Task Name" DataMemberBinding="{Binding TaskName}" />

                <telerik:GridViewDataColumn Header="Read">
                    <telerik:GridViewColumn.CellTemplate>
                        <DataTemplate>
                            <CheckBox x:Name="checkBoxRead" IsChecked="{Binding Read}" />
                        </DataTemplate>
                    </telerik:GridViewColumn.CellTemplate>
                </telerik:GridViewDataColumn>

                <telerik:GridViewDataColumn Header="Write">
                    <telerik:GridViewColumn.CellTemplate>
                        <DataTemplate>
                            <CheckBox x:Name="checkBoxWrite" IsChecked="{Binding Write}" />
                        </DataTemplate>
                    </telerik:GridViewColumn.CellTemplate>
                </telerik:GridViewDataColumn>

            </telerik:RadGridView.Columns>

            <telerik:RadGridView.ChildTableDefinitions>
                <telerik:GridViewTableDefinition>
                    <telerik:GridViewTableDefinition.Relation  >
                        <telerik:TableRelation IsSelfReference="True" >
                            <telerik:TableRelation.FieldNames>
                                <telerik:FieldDescriptorNamePair
                                    ParentFieldDescriptorName="TaskId"
                                    ChildFieldDescriptorName="ParentTaskId" />
                            </telerik:TableRelation.FieldNames>
                        </telerik:TableRelation>
                    </telerik:GridViewTableDefinition.Relation>
                </telerik:GridViewTableDefinition>
            </telerik:RadGridView.ChildTableDefinitions>

        </telerik:RadGridView>
    </Grid>

.CS Code:

/// <summary>
    /// Interaction logic for MainWindow.xaml
    /// </summary>
    public partial class MainWindow : Window
    {
        public MainWindow()
        {
            InitializeComponent();
            //RadGridView1. .MasterTableView.FilterExpression = "ParentID = 0";
            RadGridView1.ItemsSource = GetTasks();
           
        }

        private List<Task> GetTasks()
        {
            List<Task> tasks = new List<Task>();

            tasks.Add(new Task { TaskId = 1, TaskName = "Task1", Read = true, Write = true, ParentTaskId = 0 });
            tasks.Add(new Task { TaskId = 2, TaskName = "Task2", Read = false, Write = true, ParentTaskId = 0 });

            tasks.Add(new Task { TaskId = 101, TaskName = "Task101", Read = true, Write = true, ParentTaskId = 1 });
            tasks.Add(new Task { TaskId = 102, TaskName = "Task102", Read = false, Write = false, ParentTaskId = 1 });

            tasks.Add(new Task { TaskId = 201, TaskName = "Task201", Read = true, Write = true, ParentTaskId = 2 });
            tasks.Add(new Task { TaskId = 202, TaskName = "Task202", Read = false, Write = false, ParentTaskId = 2 });

            //tasks.Add(new Task { TaskId = 1011, TaskName = "Task1011", Read = true, Write = false, ParentTaskId = 101 });

         
            return tasks;
        }

        private bool HasSubTasks(Task currentTask)
        {
            return
            (from task in (IEnumerable<Task>)this.RadGridView1.ItemsSource
             where task.ParentTaskId == currentTask.TaskId
             select task).Any();
        }

        private void RadGridView1_RowLoaded(object sender, Telerik.Windows.Controls.GridView.RowLoadedEventArgs e)
        {

            GridViewRow row = e.Row as GridViewRow;
            Task currentTask = e.DataElement as Task;

            if (row != null && currentTask != null)
            {
                row.IsExpandable = this.HasSubTasks(currentTask);
            }
        }

        private void RadGridView1_DataLoading(object sender, GridViewDataLoadingEventArgs e)
        {
            GridViewDataControl dataControl = (GridViewDataControl)sender;

            if (dataControl.ParentRow != null)
            {
                dataControl.ShowGroupPanel = false;
                dataControl.AutoGenerateColumns = false;
                dataControl.CanUserFreezeColumns = false;
                dataControl.IsReadOnly = false;
                dataControl.ChildTableDefinitions.Clear();

                GridViewDataColumn column = new GridViewDataColumn();
                column.DataMemberBinding = new Binding("TaskId");
                dataControl.Columns.Add(column);

                column = new GridViewDataColumn();
                column.DataMemberBinding = new Binding("TaskName");
                dataControl.Columns.Add(column);

                column = new GridViewDataColumn();
                column.DataMemberBinding = new Binding("Read");
                dataControl.Columns.Add(column);

                column = new GridViewDataColumn();
                column.DataMemberBinding = new Binding("Write");
                dataControl.Columns.Add(column);
            }

        }
    }

    public class Task
    {
        public int TaskId { get; set; }
        public string TaskName { get; set; }
        public bool Read { get; set; }
        public bool Write { get; set; }

        public int ParentTaskId { get; set; }

    }

Thanks,
-Narendra

Hello.. how are you..

i have the next scene.. i have a grid nest into the other grid i am using the tools to export of telerik.. its a example:

public

void Export(String sFilepath, RadGridView grvExportExcel)

{

ExportToExcelML exporter = new ExportToExcelML(grvExportExcel);

exporter.SummariesExportOption =

SummariesOption.ExportAll;

exporter.RunExport(sFilepath);

}

but its doesn't work .. when i run this function its make the file succesfully but only export the primary grid and the template not...
i need export all information of the grid... if somebody can help me.. i will pleasure.. for your help.

public void Export(String sFilepath, GridViewTemplate grvtExportExcel)

{

RadGridView rgvGrid = new RadGridView();

foreach (GridViewDataColumn c in grvtExportExcel.Columns)

{

rgvGrid.Columns.Add(c);

}

foreach (GridViewDataRowInfo d in grvtExportExcel.Rows)

{

rgvGrid.Rows.AddNew(d);

}

ExportToExcelML exporter = new ExportToExcelML(rgvGrid);

exporter.SummariesExportOption = SummariesOption.ExportAll;

exporter.RunExport(sFilepath);

}

}

but its doesn't work neither....

regards...
thanks for your help.