Hi,
I am trying to show on a grid a list of files where each file can expand to show the employees in that file (Each file contains multiple employees. It's an one-many relationship). My code looks like this so far but I only get a plus sign showing next to each file record on the grid but it won't expand to show the employees. Please advise how I can correct this? Thanks.
GridViewTemplate template = new GridViewTemplate();
template.Columns.Add(new GridViewTextBoxColumn("File_no"));
template.Columns.Add(new GridViewTextBoxColumn("File_Type"));
template.Columns.Add(new GridViewTextBoxColumn("Date_Received"));
template.Columns.Add(new GridViewTextBoxColumn("Date_Closed"));
template.Columns.Add(new GridViewTextBoxColumn("Title"));
template.Columns.Add(new GridViewTextBoxColumn("Status_Name"));
template.Columns.Add(new GridViewTextBoxColumn("Year"));
template.Columns.Add(new GridViewTextBoxColumn("Category_Name"));
template.Columns.Add(new GridViewTextBoxColumn("SubCategory_Name"));
template.Columns.Add(new GridViewTextBoxColumn("ERC_Name"));
template.Columns.Add(new GridViewTextBoxColumn("UnionName"));
template.Columns.Add(new GridViewTextBoxColumn("Union_Rep"));
template.Columns.Add(new GridViewTextBoxColumn("Business_Area_Name"));
template.Columns.Add(new GridViewTextBoxColumn("Resolution_Code"));
GridViewTemplate Childtemplate = new GridViewTemplate();
Childtemplate.Columns.Add(new GridViewTextBoxColumn("File_no"));
Childtemplate.Columns.Add(new GridViewTextBoxColumn("Employee_no"));
Childtemplate.Columns.Add(new GridViewTextBoxColumn("First_name"));
Childtemplate.Columns.Add(new GridViewTextBoxColumn("Last_name"));
Childtemplate.Columns.Add(new GridViewTextBoxColumn("Work_location"));
Childtemplate.Columns.Add(new GridViewTextBoxColumn("position"));
this.FileGrid.MasterTemplate.Templates.Add(template);
template.Templates.Add(Childtemplate);
GridViewRelation relation = new GridViewRelation(template);
relation.ChildTemplate = Childtemplate;
relation.RelationName = "FileEmployees";
relation.ParentColumnNames.Add("File_no");
relation.ChildColumnNames.Add("File_no");
FileGrid.Relations.Add(relation);
FileBusiness _fb = new FileBusiness();
_filelist = _fb.FindFile(null, null, null, null, null, null, null, null, null, null, null); //this returns a list of files
var _orderedList = _filelist.OrderByDescending(x => x.File_no).ToList();
FileEmployeeView _ev = new FileEmployeeView();
this.FileGrid.DataSource = _orderedList;
template.DataSource = _orderedList;
Childtemplate.DataSource = _fb.GetAllFileEmployees(); //this returns all employees record and cooresponding file_id
this.FileGrid.Columns["ProcessStatus"].IsVisible = false;
this.FileGrid.Columns["ProcessStatusMessage"].IsVisible = false;
this.FileGrid.Columns["UpdatedBy"].IsVisible = false;
this.FileGrid.Columns["LastUpdated"].IsVisible = false;
this.FileGrid.Columns["CreatedOn"].IsVisible = false;
this.FileGrid.Columns["CreatedBy"].IsVisible = false;
this.FileGrid.Columns["isactive"].IsVisible = false;
this.FileGrid.Columns["Isdeleted"].IsVisible = false;
this.FileGrid.Columns["Code"].IsVisible = false;
this.FileGrid.Columns["ID"].IsVisible = false;
this.FileGrid.Columns["File_no"].HeaderText = "File #";
this.FileGrid.Columns["File_Type"].HeaderText = "File Type";
this.FileGrid.Columns["Date_Received"].HeaderText = "Date Received";
this.FileGrid.Columns["Date_Closed"].HeaderText = "Date Closed";
this.FileGrid.Columns["Title"].HeaderText = "Title";
this.FileGrid.Columns["Status_Name"].HeaderText = "Status Name";
this.FileGrid.Columns["Year"].HeaderText = "Year";
this.FileGrid.Columns["Category_Name"].HeaderText = "Category Name";
this.FileGrid.Columns["SubCategory_Name"].HeaderText = "Sub-Category Name";
this.FileGrid.Columns["ERC_Name"].HeaderText = "ERC";
this.FileGrid.Columns["UnionName"].HeaderText = "Union Name";
this.FileGrid.Columns["Union_Rep"].HeaderText = "Union Rep";
this.FileGrid.Columns["Business_Area_Name"].HeaderText = "Business Area Name";
this.FileGrid.Columns["Resolution_Code"].HeaderText = "Resolution Code";