Questions on UI for ASP.NET AJAX Forum

110,740 questions

2 answers

115 views

Gridview Hirarchy Exporting to Excel

gviewFormBlok.PreRender += new EventHandler(gviewFormBlok_PreRender);

gviewFormBlok.ExportSettings.ExportOnlyData = true;

gviewFormBlok.HeaderStyle.Wrap = false;

gviewFormBlok.ExportSettings.OpenInNewWindow = true;

gviewFormBlok.MasterTableView.ExportToExcel();

protected void gviewFormBlok_PreRender(object sender, EventArgs e)

{

for (int i = 0; i <= gviewFormBlok.MasterTableView.Items.Count - 1; i++)

{

gviewFormBlok.MasterTableView.Items[i].Expanded = true;

for (int j = 0; j <= gviewFormBlok.MasterTableView.Items[i].ChildItem.NestedTableViews[0].Items.Count - 1; j++)

{

gviewFormBlok.MasterTableView.Items[i].ChildItem.NestedTableViews[0].Items[j].Expanded = true;

gviewFormBlok.MasterTableView.Items[i].ChildItem.NestedTableViews[0].Items[j]["ExpandColumn"].Visible = false;

for (int

K = 0; K <= gviewFormBlok.MasterTableView.Items[i].ChildItem.NestedTableViews[0].Items[j].ChildItem.NestedTableViews[0].Items.Count - 1; K++)

{

gviewFormBlok.MasterTableView.Items[i].ChildItem.NestedTableViews[0].Items[j].ChildItem.NestedTableViews[0].Items[K].Expanded =

true;

gviewFormBlok.MasterTableView.Items[i].ChildItem.NestedTableViews[0].Items[j].ChildItem.NestedTableViews[0].Items[K]["ExpandColumn"].Visible = false;

}

1) I've resolved the issue displaying hirarchy button simbles in exported excel sheet but it is showing the data inproper way means user doesn't understand columns with respected values like attachment #1 (ExportToExcel).

To generate above sheet I'm using above block code

2)I've done some more R&D on this finally I got similar one and it is displaying data properly with user understanding but problem is it is showing only 2 hirarchys instead of 4 hirarchys.

For this I used below code and I got the attachment2 (ExportToExcel_LooksGood)

gviewFormBlok.MasterTableView.HierarchyDefaultExpanded = true;

gviewFormBlok.ExportSettings.ExportOnlyData = true;

gviewFormBlok.ExportSettings.IgnorePaging = true;

gviewFormBlok.MasterTableView.PageSize = 10000;

gviewFormBlok.MasterTableView.Rebind();

//add some big enough number;

gviewFormBlok.ExportSettings.OpenInNewWindow = true;

(gviewFormBlok.MasterTableView.GetItems(GridItemType.Header)[0] as GridHeaderItem)["ExpandColumn"].Visible = false;

foreach (GridDataItem dataItem in gviewFormBlok.MasterTableView.Items)

{

dataItem["ExpandColumn"].Style["display"] = "none";

dataItem["ExpandColumn"].Visible = false;

foreach (GridDataItem dataItem1 in gviewFormBlok.MasterTableView.Items[dataItem.ItemIndex].ChildItem.NestedTableViews[0].Items)

{

dataItem1["ExpandColumn"].Style["display"] = "none";

dataItem1["ExpandColumn"].Visible = false;

}

gviewFormBlok.MasterTableView.ExportToExcel();

Finally my query is how to dispaly attachment1 (ExportToExcel) data using above code.

Grid

answered on 22 Jul 2011

9 answers

144 views

Detail data display no data in a simple hierarchical grid

Hello Guys,

I have a strange issue on a simple hierarchical grid. When I click on a row to expand on detailed rows, it shows nothing even there are data in the DB, can somebody help me to find out where the problem is? Here is my code;

<%@ Page Title="" Language="VB" MasterPageFile="~/MasterPage2.master" AutoEventWireup="false" CodeFile="Local_HRs_PersonnalMovements.aspx.vb" Inherits="Local_HRs_Local_HRs_PersonnalMovements" %>

<asp:Content ID="Content1" ContentPlaceHolderID="Main" Runat="Server">

<asp:SqlDataSource ID="SDS_Employees" runat="server"

ConflictDetection="CompareAllValues"

ConnectionString="<%$ ConnectionStrings:DBCentreList %>"

DeleteCommand="DELETE FROM db_owner.[MDE_Employees] WHERE [EmployeeID] = @original_EmployeeID AND (([GlobeID] = @original_GlobeID) OR ([GlobeID] IS NULL AND @original_GlobeID IS NULL)) AND [FirstName] = @original_FirstName AND [LastName] = @original_LastName AND [Birthdate] = @original_Birthdate AND [GenderID] = @original_GenderID AND (([Initials] = @original_Initials) OR ([Initials] IS NULL AND @original_Initials IS NULL))"

InsertCommand="INSERT INTO db_owner.MDE_GlobeEmployeeIDs (GlobeEmployeeID) VALUES (@GlobeID);INSERT INTO db_owner.[MDE_Employees] ([GlobeID], [FirstName], [LastName], [Birthdate], [GenderID], [Initials]) VALUES (@GlobeID, @FirstName, @LastName, @Birthdate, @GenderID, @Initials)"

OldValuesParameterFormatString="original_{0}"

SelectCommand="SELECT [EmployeeID], [GlobeID], [FirstName], [LastName], [Birthdate], [GenderID], [Initials] FROM db_owner.[MDE_Employees]"

UpdateCommand="UPDATE db_owner.[MDE_Employees] SET [GlobeID] = @GlobeID, [FirstName] = @FirstName, [LastName] = @LastName, [Birthdate] = @Birthdate, [GenderID] = @GenderID, [Initials] = @Initials WHERE [EmployeeID] = @original_EmployeeID AND (([GlobeID] = @original_GlobeID) OR ([GlobeID] IS NULL AND @original_GlobeID IS NULL)) AND [FirstName] = @original_FirstName AND [LastName] = @original_LastName AND [Birthdate] = @original_Birthdate AND [GenderID] = @original_GenderID AND (([Initials] = @original_Initials) OR ([Initials] IS NULL AND @original_Initials IS NULL))">

<DeleteParameters>

<asp:Parameter Name="original_EmployeeID" Type="Int32" />

<asp:Parameter Name="original_GlobeID" Type="Int32" />

<asp:Parameter Name="original_FirstName" Type="String" />

<asp:Parameter Name="original_LastName" Type="String" />

<asp:Parameter Name="original_Birthdate" Type="DateTime" />

<asp:Parameter Name="original_GenderID" Type="Int32" />

<asp:Parameter Name="original_Initials" Type="String" />

</DeleteParameters>

<UpdateParameters>

<asp:Parameter Name="GlobeID" Type="Int32" />

<asp:Parameter Name="FirstName" Type="String" />

<asp:Parameter Name="LastName" Type="String" />

<asp:Parameter Name="Birthdate" Type="DateTime" />

<asp:Parameter Name="GenderID" Type="Int32" />

<asp:Parameter Name="Initials" Type="String" />

<asp:Parameter Name="original_EmployeeID" Type="Int32" />

<asp:Parameter Name="original_GlobeID" Type="Int32" />

<asp:Parameter Name="original_FirstName" Type="String" />

<asp:Parameter Name="original_LastName" Type="String" />

<asp:Parameter Name="original_Birthdate" Type="DateTime" />

<asp:Parameter Name="original_GenderID" Type="Int32" />

<asp:Parameter Name="original_Initials" Type="String" />

</UpdateParameters>

<InsertParameters>

<asp:Parameter Name="GlobeID" Type="Int32" />

<asp:Parameter Name="FirstName" Type="String" />

<asp:Parameter Name="LastName" Type="String" />

<asp:Parameter Name="Birthdate" Type="DateTime" />

<asp:Parameter Name="GenderID" Type="Int32" />

<asp:Parameter Name="Initials" Type="String" />

</InsertParameters>

</asp:SqlDataSource>

<asp:SqlDataSource ID="SDS_Positions" runat="server"

ConflictDetection="CompareAllValues"

ConnectionString="<%$ ConnectionStrings:DBCentreList %>"

DeleteCommand="DELETE FROM db_owner.[TRE_Positions] WHERE [PositionID] = @original_PositionID AND [EmployeeID] = @original_EmployeeID AND [StatusID] = @original_StatusID AND [WorkContractID] = @original_WorkContractID AND [StartDate] = @original_StartDate AND (([EndDate] = @original_EndDate) OR ([EndDate] IS NULL AND @original_EndDate IS NULL)) AND [OrgUnitID] = @original_OrgUnitID AND [GroupingID] = @original_GroupingID AND [SubGroupingID] = @original_SubGroupingID AND [WorkRate] = @original_WorkRate AND [TransferReasonID] = @original_TransferReasonID"

InsertCommand="INSERT INTO db_owner.[TRE_Positions] ([EmployeeID], [StatusID], [WorkContractID], [StartDate], [EndDate], [OrgUnitID], [GroupingID], [SubGroupingID], [WorkRate], [TransferReasonID]) VALUES (@EmployeeID, @StatusID, @WorkContractID, @StartDate, @EndDate, @OrgUnitID, @GroupingID, @SubGroupingID, @WorkRate, @TransferReasonID)"

OldValuesParameterFormatString="original_{0}"

SelectCommand="SELECT [PositionID], [EmployeeID], [StatusID], [WorkContractID], [StartDate], [EndDate], [OrgUnitID], [GroupingID], [SubGroupingID], [WorkRate], [TransferReasonID] FROM db_owner.[TRE_Positions] WHERE ([EmployeeID] = @EmployeeID)"

UpdateCommand="UPDATE db_owner.[TRE_Positions] SET [EmployeeID] = @EmployeeID, [StatusID] = @StatusID, [WorkContractID] = @WorkContractID, [StartDate] = @StartDate, [EndDate] = @EndDate, [OrgUnitID] = @OrgUnitID, [GroupingID] = @GroupingID, [SubGroupingID] = @SubGroupingID, [WorkRate] = @WorkRate, [TransferReasonID] = @TransferReasonID WHERE [PositionID] = @original_PositionID AND [EmployeeID] = @original_EmployeeID AND [StatusID] = @original_StatusID AND [WorkContractID] = @original_WorkContractID AND [StartDate] = @original_StartDate AND (([EndDate] = @original_EndDate) OR ([EndDate] IS NULL AND @original_EndDate IS NULL)) AND [OrgUnitID] = @original_OrgUnitID AND [GroupingID] = @original_GroupingID AND [SubGroupingID] = @original_SubGroupingID AND [WorkRate] = @original_WorkRate AND [TransferReasonID] = @original_TransferReasonID">

<SelectParameters>

<asp:SessionParameter Name="EmployeeID" SessionField="EmployeeID" Type="Int32" />

</SelectParameters>

<DeleteParameters>

<asp:Parameter Name="original_PositionID" Type="Int32" />

<asp:Parameter Name="original_EmployeeID" Type="Int32" />

<asp:Parameter Name="original_StatusID" Type="Int32" />

<asp:Parameter Name="original_WorkContractID" Type="Int32" />

<asp:Parameter Name="original_StartDate" Type="DateTime" />

<asp:Parameter Name="original_EndDate" Type="DateTime" />

<asp:Parameter Name="original_OrgUnitID" Type="Int32" />

<asp:Parameter Name="original_GroupingID" Type="Int32" />

<asp:Parameter Name="original_SubGroupingID" Type="Int32" />

<asp:Parameter Name="original_WorkRate" Type="Int32" />

<asp:Parameter Name="original_TransferReasonID" Type="Int32" />

</DeleteParameters>

<UpdateParameters>

<asp:SessionParameter Name="EmployeeID" SessionField="EmployeeID" Type="Int32" />

<asp:Parameter Name="StatusID" Type="Int32" />

<asp:Parameter Name="WorkContractID" Type="Int32" />

<asp:Parameter Name="StartDate" Type="DateTime" />

<asp:Parameter Name="EndDate" Type="DateTime" />

<asp:Parameter Name="OrgUnitID" Type="Int32" />

<asp:Parameter Name="GroupingID" Type="Int32" />

<asp:Parameter Name="SubGroupingID" Type="Int32" />

<asp:Parameter Name="WorkRate" Type="Int32" />

<asp:Parameter Name="TransferReasonID" Type="Int32" />