<%
@ Page Language="C#" AutoEventWireup="true" CodeBehind="Default.aspx.cs" Inherits="TelerikTest1._Default" %>
<%
@ Register Assembly="Telerik.Web.UI" Namespace="Telerik.Web.UI" TagPrefix="telerik" %>
<!
DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<
html xmlns="http://www.w3.org/1999/xhtml" >
<
head runat="server">
<title>Untitled Page</title>
</
head>
<
body>
<form id="form1" runat="server">
<telerik:RadScriptManager ID="ScriptManager1" runat="server" EnableTheming="True">
</telerik:RadScriptManager>
<div>
<telerik:RadPanelBar ID="RadPanelBar1" runat="server" Width="1000">
<Items>
<telerik:RadPanelItem runat="server" Text="Customer Data" Expanded="True">
<Items>
<telerik:RadPanelItem Value="CustomerData" runat="server">
<ItemTemplate>
<table>
<tr>
<td>
<telerik:RadTextBox ID="txtLastName" MaxLength="50" Width="350px" Label="Last Name" LabelCssClass="LabelCustomer" runat="server">
</telerik:RadTextBox>
</td>
<td width="20px"> </td>
<td>
<telerik:RadTextBox ID="txtFirstName" MaxLength="50" Width="350px" Label="First Name" LabelCssClass="LabelCustomer" runat="server">
</telerik:RadTextBox>
</td>
</tr>
<tr>
<td>
<telerik:RadTextBox ID="txtStreet" MaxLength="50" Width="350px" Label="Street Address" LabelCssClass="LabelCustomer" runat="server">
</telerik:RadTextBox>
</td>
<td width="20px"> </td>
<td>
<telerik:RadTextBox ID="txtCity" MaxLength="50" Width="350px" Label="City" LabelCssClass="LabelCustomer" runat="server">
</telerik:RadTextBox>
</td>
</tr>
<tr>
<td>
<telerik:RadComboBox ID="cmbState" Label="State" LabelCssClass="LabelCustomerDDL" runat="server" Height="200px" Width="250px"
DropDownWidth="298px" EmptyMessage="Choose a State or Province" HighlightTemplatedItems="true"
EnableLoadOnDemand="true" MarkFirstMatch="true">
<HeaderTemplate>
<table style="width: 275px" cellspacing="0" cellpadding="0">
<tr>
<td style="width: 177px;">
State / Province
</td>
<td style="width: 60px;">
State Code
</td>
<td style="width: 40px;">
Country
</td>
</tr>
</table>
</HeaderTemplate>
<ItemTemplate>
<table style="width: 275px" cellspacing="0" cellpadding="0">
<tr>
<td style="width: 177px;">
Texas
</td>
<td style="width: 60px;">
TX
</td>
<td style="width: 40px;">
USA
</td>
</tr>
</table>
</ItemTemplate>
</telerik:RadComboBox>
</td>
<td width="20px"> </td>
<td>
<telerik:RadTextBox ID="txtPostalCode" MaxLength="50" Width="350px" Label="Postal Code" LabelCssClass="LabelCustomer" runat="server">
</telerik:RadTextBox>
</td>
</tr>
</table>
</ItemTemplate>
</telerik:RadPanelItem>
</Items>
</telerik:RadPanelItem>
<telerik:RadPanelItem runat="server" Text="Vehicle Data">
<Items>
<telerik:RadPanelItem Value="VehicleData" runat="server">
<ItemTemplate>
<table>
<tr>
<td colspan="3">
<telerik:RadTextBox ID="txtVin" MaxLength="50" Width="350px" Label="VIN Number" LabelCssClass="LabelCustomer" runat="server">
</telerik:RadTextBox>
</td>
</tr>
<tr>
<td>
<telerik:RadTextBox ID="txtLicense" MaxLength="4" Width="350px" Label="License Plate" LabelCssClass="LabelCustomer" runat="server">
</telerik:RadTextBox>
</td>
<td width="20px"> </td>
<td>
<telerik:RadTextBox ID="txtYear" MaxLength="50" Width="350px" Label="Year" LabelCssClass="LabelCustomer" runat="server">
</telerik:RadTextBox>
</td>
</tr>
<tr>
<td>
<telerik:RadComboBox ID="cmbVehicleMake" Label="Make" LabelCssClass="LabelCustomerDDL" runat="server" Height="200px" Width="200px"
DropDownWidth="200px" EmptyMessage="Choose a Vehicle Make" HighlightTemplatedItems="true"
EnableLoadOnDemand="true" MarkFirstMatch="true">
</telerik:RadComboBox>
</td>
<td width="20px"> </td>
<td>
<telerik:RadComboBox ID="cmbVehicleModel" Label="Model" LabelCssClass="LabelCustomerDDL" runat="server" Height="200px" Width="200px"
DropDownWidth="200px" EmptyMessage="Choose a Vehicle Model" HighlightTemplatedItems="true"
EnableLoadOnDemand="true" MarkFirstMatch="true">
</telerik:RadComboBox>
</td>
</tr>
</table>
</ItemTemplate>
</telerik:RadPanelItem>
</Items>
</telerik:RadPanelItem>
</Items>
</telerik:RadPanelBar>
<telerik:RadAjaxManager ID="RadAjaxManager1" runat="server">
</telerik:RadAjaxManager>
</div>
</form>
</
body>
</
html>
| <% |
| grdReport.DataSource = ViewData["Report"]; |
| grdReport.DataBind(); |
| grdReport.ExportSettings.ExportOnlyData = false; |
| grdReport.ExportSettings.IgnorePaging = true; |
| grdReport.ExportSettings.OpenInNewWindow = true; |
| grdReport.MasterTableView.ExportToExcel(); |
| %> |
Hi..
i am using telerik rad grid.There ia m using group by panel.Can you suggest any way to select one group at a time and way to get that selected group with all the child items in it in server side as well as client side
Thanks
Tanmoy Sinha
ExcelMLExportStylesCreated event fired I have following code:
if (style.Id == "itemStyle")
{
style.NumberFormat.FormatType = Telerik.Web.UI.GridExcelBuilder.
NumberFormatType.Currency;
style.AlignmentElement.HorizontalAlignment = Telerik.Web.UI.GridExcelBuilder.
HorizontalAlignmentType.Left;
style.InteriorStyle.Color = System.Drawing.
Color.WhiteSmoke;
style.InteriorStyle.Pattern = Telerik.Web.UI.GridExcelBuilder.
InteriorPatternType.Solid;
}
else if (style.Id == "alternatingItemStyle")
{
style.NumberFormat.FormatType = Telerik.Web.UI.GridExcelBuilder.
NumberFormatType.Currency;
style.AlignmentElement.HorizontalAlignment = Telerik.Web.UI.GridExcelBuilder.
HorizontalAlignmentType.Left;
style.InteriorStyle.Color = System.Drawing.
Color.LightGray;
style.InteriorStyle.Pattern = Telerik.Web.UI.GridExcelBuilder.
InteriorPatternType.Solid;
}
When the currency is set,its applied to every column which contain number including ServiceHours and ServiceMins.I need that curency applied only to PaidAmount column.But if I comment out style currency format,PaidAmount column trailing zero cuts off and no dollar sign appeared.
Please help me.Thanks
<asp:UpdatePanel ID="UpdatePanel1" runat="server">
<ContentTemplate>
<
telerik:RadScheduler AllowInsert="false" HoursPanelTimeFormat="hh:mm tt" OnAppointmentDataBound="RadScheduler1_AppointmentDataBound"
OnAppointmentCreated="RadScheduler1_AppointmentCreated" runat="server" ID="RadScheduler1"
Skin="Office2007" Height="545px" CustomAttributeNames="StatusId" Width="690px"
ShowFooter="false" SelectedDate="2010-03-18" DayStartTime="07:00:00" DayEndTime="21:00:00"
FirstDayOfWeek="Monday" LastDayOfWeek="Sunday" EnableDescriptionField="true"
ShowNavigationPane="false" OnAppointmentDelete="RadScheduler1_AppointmentDelete"
DataSubjectField="1" DataStartField="1" DataEndField="1" ShowAllDayRow="false"
AllowEdit="false" DataKeyField="" DataDescriptionField="Description" OnTimeSlotContextMenuItemClicked="RadScheduler1_TimeSlotContextMenuItemClicked"
AllowDelete="false" OnAppointmentContextMenuItemClicked="RadScheduler1_AppointmentContextMenuItemClicked"
OnNavigationCommand="RadScheduler1_NavigationCommand" OnTimeSlotCreated="RadScheduler1_TimeSlotCreated">
<AppointmentContextMenuSettings EnableDefault="false" />
<TimelineView UserSelectable="false" />
<AppointmentTemplate>
<%
# Eval("Subject")%>
<br />
<asp:Label runat="server" ID="Teacher" />
<br />
<asp:Label runat="server" ID="Students" />
</AppointmentTemplate>
<AppointmentContextMenus>
<telerik:RadSchedulerContextMenu runat="server" DataTextField="Status" DataValueField="StatusId"
ID="SchedulerAppointmentContextMenu" AppendDataBoundItems="true">
<Items>
<telerik:RadMenuItem Text="Copy" Value="Copy" />
<telerik:RadMenuItem IsSeparator="True" />
<telerik:RadMenuItem Text="Edit" Value="Edit" />
<telerik:RadMenuItem IsSeparator="True" />
</Items>
</telerik:RadSchedulerContextMenu>
</AppointmentContextMenus>
<TimeSlotContextMenus>
<telerik:RadSchedulerContextMenu runat="server" ID="SchedulerTimeSlotContextMenu">
<Items>
<telerik:RadMenuItem Text="New Appointment" Value="New" />
<telerik:RadMenuItem IsSeparator="true" />
<telerik:RadMenuItem Text="Paste" Value="Paste" />
</Items>
</telerik:RadSchedulerContextMenu>
</TimeSlotContextMenus>
<TimeSlotContextMenuSettings EnableDefault="False" />
</telerik:RadScheduler>
</
ContentTemplate>
<Triggers>
</Triggers>
</asp:UpdatePanel>
CS Page Code is Below.:-
protected
void RadScheduler1_TimeSlotContextMenuItemClicked(object sender, TimeSlotContextMenuItemClickedEventArgs e)
{
if (e.MenuItem.Value == "New")
{
//RadWindowManager1.Windows[0].Op
//Alert.Show("Chandan Kumar");
RadWindowManager windowManager = new RadWindowManager();
RadWindow widnow1 = new RadWindow();
// Set the window properties
//e.TimeSlot.Duration.
widnow1.NavigateUrl =
"~/Appointment/AppointmentDetails.aspx?FacilityId=" + ddlFacility.SelectedValue + "&StTime=" + e.TimeSlot.Start.Hour.ToString() + "&EndTime=" + RadScheduler1.DayEndTime.Hours.ToString() + "&appDate=" + RadScheduler1.SelectedDate.Date.ToString("dd/MM/yyyy") + "&appid=0&doctorId=" + ddlDoctor.SelectedValue + "&TimeInterval=" + RadScheduler1.MinutesPerRow.ToString() + "&FromTimeHour=" + e.TimeSlot.Start.Hour.ToString() + "&FromTimeMin=" + e.TimeSlot.Start.Minute.ToString() + "&Provider=" + ddlDoctor.SelectedItem.Text; ;
widnow1.Height = 500;
widnow1.Width = 700;
widnow1.Top = 40;
widnow1.Left = 100;
widnow1.ID =
"RadWindow1";
widnow1.OnClientClose =
"OnClientClose";
widnow1.VisibleOnPageLoad =
true; // Set this property to True for showing window from code
widnow1.Modal =
true;
widnow1.VisibleStatusbar =
false;
widnow1.Behavior =
WindowBehaviors.Close | WindowBehaviors.Move;
windowManager.Windows.Add(widnow1);
this.Form.Controls.Add(widnow1);
}
else if (e.MenuItem.Value == "Paste")
{
if (Convert.ToString(ViewState["CopyAppId"]) != "")
{
DAL.
DAL dl = new DAL.DAL(DAL.DAL.DBType.SqlServer, sConString);
Hashtable hshtableout = new Hashtable();
Hashtable hshtablein = new Hashtable();
hshtablein.Add(
"inyHospitalLocationId", Session["HospitalLocationID"]);
hshtablein.Add(
"intCopyAppointmentID", Convert.ToInt64(ViewState["CopyAppId"]));
hshtablein.Add(
"chrAppFromTime", e.TimeSlot.Start.Hour.ToString()+ ":" + e.TimeSlot.Start.Minute.ToString() );
hshtablein.Add(
"chrAppointmentDate", RadScheduler1.SelectedDate.ToString("dd/MM/yyyy"));
hshtablein.Add(
"intDoctorId", ddlDoctor.SelectedValue);
hshtablein.Add(
"intEncodedBy", Session["UserID"].ToString());
hshtableout.Add(
"intAppointmentNo", SqlDbType.Int);
hshtableout.Add(
"chvErrorStatus", SqlDbType.VarChar);
hshtableout = dl.getOutputParametersValues(
CommandType.StoredProcedure, "UspCopyDoctorAppointment", hshtablein, hshtableout);
//Cache.Remove("copyappointmentId");
//Alert.ShowAjaxMsg("Appointment Updated - " + hshtableout["intAppointmentNo"].ToString(), Page);
btnRefresh_OnClick(sender, e);
}
}
}