This is a migrated thread and some comments may be shown as answers.

Grid Export Buttons and AJAX

4 Answers 127 Views

Grid

This is a migrated thread and some comments may be shown as answers.

Duncan Evans asked on 18 Oct 2010, 09:14 PM

I have read that i need to exclude the export to excel and pdf buttons of the RadGrid from the AJAXified requests. I found the following article outlining this:

http://www.telerik.com/help/aspnet-ajax/ajxexclude.html

However i have two questions as this does not help me much:

1) When i add the OnRequestStart property to my ClientSettings like this:

<ClientSettings AllowDragToGroup="True">

<Scrolling AllowScroll="True" ScrollHeight="600px" UseStaticHeaders="True" />

<ClientEvents OnRequestStart="gridRequestStart" />

</ClientSettings>

I get the following error: Type 'Telerik.Web.UI.GridClientEvents' does not have a public property named 'OnRequestStart'.

2) These buttons are generated by the Radgrid and i am unable to access them like the example shows...

Could someone help me to get this functionality working again? Thanks,

4 Answers, 1 is accepted

answered on 19 Oct 2010, 05:17 PM

Yes, i have found those examples. However, its probably just me but i don't seem to be implementing it correctly. perhaps you could assists me on how to do this properly?

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

using Telerik.Web.UI;

using System.Data;

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

{

protected void Page_Load(object sender, EventArgs e)

{

if (!Page.IsPostBack)

{

GridSortExpression expression = new GridSortExpression();

expression.FieldName = "AdmitDate";

//expression.SetSortOrder("Descending");

RadGrid1.MasterTableView.SortExpressions.AddSortExpression(expression);

}

protected void RadGrid1_ItemDataBound(object sender, GridItemEventArgs e)

{

if (e.Item is GridDataItem)

{

GridDataItem item = (GridDataItem)e.Item;

//foreach (GridColumn column in RadGrid1.MasterTableView.RenderColumns)

//{

// if (column is GridTemplateColumn)

// {

item["PtName"].ToolTip =

"<strong>Patient Name:</strong><br/>" + ((System.Data.DataRowView)(item.DataItem)).Row["PtName"].ToString() + "<br/><br/>" +

"<strong>Patient Notes:</strong><br/>" + ((System.Data.DataRowView)(item.DataItem)).Row["History"].ToString() + "<br/><br/>" +

"<strong>Status Notes:</strong><br/>" + ((System.Data.DataRowView)(item.DataItem)).Row["Status"].ToString();

RadToolTipManager1.TargetControls.Add(item["PtName"].ClientID, true);

// }

//}

Label AdmitDateLabel = item.FindControl("AdmitDateLabel") as Label;

if (AdmitDateLabel != null)

{

if (((System.Data.DataRowView)(item.DataItem)).Row["AdmitDate"].ToString() == "")

{

AdmitDateLabel.Text = "Pending";

}

Label InsLabel = item.FindControl("InsLabel") as Label;

if (InsLabel != null)

{

DataView Insurance_DataView = (DataView)Insurance_DataSource.Select(DataSourceSelectArguments.Empty);

int indx = 0;

if (Int32.TryParse(((System.Data.DataRowView)(item.DataItem)).Row["Ins"].ToString(), out indx))

{

Insurance_DataView.Sort = "ID";

InsLabel.Text = Insurance_DataView[Insurance_DataView.Find(indx)]["Name"].ToString();

}

else

{

InsLabel.Text = "";

}

Label ReferralLabel = item.FindControl("ReferralLabel") as Label;

if (ReferralLabel != null)

{

DataView Referral_DataView = (DataView)Referral_DataSource.Select(DataSourceSelectArguments.Empty);

int indx = 0;

if (Int32.TryParse(((System.Data.DataRowView)(item.DataItem)).Row["Referral"].ToString(), out indx))

{

Referral_DataView.Sort = "ID";

ReferralLabel.Text = Referral_DataView[Referral_DataView.Find(indx)]["Name"].ToString();

}

else

{

ReferralLabel.Text = "";

}

Label LOCLabel = item.FindControl("LOCLabel") as Label;

if (LOCLabel != null)

{

DataView CareLevel_DataView = (DataView)CareLevel_DataSource.Select(DataSourceSelectArguments.Empty);

int indx = 0;

if (Int32.TryParse(((System.Data.DataRowView)(item.DataItem)).Row["LOC"].ToString(), out indx))

{

CareLevel_DataView.Sort = "ID";

LOCLabel.Text = CareLevel_DataView[CareLevel_DataView.Find(indx)]["CareLevel"].ToString();

}

else

{

LOCLabel.Text = "";

}

Label CampaignLabel = item.FindControl("CampaignLabel") as Label;

if (CampaignLabel != null)

{

DataView Campaigns_DataView = (DataView)Campaigns_DataSource.Select(DataSourceSelectArguments.Empty);

int indx = 0;

if (Int32.TryParse(((System.Data.DataRowView)(item.DataItem)).Row["Campaign"].ToString(), out indx))

{

Campaigns_DataView.Sort = "ID";

CampaignLabel.Text = Campaigns_DataView[Campaigns_DataView.Find(indx)]["Campaign"].ToString();

}

else

{

CampaignLabel.Text = "";

}

Label CCRepLabel = item.FindControl("CCRepLabel") as Label;

if (CCRepLabel != null)

{

DataView CCReps_DataView = (DataView)CCReps_DataSource.Select(DataSourceSelectArguments.Empty);

int indx = 0;

if (Int32.TryParse(((System.Data.DataRowView)(item.DataItem)).Row["CCRep"].ToString(), out indx))

{

CCReps_DataView.Sort = "ID";

CCRepLabel.Text = CCReps_DataView[CCReps_DataView.Find(indx)]["Name"].ToString();

}

else

{

CCRepLabel.Text = "";

}

Label StateLabel = item.FindControl("StateLabel") as Label;

if (StateLabel != null)

{

DataView States_DataView = (DataView)States_DataSource.Select(DataSourceSelectArguments.Empty);

int indx = 0;

if (Int32.TryParse(((System.Data.DataRowView)(item.DataItem)).Row["State"].ToString(), out indx))

{

States_DataView.Sort = "ID";

StateLabel.Text = States_DataView[States_DataView.Find(indx)]["StateName"].ToString();

}

else

{

StateLabel.Text = "";

}

<%@ Page Title="" Language="C#" MasterPageFile="~/App_Master/Admin.master" AutoEventWireup="true"

CodeFile="Admissions.aspx.cs" Inherits="Admin_Admissions" Theme="Reports" %>

<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" runat="Server">

<br />

<div class="container_label">

Add/Update/Delete Lead Records:</div>

<div>

<telerik:RadAjaxLoadingPanel ID="RadAjaxLoadingPanel1" runat="server" Skin="Office2007">

</telerik:RadAjaxLoadingPanel>

<telerik:RadAjaxPanel ID="RadAjaxPanel1" runat="server" HorizontalAlign="NotSet"

LoadingPanelID="RadAjaxLoadingPanel1">

<telerik:RadToolTipManager ID="RadToolTipManager1" OffsetY="-1" HideEvent="LeaveToolTip"

runat="server" EnableShadow="true" RelativeTo="Element" Skin="Default" Height="150px"

Width="250px" Animation="Resize" AutoCloseDelay="2000" Overlay="False" OffsetX="0"

AnimationDuration="300">

</telerik:RadToolTipManager>

<telerik:RadGrid ID="RadGrid1" runat="server" AllowFilteringByColumn="True" AllowPaging="True"

AllowSorting="True" AutoGenerateDeleteColumn="True" DataSourceID="Admissions_DataSource"

GridLines="None" ShowGroupPanel="True" Skin="Office2007" Width="1400px" Height="800px"

PageSize="75" ShowFooter="True" AutoGenerateColumns="False" OnItemDataBound="RadGrid1_ItemDataBound"

AllowAutomaticDeletes="True" AllowAutomaticInserts="True" AllowAutomaticUpdates="True">

<ExportSettings ExportOnlyData="True" HideStructureColumns="True" FileName="LeadsExport"

IgnorePaging="True" OpenInNewWindow="True">

</ExportSettings>

<MasterTableView DataKeyNames="ID" CommandItemDisplay="Top" DataSourceID="Admissions_DataSource"

EditMode="PopUp" GroupLoadMode="Client" InsertItemPageIndexAction="ShowItemOnCurrentPage">

<CommandItemSettings ExportToPdfText="Export to Pdf" ShowExportToExcelButton="True"

ShowExportToPdfButton="True" />

<Columns>

<telerik:GridEditCommandColumn ButtonType="ImageButton" EditText="" HeaderStyle-Width="30">

<HeaderStyle Width="30px" />

</telerik:GridEditCommandColumn>

<telerik:GridTemplateColumn AllowFiltering="False" DataField="AdmitDate" DataType="System.DateTime"

HeaderText="Admit Date" SortExpression="AdmitDate" GroupByExpression="AdmitDate Group By AdmitDate desc"

UniqueName="AdmitDate" HeaderStyle-Width="95">

<EditItemTemplate>

<telerik:RadDatePicker ID="RadDatePicker2" runat="server" Culture="English (United States)"

DbSelectedDate='<%# Bind("AdmitDate") %>' Skin="Office2007" ShowPopupOnFocus="True">

<Calendar Skin="Office2007" UseColumnHeadersAsSelectors="False" UseRowHeadersAsSelectors="False"

ViewSelectorText="x">

</Calendar>

<DatePopupButton HoverImageUrl="" ImageUrl="" />

<DateInput DateFormat="M/d/yyyy" DisplayDateFormat="M/d/yyyy">

</DateInput>

</telerik:RadDatePicker>

</EditItemTemplate>

<ItemTemplate>

<asp:Label ID="AdmitDateLabel" runat="server" Text='<%# Bind("AdmitDate", "{0:MM/dd/yyyy}") %>'></asp:Label>

</ItemTemplate>

<HeaderStyle Width="95px" />

</telerik:GridTemplateColumn>

<telerik:GridTemplateColumn AllowFiltering="False" DataField="CallDate" DataType="System.DateTime"

HeaderText="Call Date" SortExpression="CallDate" GroupByExpression="CallDate Group By CallDate desc"

UniqueName="CallDate" HeaderStyle-Width="95">

<EditItemTemplate>

<telerik:RadDatePicker ID="RadDatePicker3" runat="server" Culture="English (United States)"

DbSelectedDate='<%# Bind("CallDate") %>' ShowPopupOnFocus="True" Skin="Office2007">

<Calendar UseColumnHeadersAsSelectors="False" UseRowHeadersAsSelectors="False" ViewSelectorText="x"

Skin="Office2007">

</Calendar>

<DatePopupButton HoverImageUrl="" ImageUrl="" />

<DateInput DateFormat="M/d/yyyy" DisplayDateFormat="M/d/yyyy">

</DateInput>

</telerik:RadDatePicker>

<asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server" ControlToValidate="RadDatePicker3"

ErrorMessage="Call Date Required"></asp:RequiredFieldValidator>

</EditItemTemplate>

<ItemTemplate>

<asp:Label ID="CallDateLabel" runat="server" Text='<%# Bind("CallDate", "{0:MM/dd/yyyy}") %>'></asp:Label>

</ItemTemplate>

<HeaderStyle Width="95px" />

</telerik:GridTemplateColumn>

<telerik:GridTemplateColumn DataField="PtName" Groupable="False" HeaderText="Patient Name"

SortExpression="PtName" UniqueName="PtName" ItemStyle-Wrap="false">

<EditItemTemplate>

<telerik:RadTextBox ID="RadTextBox1" runat="server" EmptyMessage="Patient Name" Skin="Office2007"

Text='<%# Bind("PtName") %>' Width="125px">

</telerik:RadTextBox>

<asp:RequiredFieldValidator ID="RequiredFieldValidator2" runat="server" ControlToValidate="RadTextBox1"

ErrorMessage="Patient name Required"></asp:RequiredFieldValidator>

</EditItemTemplate>

<ItemTemplate>

<asp:Label ID="PtNameLabel" runat="server" Text='<%# Bind("PtName") %>'></asp:Label>

</ItemTemplate>

<ItemStyle Wrap="False" />

</telerik:GridTemplateColumn>

<telerik:GridTemplateColumn DataField="Ins" DataType="System.Int32" HeaderText="Insurance"

SortExpression="Ins" GroupByExpression="Ins Group By Ins desc" UniqueName="Ins"

HeaderStyle-Width="140">

<EditItemTemplate>

<telerik:RadComboBox ID="RadComboBox1" runat="server" DataSourceID="Insurance_DataSource"

DataTextField="Name" DataValueField="ID" SelectedValue='<%# Bind("Ins") %>' Skin="Office2007"

NoWrap="True" Sort="Ascending">

</telerik:RadComboBox>

</EditItemTemplate>

<ItemTemplate>

<asp:Label ID="InsLabel" runat="server" Text='<%# Bind("Ins") %>'></asp:Label>

</ItemTemplate>

<HeaderStyle Width="140px" />

</telerik:GridTemplateColumn>

<telerik:GridTemplateColumn AllowFiltering="False" DataField="Referral" DataType="System.Int32"

HeaderText="Referrer" SortExpression="Referral" GroupByExpression="Referral Group By Referral desc"

UniqueName="Referral" HeaderStyle-Width="100">

<EditItemTemplate>

<telerik:RadComboBox ID="RadComboBox2" runat="server" DataSourceID="Referral_DataSource"

DataTextField="Name" DataValueField="ID" SelectedValue='<%# Bind("Referral") %>'

Skin="Office2007" NoWrap="True" Sort="Ascending">

</telerik:RadComboBox>

</EditItemTemplate>

<ItemTemplate>

<asp:Label ID="ReferralLabel" runat="server" Text='<%# Bind("Referral") %>'></asp:Label>

</ItemTemplate>

<HeaderStyle Width="100px" />

</telerik:GridTemplateColumn>

<telerik:GridTemplateColumn AllowFiltering="False" DataField="LOC" DataType="System.Int32"

HeaderText="Level of Care" SortExpression="LOC" GroupByExpression="LOC Group By LOC desc"

UniqueName="LOC" HeaderStyle-Width="90">

<EditItemTemplate>

<telerik:RadComboBox ID="RadComboBox3" runat="server" DataSourceID="CareLevel_DataSource"

DataTextField="CareLevel" DataValueField="ID" SelectedValue='<%# Bind("LOC") %>'

Skin="Office2007" NoWrap="True" Sort="Ascending">

</telerik:RadComboBox>

</EditItemTemplate>

<ItemTemplate>

<asp:Label ID="LOCLabel" runat="server" Text='<%# Bind("LOC") %>'></asp:Label>

</ItemTemplate>

<HeaderStyle Width="90px" />

</telerik:GridTemplateColumn>

<telerik:GridTemplateColumn AllowFiltering="False" DataField="Arrived" Groupable="False"

HeaderText="Arrived?" SortExpression="Arrived" UniqueName="Arrived" HeaderStyle-Width="80">

<EditItemTemplate>

<telerik:RadComboBox ID="RadComboBox4" runat="server" SelectedValue='<%# Bind("Arrived") %>'

Skin="Office2007" NoWrap="True" Sort="Ascending">

<Items>

<telerik:RadComboBoxItem runat="server" Text="Yes" Value="YES" />

<telerik:RadComboBoxItem runat="server" Text="No" Value="NO" />

<telerik:RadComboBoxItem runat="server" Text="Unknown" Value="UNKNOWN" />

</Items>

</telerik:RadComboBox>

</EditItemTemplate>

<ItemTemplate>

<asp:Label ID="ArrivedLabel" runat="server" Text='<%# Bind("Arrived") %>'></asp:Label>

</ItemTemplate>

<HeaderStyle Width="80px" />

</telerik:GridTemplateColumn>

<telerik:GridTemplateColumn AllowFiltering="False" DataField="CCRep" DataType="System.Int32"

HeaderText="Call Center Rep" SortExpression="CCRep" GroupByExpression="CCRep Group By CCRep desc"

UniqueName="CCRep" HeaderStyle-Width="100">

<EditItemTemplate>

<telerik:RadComboBox ID="RadComboBox5" runat="server" DataSourceID="CCReps_DataSource"

DataTextField="Name" DataValueField="ID" SelectedValue='<%# Bind("CCRep") %>'

Skin="Office2007" NoWrap="True" Sort="Ascending">

</telerik:RadComboBox>

</EditItemTemplate>

<ItemTemplate>

<asp:Label ID="CCRepLabel" runat="server" Text='<%# Bind("CCRep") %>'></asp:Label>

</ItemTemplate>

<HeaderStyle Width="100px" />

</telerik:GridTemplateColumn>

<telerik:GridTemplateColumn DataField="Campaign" DataType="System.Int32" HeaderText="Campaign"

SortExpression="Campaign" UniqueName="Campaign" GroupByExpression="Campaign Group By Campaign desc"

HeaderStyle-Width="200">

<EditItemTemplate>

<telerik:RadComboBox ID="RadComboBox6" runat="server" DataSourceID="Campaigns_DataSource"

DataTextField="Campaign" DataValueField="ID" SelectedValue='<%# Bind("Campaign") %>'

Skin="Office2007" NoWrap="True" Sort="Ascending">

</telerik:RadComboBox>

</EditItemTemplate>

<ItemTemplate>

<asp:Label ID="CampaignLabel" runat="server" Text='<%# Bind("Campaign") %>'></asp:Label>

</ItemTemplate>

<HeaderStyle Width="200px" />

</telerik:GridTemplateColumn>

<telerik:GridTemplateColumn DataField="State" DataType="System.Int32" HeaderText="State"

SortExpression="State" GroupByExpression="State Group By State desc" UniqueName="State"

HeaderStyle-Width="120">

<EditItemTemplate>

<telerik:RadComboBox ID="RadComboBox7" runat="server" DataSourceID="States_DataSource"

DataTextField="StateName" DataValueField="ID" SelectedValue='<%# Bind("State") %>'

Skin="Office2007" NoWrap="True" Sort="Ascending">

</telerik:RadComboBox>

</EditItemTemplate>

<ItemTemplate>

<asp:Label ID="StateLabel" runat="server" Text='<%# Bind("State") %>'></asp:Label>

</ItemTemplate>

<HeaderStyle Width="120px" />

</telerik:GridTemplateColumn>

<telerik:GridTemplateColumn AllowFiltering="False" DataField="Value" DataType="System.Decimal"

Groupable="False" HeaderText="ROI Value" SortExpression="Value" UniqueName="Value"

HeaderStyle-Width="80">

<EditItemTemplate>

<telerik:RadNumericTextBox ID="RadNumericTextBox1" runat="server" Culture="English (United States)"

DbValue='<%# Bind("Value") %>' Skin="Office2007" Type="Currency" Value="0" Width="125px"

EmptyMessage="Enter Dollar Value" DataType="System.Decimal">

</telerik:RadNumericTextBox>

</EditItemTemplate>

<ItemTemplate>

<asp:Label ID="ValueLabel" runat="server" Text='<%# Bind("Value", "{0:C}") %>'></asp:Label>

</ItemTemplate>

<HeaderStyle Width="80px" />

</telerik:GridTemplateColumn>

<telerik:GridTemplateColumn AllowFiltering="False" DataField="Status" HeaderText="Status"

SortExpression="Status" GroupByExpression="Status Group By Status desc" UniqueName="Status"

ItemStyle-Wrap="false" Visible="False">

<EditItemTemplate>

<telerik:RadTextBox ID="RadTextBox3" runat="server" Skin="Office2007" Text='<%# Bind("Status") %>'

Width="125px">

</telerik:RadTextBox>

</EditItemTemplate>

<ItemTemplate>

<asp:Label ID="StatusLabel" runat="server" Text='<%# Bind("Status") %>'></asp:Label>

</ItemTemplate>

<ItemStyle Wrap="False" />

</telerik:GridTemplateColumn>

<telerik:GridTemplateColumn AllowFiltering="False" DataField="History" Groupable="False"

HeaderText="Notes" SortExpression="History" UniqueName="History" ItemStyle-Wrap="false"

Visible="False">

<EditItemTemplate>

<telerik:RadTextBox ID="RadTextBox2" runat="server" EmptyMessage="Enter History/Details/Notes"

Height="75px" Skin="Office2007" Text='<%# Bind("History") %>' TextMode="MultiLine"

Width="200px">

</telerik:RadTextBox>

</EditItemTemplate>

<ItemTemplate>

<asp:Label ID="HistoryLabel" runat="server" Text='<%# Bind("History") %>'></asp:Label>

</ItemTemplate>

<ItemStyle Wrap="False" />

</telerik:GridTemplateColumn>

</Columns>

<EditFormSettings>

<EditColumn UniqueName="EditCommandColumn1">

</EditColumn>

</EditFormSettings>

</MasterTableView>

<GroupingSettings ShowUnGroupButton="True" />

<ClientSettings AllowDragToGroup="True">

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

</ClientSettings>

</telerik:RadGrid>

</telerik:RadAjaxPanel>

<br />

</div>

<asp:SqlDataSource ID="Admissions_DataSource" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>"

InsertCommand="INSERT INTO [Admissions] ([CallDate], [PtName], [Ins], [Referral], [AdmitDate], [History], [LOC], [Arrived], [CCRep], [Status], [Campaign], [Value], [State]) VALUES (@CallDate, @PtName, @Ins, @Referral, @AdmitDate, @History, @LOC, @Arrived, @CCRep, @Status, @Campaign, @Value, @State)"

SelectCommand="SELECT [ID], [CallDate], [PtName], [Ins], [Referral], [AdmitDate], [History], [LOC], [Arrived], [CCRep], [Status], [Campaign], [Value], [State] FROM [Admissions] ORDER BY ISNULL(AdmitDate, '20550101')"

DeleteCommand="DELETE FROM [Admissions] WHERE [ID] = @original_ID" UpdateCommand="UPDATE [Admissions] SET [CallDate] = @CallDate, [PtName] = @PtName, [Ins] = @Ins, [Referral] = @Referral, [AdmitDate] = @AdmitDate, [History] = @History, [LOC] = @LOC, [Arrived] = @Arrived, [CCRep] = @CCRep, [Status] = @Status, [Campaign] = @Campaign, [Value] = @Value, [State] = @State WHERE [ID] = @original_ID"

ConflictDetection="CompareAllValues" OldValuesParameterFormatString="original_{0}">

<DeleteParameters>

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

</DeleteParameters>

<UpdateParameters>

<asp:Parameter Name="CallDate" DbType="Date" />

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

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

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

<asp:Parameter Name="AdmitDate" DbType="Date" />

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

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

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

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

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

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

<asp:Parameter Name="Value" Type="Decimal" />

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

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

</UpdateParameters>

<InsertParameters>

<asp:Parameter Name="CallDate" DbType="Date" />

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

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

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

<asp:Parameter Name="AdmitDate" DbType="Date" />

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

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

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

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

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

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

<asp:Parameter Name="Value" Type="Decimal" />

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

</InsertParameters>

</asp:SqlDataSource>

<asp:SqlDataSource ID="CCReps_DataSource" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>"

SelectCommand="SELECT [ID], [Name] FROM [CCReps] ORDER BY [Name]"></asp:SqlDataSource>

<asp:SqlDataSource ID="Insurance_DataSource" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>"

SelectCommand="SELECT [ID], [Name] FROM [Insurance] ORDER BY [Name]"></asp:SqlDataSource>

<asp:SqlDataSource ID="Referral_DataSource" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>"

SelectCommand="SELECT [ID], [Name] FROM [Referral] ORDER BY [Name]"></asp:SqlDataSource>

<asp:SqlDataSource ID="CareLevel_DataSource" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>"

SelectCommand="SELECT [ID], [CareLevel] FROM [CareLevels] ORDER BY [CareLevel]">

</asp:SqlDataSource>

<asp:SqlDataSource ID="Campaigns_DataSource" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>"

SelectCommand="SELECT [ID], [Campaign] FROM [Campaigns] ORDER BY [Campaign]">

</asp:SqlDataSource>

<asp:SqlDataSource ID="States_DataSource" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>"

SelectCommand="SELECT [ID], [StateCode], [StateName] FROM [States] ORDER BY [StateName]">

</asp:SqlDataSource>

</asp:Content>

answered on 19 Oct 2010, 05:40 PM

Ok so this fixed the export, however the LoadingPanel remains over the radgrid after export. Any ideas?

<%@ Page Title="" Language="C#" MasterPageFile="~/App_Master/Admin.master" AutoEventWireup="true"

CodeFile="Admissions.aspx.cs" Inherits="Admin_Admissions" Theme="Reports" %>

<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" runat="Server">

<script type="text/javascript">

function onRequestStart(sender, args)

{

if (args.get_eventTarget().indexOf("ExportToExcelButton") >= 0 ||

args.get_eventTarget().indexOf("ExportToWordButton") >= 0 ||

args.get_eventTarget().indexOf("ExportToCsvButton") >= 0)

{

args.set_enableAjax(false);

}

</script>

<br />

<div class="container_label">

Add/Update/Delete Lead Records:</div>

<div>

<telerik:RadAjaxLoadingPanel ID="RadAjaxLoadingPanel1" runat="server" Skin="Office2007">

</telerik:RadAjaxLoadingPanel>

<telerik:RadAjaxManager ID="RadAjaxManager1" runat="server">

<ClientEvents OnRequestStart="onRequestStart" />

<AjaxSettings>

<telerik:AjaxSetting AjaxControlID="RadGrid1">

<UpdatedControls>

<telerik:AjaxUpdatedControl ControlID="RadGrid1" LoadingPanelID="RadAjaxLoadingPanel1" />

</UpdatedControls>

</telerik:AjaxSetting>

</AjaxSettings>

</telerik:RadAjaxManager>

<telerik:RadAjaxPanel ID="RadAjaxPanel1" runat="server" HorizontalAlign="NotSet"

LoadingPanelID="RadAjaxLoadingPanel1">

<telerik:RadToolTipManager ID="RadToolTipManager1" OffsetY="-1" HideEvent="LeaveToolTip"

runat="server" EnableShadow="true" RelativeTo="Element" Skin="Default" Height="150px"

Width="250px" Animation="Resize" AutoCloseDelay="2000" Overlay="False" OffsetX="0"

AnimationDuration="300">

</telerik:RadToolTipManager>

<telerik:RadGrid ID="RadGrid1" runat="server" AllowFilteringByColumn="True" AllowPaging="True"

AllowSorting="True" AutoGenerateDeleteColumn="True" DataSourceID="Admissions_DataSource"

GridLines="None" ShowGroupPanel="True" Skin="Office2007" Width="1400px" Height="800px"

PageSize="75" ShowFooter="True" AutoGenerateColumns="False" OnItemDataBound="RadGrid1_ItemDataBound"

AllowAutomaticDeletes="True" AllowAutomaticInserts="True" AllowAutomaticUpdates="True">

<ExportSettings ExportOnlyData="True" HideStructureColumns="True" FileName="LeadsExport"

IgnorePaging="True" OpenInNewWindow="True">

</ExportSettings>

<MasterTableView DataKeyNames="ID" CommandItemDisplay="Top" DataSourceID="Admissions_DataSource"

EditMode="PopUp" GroupLoadMode="Client" InsertItemPageIndexAction="ShowItemOnCurrentPage">

<CommandItemSettings ExportToPdfText="Export to Pdf" ShowExportToExcelButton="True"

ShowExportToPdfButton="True" />

<Columns>

<telerik:GridEditCommandColumn ButtonType="ImageButton" EditText="" HeaderStyle-Width="30">

<HeaderStyle Width="30px" />

</telerik:GridEditCommandColumn>

<telerik:GridTemplateColumn AllowFiltering="False" DataField="AdmitDate" DataType="System.DateTime"

HeaderText="Admit Date" SortExpression="AdmitDate" GroupByExpression="AdmitDate Group By AdmitDate desc"

UniqueName="AdmitDate" HeaderStyle-Width="95">

<EditItemTemplate>

<telerik:RadDatePicker ID="RadDatePicker2" runat="server" Culture="English (United States)"

DbSelectedDate='<%# Bind("AdmitDate") %>' Skin="Office2007" ShowPopupOnFocus="True">

<Calendar Skin="Office2007" UseColumnHeadersAsSelectors="False" UseRowHeadersAsSelectors="False"

ViewSelectorText="x">

</Calendar>

<DatePopupButton HoverImageUrl="" ImageUrl="" />

<DateInput DateFormat="M/d/yyyy" DisplayDateFormat="M/d/yyyy">

</DateInput>

</telerik:RadDatePicker>

</EditItemTemplate>

<ItemTemplate>

<asp:Label ID="AdmitDateLabel" runat="server" Text='<%# Bind("AdmitDate", "{0:MM/dd/yyyy}") %>'></asp:Label>

</ItemTemplate>

<HeaderStyle Width="95px" />

</telerik:GridTemplateColumn>

<telerik:GridTemplateColumn AllowFiltering="False" DataField="CallDate" DataType="System.DateTime"

HeaderText="Call Date" SortExpression="CallDate" GroupByExpression="CallDate Group By CallDate desc"

UniqueName="CallDate" HeaderStyle-Width="95">

<EditItemTemplate>

<telerik:RadDatePicker ID="RadDatePicker3" runat="server" Culture="English (United States)"

DbSelectedDate='<%# Bind("CallDate") %>' ShowPopupOnFocus="True" Skin="Office2007">

<Calendar UseColumnHeadersAsSelectors="False" UseRowHeadersAsSelectors="False" ViewSelectorText="x"

Skin="Office2007">

</Calendar>

<DatePopupButton HoverImageUrl="" ImageUrl="" />

<DateInput DateFormat="M/d/yyyy" DisplayDateFormat="M/d/yyyy">

</DateInput>

</telerik:RadDatePicker>

<asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server" ControlToValidate="RadDatePicker3"

ErrorMessage="Call Date Required"></asp:RequiredFieldValidator>

</EditItemTemplate>

<ItemTemplate>

<asp:Label ID="CallDateLabel" runat="server" Text='<%# Bind("CallDate", "{0:MM/dd/yyyy}") %>'></asp:Label>

</ItemTemplate>

<HeaderStyle Width="95px" />

</telerik:GridTemplateColumn>

<telerik:GridTemplateColumn DataField="PtName" Groupable="False" HeaderText="Patient Name"

SortExpression="PtName" UniqueName="PtName" ItemStyle-Wrap="false">

<EditItemTemplate>

<telerik:RadTextBox ID="RadTextBox1" runat="server" EmptyMessage="Patient Name" Skin="Office2007"

Text='<%# Bind("PtName") %>' Width="125px">

</telerik:RadTextBox>

<asp:RequiredFieldValidator ID="RequiredFieldValidator2" runat="server" ControlToValidate="RadTextBox1"

ErrorMessage="Patient name Required"></asp:RequiredFieldValidator>

</EditItemTemplate>

<ItemTemplate>

<asp:Label ID="PtNameLabel" runat="server" Text='<%# Bind("PtName") %>'></asp:Label>

</ItemTemplate>

<ItemStyle Wrap="False" />

</telerik:GridTemplateColumn>

<telerik:GridTemplateColumn DataField="Ins" DataType="System.Int32" HeaderText="Insurance"

SortExpression="Ins" GroupByExpression="Ins Group By Ins desc" UniqueName="Ins"

HeaderStyle-Width="140">

<EditItemTemplate>

<telerik:RadComboBox ID="RadComboBox1" runat="server" DataSourceID="Insurance_DataSource"

DataTextField="Name" DataValueField="ID" SelectedValue='<%# Bind("Ins") %>' Skin="Office2007"

NoWrap="True" Sort="Ascending">

</telerik:RadComboBox>

</EditItemTemplate>

<ItemTemplate>

<asp:Label ID="InsLabel" runat="server" Text='<%# Bind("Ins") %>'></asp:Label>

</ItemTemplate>

<HeaderStyle Width="140px" />

</telerik:GridTemplateColumn>

<telerik:GridTemplateColumn AllowFiltering="False" DataField="Referral" DataType="System.Int32"

HeaderText="Referrer" SortExpression="Referral" GroupByExpression="Referral Group By Referral desc"

UniqueName="Referral" HeaderStyle-Width="100">

<EditItemTemplate>

<telerik:RadComboBox ID="RadComboBox2" runat="server" DataSourceID="Referral_DataSource"

DataTextField="Name" DataValueField="ID" SelectedValue='<%# Bind("Referral") %>'

Skin="Office2007" NoWrap="True" Sort="Ascending">

</telerik:RadComboBox>

</EditItemTemplate>

<ItemTemplate>

<asp:Label ID="ReferralLabel" runat="server" Text='<%# Bind("Referral") %>'></asp:Label>

</ItemTemplate>

<HeaderStyle Width="100px" />

</telerik:GridTemplateColumn>

<telerik:GridTemplateColumn AllowFiltering="False" DataField="LOC" DataType="System.Int32"

HeaderText="Level of Care" SortExpression="LOC" GroupByExpression="LOC Group By LOC desc"

UniqueName="LOC" HeaderStyle-Width="90">

<EditItemTemplate>

<telerik:RadComboBox ID="RadComboBox3" runat="server" DataSourceID="CareLevel_DataSource"

DataTextField="CareLevel" DataValueField="ID" SelectedValue='<%# Bind("LOC") %>'

Skin="Office2007" NoWrap="True" Sort="Ascending">

</telerik:RadComboBox>

</EditItemTemplate>

<ItemTemplate>

<asp:Label ID="LOCLabel" runat="server" Text='<%# Bind("LOC") %>'></asp:Label>

</ItemTemplate>

<HeaderStyle Width="90px" />

</telerik:GridTemplateColumn>

<telerik:GridTemplateColumn AllowFiltering="False" DataField="Arrived" Groupable="False"

HeaderText="Arrived?" SortExpression="Arrived" UniqueName="Arrived" HeaderStyle-Width="80">

<EditItemTemplate>

<telerik:RadComboBox ID="RadComboBox4" runat="server" SelectedValue='<%# Bind("Arrived") %>'

Skin="Office2007" NoWrap="True" Sort="Ascending">

<Items>

<telerik:RadComboBoxItem runat="server" Text="Yes" Value="YES" />

<telerik:RadComboBoxItem runat="server" Text="No" Value="NO" />

<telerik:RadComboBoxItem runat="server" Text="Unknown" Value="UNKNOWN" />

</Items>

</telerik:RadComboBox>

</EditItemTemplate>

<ItemTemplate>

<asp:Label ID="ArrivedLabel" runat="server" Text='<%# Bind("Arrived") %>'></asp:Label>

</ItemTemplate>

<HeaderStyle Width="80px" />

</telerik:GridTemplateColumn>

<telerik:GridTemplateColumn AllowFiltering="False" DataField="CCRep" DataType="System.Int32"

HeaderText="Call Center Rep" SortExpression="CCRep" GroupByExpression="CCRep Group By CCRep desc"

UniqueName="CCRep" HeaderStyle-Width="100">

<EditItemTemplate>

<telerik:RadComboBox ID="RadComboBox5" runat="server" DataSourceID="CCReps_DataSource"

DataTextField="Name" DataValueField="ID" SelectedValue='<%# Bind("CCRep") %>'

Skin="Office2007" NoWrap="True" Sort="Ascending">

</telerik:RadComboBox>

</EditItemTemplate>

<ItemTemplate>

<asp:Label ID="CCRepLabel" runat="server" Text='<%# Bind("CCRep") %>'></asp:Label>

</ItemTemplate>

<HeaderStyle Width="100px" />

</telerik:GridTemplateColumn>

<telerik:GridTemplateColumn DataField="Campaign" DataType="System.Int32" HeaderText="Campaign"

SortExpression="Campaign" UniqueName="Campaign" GroupByExpression="Campaign Group By Campaign desc"

HeaderStyle-Width="200">

<EditItemTemplate>

<telerik:RadComboBox ID="RadComboBox6" runat="server" DataSourceID="Campaigns_DataSource"

DataTextField="Campaign" DataValueField="ID" SelectedValue='<%# Bind("Campaign") %>'

Skin="Office2007" NoWrap="True" Sort="Ascending">

</telerik:RadComboBox>

</EditItemTemplate>

<ItemTemplate>

<asp:Label ID="CampaignLabel" runat="server" Text='<%# Bind("Campaign") %>'></asp:Label>

</ItemTemplate>

<HeaderStyle Width="200px" />

</telerik:GridTemplateColumn>

<telerik:GridTemplateColumn DataField="State" DataType="System.Int32" HeaderText="State"

SortExpression="State" GroupByExpression="State Group By State desc" UniqueName="State"

HeaderStyle-Width="120">

<EditItemTemplate>

<telerik:RadComboBox ID="RadComboBox7" runat="server" DataSourceID="States_DataSource"

DataTextField="StateName" DataValueField="ID" SelectedValue='<%# Bind("State") %>'

Skin="Office2007" NoWrap="True" Sort="Ascending">

</telerik:RadComboBox>

</EditItemTemplate>

<ItemTemplate>

<asp:Label ID="StateLabel" runat="server" Text='<%# Bind("State") %>'></asp:Label>

</ItemTemplate>

<HeaderStyle Width="120px" />

</telerik:GridTemplateColumn>

<telerik:GridTemplateColumn AllowFiltering="False" DataField="Value" DataType="System.Decimal"

Groupable="False" HeaderText="ROI Value" SortExpression="Value" UniqueName="Value"

HeaderStyle-Width="80">

<EditItemTemplate>

<telerik:RadNumericTextBox ID="RadNumericTextBox1" runat="server" Culture="English (United States)"

DbValue='<%# Bind("Value") %>' Skin="Office2007" Type="Currency" Value="0" Width="125px"

EmptyMessage="Enter Dollar Value" DataType="System.Decimal">

</telerik:RadNumericTextBox>

</EditItemTemplate>

<ItemTemplate>

<asp:Label ID="ValueLabel" runat="server" Text='<%# Bind("Value", "{0:C}") %>'></asp:Label>

</ItemTemplate>

<HeaderStyle Width="80px" />

</telerik:GridTemplateColumn>

<telerik:GridTemplateColumn AllowFiltering="False" DataField="Status" HeaderText="Status"

SortExpression="Status" GroupByExpression="Status Group By Status desc" UniqueName="Status"

ItemStyle-Wrap="false" Visible="False">

<EditItemTemplate>

<telerik:RadTextBox ID="RadTextBox3" runat="server" Skin="Office2007" Text='<%# Bind("Status") %>'

Width="125px">

</telerik:RadTextBox>

</EditItemTemplate>

<ItemTemplate>

<asp:Label ID="StatusLabel" runat="server" Text='<%# Bind("Status") %>'></asp:Label>

</ItemTemplate>

<ItemStyle Wrap="False" />

</telerik:GridTemplateColumn>

<telerik:GridTemplateColumn AllowFiltering="False" DataField="History" Groupable="False"

HeaderText="Notes" SortExpression="History" UniqueName="History" ItemStyle-Wrap="false"

Visible="False">

<EditItemTemplate>

<telerik:RadTextBox ID="RadTextBox2" runat="server" EmptyMessage="Enter History/Details/Notes"

Height="75px" Skin="Office2007" Text='<%# Bind("History") %>' TextMode="MultiLine"

Width="200px">

</telerik:RadTextBox>

</EditItemTemplate>

<ItemTemplate>

<asp:Label ID="HistoryLabel" runat="server" Text='<%# Bind("History") %>'></asp:Label>

</ItemTemplate>

<ItemStyle Wrap="False" />

</telerik:GridTemplateColumn>

</Columns>

<EditFormSettings>

<EditColumn UniqueName="EditCommandColumn1">

</EditColumn>

</EditFormSettings>

</MasterTableView>

<GroupingSettings ShowUnGroupButton="True" />

<ClientSettings AllowDragToGroup="True">

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

</ClientSettings>

</telerik:RadGrid>

</telerik:RadAjaxPanel>

<br />

</div>

<asp:SqlDataSource ID="Admissions_DataSource" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>"

InsertCommand="INSERT INTO [Admissions] ([CallDate], [PtName], [Ins], [Referral], [AdmitDate], [History], [LOC], [Arrived], [CCRep], [Status], [Campaign], [Value], [State]) VALUES (@CallDate, @PtName, @Ins, @Referral, @AdmitDate, @History, @LOC, @Arrived, @CCRep, @Status, @Campaign, @Value, @State)"

SelectCommand="SELECT [ID], [CallDate], [PtName], [Ins], [Referral], [AdmitDate], [History], [LOC], [Arrived], [CCRep], [Status], [Campaign], [Value], [State] FROM [Admissions] ORDER BY ISNULL(AdmitDate, '20550101')"

DeleteCommand="DELETE FROM [Admissions] WHERE [ID] = @original_ID" UpdateCommand="UPDATE [Admissions] SET [CallDate] = @CallDate, [PtName] = @PtName, [Ins] = @Ins, [Referral] = @Referral, [AdmitDate] = @AdmitDate, [History] = @History, [LOC] = @LOC, [Arrived] = @Arrived, [CCRep] = @CCRep, [Status] = @Status, [Campaign] = @Campaign, [Value] = @Value, [State] = @State WHERE [ID] = @original_ID"