
Duncan Evans
Top achievements
Rank 1
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:
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,
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
0
Hello Duncan,
Please examine the help article below and let me know if it helps.
Export from ajaxified grid
You can also refer to this online example.
Regards,
Pavlina
the Telerik team
Please examine the help article below and let me know if it helps.
Export from ajaxified grid
You can also refer to this online example.
Regards,
Pavlina
the Telerik team
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
0

Duncan Evans
Top achievements
Rank 1
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
>
0

Duncan Evans
Top achievements
Rank 1
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"
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
>
0

Duncan Evans
Top achievements
Rank 1
answered on 19 Oct 2010, 05:43 PM
Fixed it, forgot to remove the old AjaxPanel
<%@ 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"
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
>