Questions on UI for ASP.NET AJAX Forum

3 answers

192 views

Hi all,

In my datagrid, I need to generate an automatic date picker on the addnewrecord command. How can I do this?

Thanks in advance

Grid

answered on 16 Jul 2012

3 answers

127 views

Error from Web Service unable to catch

I am using the RadSchedular for our application. All the data are coming,saving and updating through Web service which the Telerik project provided. I only changed the business logic in the MyDbSchedulerProvider class to get and save data from our database. There are lots of cases when service side error can occur. However I am unable to throw the error from web method to the Schedular pages . Can anyone please help me in this regard?

Scheduler

answered on 16 Jul 2012

2 answers

118 views

Binary image work as hyper link

Hi all,

I have a Rad Binary Image.. i wish to the binary image control work as a hyper link..
please help

Regards,

Prassin

BinaryImage

answered on 16 Jul 2012

11 answers

281 views

RadDatePicker rendering problem

Hello,

in my project I have big troubles with the rendering of the RadDatePicker. It seems the CSS is not applied (well) to the control. Instead of the calendar button, the tooltip is rendered as hyperlink for opening the calendar. When the calendar, for date selection, is opened there's no background etc.
The RadDatePicker is on a RadMultiPage in a UserControl that is set to visibele after clicking a button in the NamingContainer (in the sampel a aspx but in my project also a UserControl) of the UserControl. The UserControl has a RadAjaxPanel on it which contains the RadDatePicker, the NamingContainer als has a RadAjaxPanel.

I've tried to reproduce the problem in a sample project which I've attached. Only in this sample te problem appears after clicking/changing the tabstrip a few times while in my application the problem always appears.

Hopefully there's someome who can help me with this problem.

Regards,
Jos Meerkerk

Default.aspx:

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Default.aspx.cs" Inherits="RadDatePicker.Default" %>

<%@ Register Assembly="Telerik.Web.UI" Namespace="Telerik.Web.UI" TagPrefix="telerik" %>

<%@ Register TagPrefix="uc" TagName="DatePicker" Src="~/DatePicker.ascx" %>

<!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 style="margin-left:100px;margin-top:100px;">

<telerik:RadScriptManager ID="RadScriptManager1" runat="server"></telerik:RadScriptManager>

<telerik:RadButton ID="RadButton1" runat="server" Text="RadButton"

onclick="RadButton1_Click">

</telerik:RadButton> <br />

<uc:DatePicker ID="ucDatePicker" runat="server" Visible="false" />

</div>

</form>

</body>

</html>

Default.aspx.cs:

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

namespace RadDatePicker

{

public partial class Default : System.Web.UI.Page

{

protected void Page_Load(object sender, EventArgs e)

{

}

protected void RadButton1_Click(object sender, EventArgs e)

{

ucDatePicker.Visible = true;

}

DatePicker.ascx:

<telerik:RadAjaxPanel ID="rapPanel" runat="server">

<telerik:RadTabStrip ID="RadTabStrip1" runat="server"

MultiPageID="RadMultiPage1" Skin="Windows7" AutoPostBack="true">

<Tabs>

<telerik:RadTab runat="server" PageViewID="rpvPage1" Text="Root RadTab1">

</telerik:RadTab>

<telerik:RadTab runat="server" PageViewID="rpvPage2" Text="Root RadTab2">

</telerik:RadTab>

<telerik:RadTab runat="server" PageViewID="rpvPage3" Text="Root RadTab3">

</telerik:RadTab>

</Tabs>

</telerik:RadTabStrip>

<telerik:RadMultiPage ID="RadMultiPage1" Runat="server" RenderSelectedPageOnly="true" EnableEmbeddedScripts="true" SelectedIndex="0">

<telerik:RadPageView ID="rpvPage1" runat="server">

RadPageView Page 1

</telerik:RadPageView>

<telerik:RadPageView ID="rpvPage2" runat="server">

RadPageView Page 2<br />

<telerik:RadAjaxPanel ID="RadAjaxPanel1" runat="server">

<telerik:RadDatePicker ID="RadDatePicker2" runat="server" Skin="Windows7">

</telerik:RadDatePicker>

</telerik:RadAjaxPanel>

</telerik:RadPageView>

<telerik:RadPageView ID="rpvPage3" runat="server">

RadPageView Page 3

</telerik:RadPageView>

</telerik:RadMultiPage>

</telerik:RadAjaxPanel>

Calendar

answered on 15 Jul 2012

0 answers

121 views

close all expanded items on return to home page

Hi

I have persistStateInCookie = true so that visitors can know where they are when navigating pages.
But I want to be able to close all expanded menu items when the visitor returns to the home page.

Right now, any item that was expanded remains open when the visitor returns to the Home page which is
somewhat confusing.

Can anyone help?

I have tried numerous ways of expiring the cookie, but nothing works so far.

Thanks for help!

Clive

Menu

asked on 14 Jul 2012

1 answer

112 views

Bind Rad Grid while Tree View node click

Hi All,

I have rad grid and rad tree view .. when i select a particular rad tree view node the grid need to be populated regarding that particular node click..

>Node1
>Node2
>Node3
>New Node1
>New Node2

Node2 and Node3 stand under Node1

when i click Node3 the child node value need to be 3. i need to achieve this too..

please help

Regards,

Prassin

TreeView

answered on 14 Jul 2012

1 answer

114 views

Checkboxes staying unchecked

i am working on a project where we have sports people that we show in telerik grid

here we need to know if they are professional, this is handled by a bool, so far so good
it works good when i start the page but if i refresh via the toolbar in the bottom, the checkboxes we use are changed to its string value, how can i avoid this?

@(

Html.Telerik().Grid(Model)

.Name("Player")

.ClientEvents(events =>

{

events.OnDataBound("Grid_onDataBound");

events.OnSubmitChanges("Grid_onSubmitChanges");

events.OnError("Grid_onError");

})

.Sortable(sorting => sorting.Enabled(true))

.DataKeys(keys => keys.Add(o => o.Id)

.RouteKey("Id"))

.ToolBar(commands =>

{

commands.Insert().ButtonType(GridButtonType.Image).ImageHtmlAttributes(new { style = "margin-left:0" });

commands.SubmitChanges().ButtonType(GridButtonType.Image);

})

.DataBinding(dataBinding => dataBinding.Ajax()

//.Insert("Players_update", "Player", new { Tournament = ViewBag.TournamentID })

.Select("Select_players", "Player", new { Tournament = ViewBag.TournamentID })

.Update("Players_update", "Player", new { Tournament = ViewBag.TournamentID })

//.Delete("Players_update", "Player", new { Tournament = ViewBag.TournamentID })

)

.PrefixUrlParameters(false)

.Columns(columns =>

{

columns.Bound(o => o.FirstName).Width(180);

columns.Bound(o => o.LastName).Width(180);

columns.Bound(o => o.Email).Width(200);

columns.ForeignKey(o => o.Sex, (IEnumerable)ViewData["gender"], "Id", "Text").Width(120);

columns.ForeignKey(o => o.Country, (IEnumerable)ViewData["country"], "Id", "Name").Width(120);

columns

.Bound(o => o.IsPro)

.ClientTemplate("<input type='checkbox' name='IsPro' value='<#=IsPro#>' />")

.Width(30);

columns.Command(commands =>

{

commands.Edit().ButtonType(GridButtonType.Image);

commands.Delete().ButtonType(GridButtonType.Image);

});

})

.Editable(editing => editing.Mode(GridEditMode.InCell))

.KeyboardNavigation(navigation => navigation.EditOnTab(true))

)

Grid

answered on 14 Jul 2012

2 answers

349 views

Grid Sorting Problem:- in the sorting date is only taking date and month part. It is not taking year part

Hi,

I have a grid and in that i have by default sorting by date desc and default group by by date and i is by default expended. The problem is that the sorting order is desc of date but the date is only taking the date and the month part in the not measuring by the sorting.

Please see the attachment.

I have used following code for sorting and grouping

<SortExpressions >
                            <telerik:GridSortExpression FieldName="UpdatedDate" SortOrder="Descending"/>
                        </SortExpressions>
<GroupByExpressions>
                            <telerik:GridGroupByExpression>
                                <GroupByFields>
                                    <telerik:GridGroupByField FieldName="UpdatedDate" SortOrder="Descending" FormatString="{0:yy/mm/dd}" />
                                </GroupByFields>
                                <SelectFields>
                                    <telerik:GridGroupByField FieldName="UpdatedDate" />
                                </SelectFields>
                            </telerik:GridGroupByExpression>
                        </GroupByExpressions>
                        <GroupHeaderTemplate>
                            <asp:Label Text='<%#String.Format("{0:MM/dd/yy}", Eval("UpdatedDate"))%>' runat="server"
                                ID="lblDate" Style="font-weight: bold; color: Black;"></asp:Label>
                        </GroupHeaderTemplate>

Grid

answered on 14 Jul 2012

2 answers

117 views

RadWindow from RadGrid

Hello,

We have a Radgrid in one of our web pages. The user can upload the documents here and they should be able to view the documents they have already uploaded. I have a image button as one of the columns in the RadGrid. Idea being, when the user clicks on that button, a RadWindow should open. I have the byte array of the document. With this, how do i open the document in a new window.
One way is to pass the byte array(which is saved in the database) to the RadWindow. How do i do this?

Appreciate the help
Thanks

Window

answered on 13 Jul 2012

0 answers

231 views

Radgrid export to pdf problem

Hi, I am pretty new to using the Telerik controls and am trying to clean up some pre-existing code. It seems pretty straightforward as I am just exporting a grid to pdf. The issue I am having is that I can load the page, not resize any columns, click the export to pdf button and my grid formats and looks fantastic. if i resize ANY of the columns though, not all my columns show up. This even happens if i resize and make my columns smaller. Help?

<telerik:RadGrid ID="grdEmployee" runat="server" AllowPaging="True"

AllowSorting="True" GroupingEnabled="False" AllowMultiRowSelection="True"

GridLines="None" AutoGenerateColumns="False" PageSize ="20"

AllowCustomPaging="True" Height="400px" CellSpacing="0"

OnPageIndexChanged="grdEmployee_PageIndexChanged"

OnPageSizeChanged="grdEmployee_PageSizeChanged"

OnItemCommand="grdEmployee_ItemCommand"

OnItemCreated="grdEmployee_ItemCreated"

OnPreRender="grdEmployee_PreRender"

OnSortCommand="grdEmployee_SortCommand"

OnExportCellFormatting="grdEmployee_ExportCellFormatting"

meta:resourcekey="grdEmployee">

<ClientSettings AllowColumnHide="True" AllowColumnsReorder="True" ReorderColumnsOnClient="true">

<Selecting AllowRowSelect="True" />

<Scrolling AllowScroll="True" EnableVirtualScrollPaging="True" UseStaticHeaders="True" />

<Resizing AllowColumnResize="True" AllowResizeToFit="True" />

</ClientSettings>

<MasterTableView AllowNaturalSort="False" DataKeyNames="EmployeeId" EnableHeaderContextMenu="False">

<NestedViewTemplate>

<asp:Panel ID="pnlEmployeeDetails" runat="server" CssClass="GridDetailPanel">

<table>

<tr>

<td class="gdpLabelColumn">

<asp:Label ID="lblDetailFirstNameText" runat="server" meta:resourceKey="lblDetailFirstNameText" />

</td>

<td class="gdpValueColumn" colspan="3">

<asp:Label ID="lblDetailFirstNameValue" runat="server" />

<asp:Label ID="lblDetailMiddleInitialValue" runat="server" />

<asp:Label ID="lblDetailLastNameValue" runat="server" />

</td>

<td rowspan="5">

</td>

</tr>

<tr>

<td class="gdpLabelColumn">

<asp:Label ID="lblDetailBirthDateText" runat="server" meta:resourceKey="lblDetailBirthDateText" />

</td>

<td class="gdpValueColumn">

<asp:Label ID="lblDetailBirthDateValue" runat="server" />

</td>

<td class="gdpLabelColumn">

<asp:Label ID="lblDetailGenderText" runat="server" meta:resourceKey="lblDetailGenderText" />

</td>

<td class="gdpValueColumn">

<asp:Label ID="lblDetailGenderValue" runat="server" />

</td>

</tr>

<tr>

<td class="gdpLabelColumn">

<asp:Label ID="lblDetailHireDateText" runat="server" meta:resourceKey="lblDetailHireDateText" />

</td>

<td class="gdpValueColumn">

<asp:Label ID="lblDetailHireDateDetailValue" runat="server" />

</td>

<td class="gdpLabelColumn">

<asp:Label ID="lblDetailTerminationDateText" runat="server" meta:resourceKey="lblDetailTerminationDateText" />

</td>

<td class="gdpValueColumn">

<asp:Label ID="lblDetailTerminationDateValue" runat="server" />

</td>

</tr>

<tr>

<td class="gdpLabelColumn">

<asp:Label ID="lblDetailSiteText" runat="server"

meta:resourceKey="lblDetailSiteText" />

</td>

<td class="gdpValueColumn">

<asp:Label ID="lblDetailSiteValue" runat="server" />

</td>

<td class="gdpLabelColumn">

<asp:Label ID="lblDetailDepartmentText" runat="server" meta:resourceKey="lblDetailDepartmentText" />

</td>

<td class="gdpValueColumn">

<asp:Label ID="lblDetailDepartmentValue" runat="server" />

</td>

</tr>

<tr>

<td class="gdpLabelColumn">

<asp:Label ID="lblDetailClassificationText" runat="server" meta:resourceKey="lblDetailClassificationText" />

</td>

<td class="gdpValueColumn">

<asp:Label ID="lblDetailClassificationValue" runat="server" />

</td>

<td class="gdpLabelColumn">

<asp:Label ID="lblDetailEmployeeGroupText" runat="server" meta:resourceKey="lblDetailEmployeeGroupText" />

</td>

<td class="gdpValueColumn">

<asp:Label ID="lblDetailEmployeeGroupValue" runat="server" />

</td>

</tr>

</table>

</asp:Panel>

</NestedViewTemplate>

<CommandItemSettings ExportToPdfText="Export to PDF" ShowAddNewRecordButton="False" ShowRefreshButton="false" />

<RowIndicatorColumn FilterControlAltText="Filter RowIndicator column" />

<ExpandCollapseColumn FilterControlAltText="Filter ExpandColumn column" Visible="True" />

<Columns>

<telerik:GridClientSelectColumn UniqueName="Select">

<HeaderStyle HorizontalAlign="Left" Width="20px" />

</telerik:GridClientSelectColumn>

<telerik:GridImageColumn UniqueName="CombinedEmployeeStatus"

DataAlternateTextField="CombinedEmployeeStatus"

DataImageUrlFields="EnabledStatus,ActiveStatus"

DataImageUrlFormatString="~/Style/Images/Grid/Employee {0} {1}.bmp"

ImageAlign="Middle"

ImageHeight="16px" ImageWidth="16px">

<HeaderStyle Width="20px" />

</telerik:GridImageColumn>

<telerik:GridTemplateColumn UniqueName="FirstName" SortExpression="FirstName"

meta:resourceKey="grdEmployee_FirstName">

<ItemTemplate>

<asp:HyperLink ID="hlkSelect" runat="server" ForeColor="#3B3B3B"

Text='<%# DataBinder.Eval(Container, "DataItem.FirstName") %>'

meta:resourceKey="hlkSelect" />

</ItemTemplate>

<HeaderStyle Width="15%" />

</telerik:GridTemplateColumn>

<telerik:GridBoundColumn UniqueName="MiddleInitial" DataField="MiddleInitial"

SortExpression="MiddleInitial" meta:resourceKey="grdEmployee_MiddleInitial">

<HeaderStyle Width="35px" />

</telerik:GridBoundColumn>

<telerik:GridBoundColumn UniqueName="LastName" DataField="LastName"

SortExpression="LastName" meta:resourceKey="grdEmployee_LastName">

<HeaderStyle Width="25%" />

</telerik:GridBoundColumn>

<telerik:GridBoundColumn UniqueName="EmployeeNumber" DataField="EmployeeNumber"

SortExpression="EmployeeNumber" meta:resourceKey="grdEmployee_EmployeeNumber">

<HeaderStyle Width="15%" />

</telerik:GridBoundColumn>

<telerik:GridBoundColumn UniqueName="SSN" DataField="SSN"

SortExpression="SSN" meta:resourceKey="grdEmployee_SSN" />

<telerik:GridBoundColumn UniqueName="BirthDate" Display="False" DataField="BirthDate"

SortExpression="BirthDate" meta:resourceKey="grdEmployee_BirthDate" />

</Columns>

<SortExpressions>

<telerik:GridSortExpression FieldName="LastName" />

</SortExpressions>

</MasterTableView>

<PagerStyle Mode="Slider" />

<FilterMenu EnableImageSprites="False" />

<HeaderContextMenu CssClass="GridContextMenu GridContextMenu_Default" />

</telerik:RadGrid>

#region Grid Events

/// <summary>

/// Handles the ItemCreated event of the grdEmployee control.

/// </summary>

/// <param name="sender">The source of the event.</param>

/// <param name="e">The <see cref="Telerik.Web.UI.GridItemEventArgs"/> instance containing the event data.</param>

protected void grdEmployee_ItemCreated(object sender, GridItemEventArgs e)

{

//set the grid column properties

if ((e.Item is GridDataItem) && (_gridDataExport == false))

{

GridDataItem dataItem = e.Item as GridDataItem;

string employeeId = dataItem.GetDataKeyValue(_GRID_DATAKEY).ToString();

//Check the selected item, if any on the current page

MarkSelectedItems(dataItem, employeeId);

//Add the link to navigate to employee record

HyperLink selectLink = (HyperLink)dataItem.FindControl("hlkSelect");

selectLink.NavigateUrl = AptaFundUrl.ToEmployeeEdit() + "&EmployeeId=" + employeeId;

}

else if ((e.Item is GridDataItem) && (_gridDataExport == true) && (_gridDataPdfExport == true))//pdf export

{

//pdf export column formatting

e.Item.Style["text-align"] = "left";

}

/// <summary>

/// Handles the SortCommand event of the grdEmployee control.

/// </summary>

/// <param name="sender">The source of the event.</param>

/// <param name="e">The <see cref="Telerik.Web.UI.GridSortCommandEventArgs"/> instance containing the event data.</param>

protected void grdEmployee_SortCommand(object sender, GridSortCommandEventArgs e)

{

try

{

//cancel the current sort

e.Canceled = true;

GridSortExpression sortExpression = new GridSortExpression();

//get the new sort field name

sortExpression.FieldName = e.SortExpression;

//set the new sort order ascending/descending

sortExpression.SortOrder = e.NewSortOrder;

//store the sort expression, which can be used when they come back from another screen

StoreSortExpressionToSession(sortExpression);

//make sure only selected items are stored.(the user might have changed the selections

this.StoreGridSelectedItems(this.grdEmployee);

//bind the gird with new sort

this.DoSearch(false, sortExpression);

}

catch (Exception ex)

{

base.CatchPageErrorAndLog(ex);

}

/// <summary>

/// Handles the ItemCommand event of the grdEmployee control. Fired when the grid is expanded

/// </summary>

/// <param name="sender">The source of the event.</param>

/// <param name="e">The <see cref="Telerik.Web.UI.GridCommandEventArgs"/> instance containing the event data.</param>

protected void grdEmployee_ItemCommand(object sender, GridCommandEventArgs e)

{

try

{

if (e.CommandName == RadGrid.ExpandCollapseCommandName && !e.Item.Expanded)

{

//show the details of the employee

PopulateEmployeeDetailTemplate(e.Item as GridDataItem, e);

}

catch (Exception ex)

{

base.CatchPageErrorAndLog(ex);

}

/// <summary>

/// Handles the ExportCellFormatting event of the grdEmployee control.

/// </summary>

/// <param name="sender">The source of the event.</param>

/// <param name="e">The <see cref="Telerik.Web.UI.ExportCellFormattingEventArgs"/> instance containing the event data.</param>

protected void grdEmployee_ExportCellFormatting(object sender, ExportCellFormattingEventArgs e)

{

if (_gridDataExcelExport == true) //do this only for excel export

{

//header item formatting

GridHeaderItem HeaderItem = (GridHeaderItem)grdEmployee.MasterTableView.GetItems(GridItemType.Header)[0];

foreach (TableCell cell in HeaderItem.Cells)

{

cell.Style["text-align"] = "left";

}

// each column data formatting

e.Cell.Style["text-align"] = "left";

}

/// <summary>

/// Handles the PreRender event of the grdEmployee control.

/// </summary>

/// <param name="sender">The source of the event.</param>

/// <param name="e">The <see cref="System.EventArgs"/> instance containing the event data.</param>

protected void grdEmployee_PreRender(object sender, EventArgs e)

{

//We are using our own select all record option

//We want to allow the user to uncheck rows after they do a select all first

//See below why we want do that

//The Telerik grid top header checkbox by default, only selects records listed on the page

//Also, the Telerik grid will check the top checkbox, if all the rows displayed in the page is checked(we may not want this, as user might have deselected some rows)

if (_gridDataExport == false) //do this only when not exporting data

{

foreach (GridHeaderItem headerItem in grdEmployee.MasterTableView.GetItems(GridItemType.Header))

{

//Find the SelectAll CheckBox in the header using the ClientSelectColumn's "UniqueName"

if (headerItem["Select"].Controls[0] != null)

{

CheckBox chkSelectAll = headerItem["Select"].Controls[0] as CheckBox;

if (chkSelectAll != null)

{

//hide it

chkSelectAll.Visible = false;

}

else if ((_gridDataExport == true) && (_gridDataPdfExport == true)) //pdf export

{

//format header columns for pdf export

foreach (GridHeaderItem headerItem in grdEmployee.MasterTableView.GetItems(GridItemType.Header))

{

headerItem["FirstName"].Style["text-align"] = "left";

headerItem["LastName"].Style["text-align"] = "left";

headerItem["MiddleInitial"].Style["text-align"] = "left";

headerItem["EmployeeNumber"].Style["text-align"] = "left";

headerItem["SSN"].Style["text-align"] = "left";

}

GridColumn column = grdEmployee.MasterTableView.GetColumn("FirstName");

column.HeaderStyle.Width = Unit.Pixel(50);

GridColumn column2 = grdEmployee.MasterTableView.GetColumn("MiddleInitial");

column2.HeaderStyle.Width = Unit.Pixel(50);

}

/// <summary>

/// Handles the PageSizeChanged event of the grdEmployee control.

/// </summary>

/// <param name="sender">The source of the event.</param>

/// <param name="e">The <see cref="Telerik.Web.UI.GridPageSizeChangedEventArgs"/> instance containing the event data.</param>

protected void grdEmployee_PageSizeChanged(object sender, GridPageSizeChangedEventArgs e)

{

try

{

if (_gridDataExport == false)

{

StoreGridSelectedItems(this.grdEmployee);

DoSearch(false);

}

catch (Exception ex) //capture any error here to show it as we use AJAX

{

base.CatchPageErrorAndLog(ex);

}

/// <summary>

/// Handles the PageIndexChanged event of the grdEmployee control.

/// </summary>

/// <param name="sender">The source of the event.</param>

/// <param name="e">The <see cref="Telerik.Web.UI.GridPageChangedEventArgs"/> instance containing the event data.</param>

protected void grdEmployee_PageIndexChanged(object sender, GridPageChangedEventArgs e)

{

try

{

StoreGridSelectedItems(this.grdEmployee);

DoSearch(false);

}

catch (Exception ex) //capture any error here to show it as we use AJAX

{

base.CatchPageErrorAndLog(ex);

}

/// <summary>

/// Handles the Click event of the btnGridExportToExcel control.

/// </summary>

/// <param name="sender">The source of the event.</param>

/// <param name="e">The <see cref="System.EventArgs"/> instance containing the event data.</param>

protected void btnGridExportToExcel_Click(object sender, EventArgs e)

{

_gridDataExport = true; //set this so that other grid events can check for this and not execute it as we do not need that when exporting

_gridDataExcelExport = true;

//Following is necessary for getting all rows from database.

DoSearch(false);

grdEmployee.MasterTableView.RowIndicatorColumn.Visible = false;

//hide the select checkbox column

grdEmployee.MasterTableView.Columns.FindByUniqueName("Select").Visible = false;

grdEmployee.MasterTableView.Columns.FindByUniqueName("CombinedEmployeeStatus").Visible = false;

grdEmployee.ExportSettings.HideStructureColumns = true;

grdEmployee.ExportSettings.OpenInNewWindow = true;

grdEmployee.ExportSettings.ExportOnlyData = true;

grdEmployee.ExportSettings.IgnorePaging = true;

grdEmployee.MasterTableView.ExportToExcel();

}

/// <summary>

/// Handles the Click event of the btnGridExportToPDF control.

/// </summary>

/// <param name="sender">The source of the event.</param>

/// <param name="e">The <see cref="System.EventArgs"/> instance containing the event data.</param>

protected void btnGridExportToPDF_Click(object sender, EventArgs e)

{

_gridDataExport = true; //set this so that other gird events can check for this and not execute it as we do not need that when exporting

_gridDataPdfExport = true;

DoSearch(false);

//hide the select checkbox column

grdEmployee.MasterTableView.Columns.FindByUniqueName("Select").Visible = false;

grdEmployee.MasterTableView.Columns.FindByUniqueName("CombinedEmployeeStatus").Visible = false;

//format columns for fitting within page in portrait mode

grdEmployee.MasterTableView.Columns.FindByUniqueName("SSN").HeaderStyle.Width = Unit.Pixel(100);

grdEmployee.MasterTableView.Columns.FindByUniqueName("SSN").ItemStyle.Width = Unit.Pixel(100);

grdEmployee.MasterTableView.Columns.FindByUniqueName("EmployeeNumber").HeaderStyle.Width = Unit.Pixel(100);

grdEmployee.MasterTableView.Columns.FindByUniqueName("EmployeeNumber").ItemStyle.Width = Unit.Pixel(100);

grdEmployee.MasterTableView.Columns.FindByUniqueName("FirstName").ItemStyle.Width = Unit.Pixel(100);

grdEmployee.MasterTableView.Columns.FindByUniqueName("FirstName").HeaderStyle.Width = Unit.Pixel(100);

grdEmployee.MasterTableView.Columns.FindByUniqueName("LastName").HeaderStyle.Width = Unit.Pixel(100);

grdEmployee.MasterTableView.Columns.FindByUniqueName("LastName").ItemStyle.Width = Unit.Pixel(100);

grdEmployee.MasterTableView.Columns.FindByUniqueName("MiddleInitial").ItemStyle.Width = Unit.Pixel(100);

grdEmployee.MasterTableView.Columns.FindByUniqueName("MiddleInitial").HeaderStyle.Width = Unit.Pixel(100);

grdEmployee.ExportSettings.OpenInNewWindow = true;

grdEmployee.ExportSettings.ExportOnlyData = true;

grdEmployee.ExportSettings.IgnorePaging = true;

grdEmployee.ExportSettings.Pdf.PageLeftMargin = Unit.Pixel(0);

grdEmployee.ExportSettings.Pdf.PageRightMargin = Unit.Pixel(0);

grdEmployee.MasterTableView.ExportToPdf();

}

#endregion

Grid

asked on 13 Jul 2012