or
<
telerik:GridDateTimeColumn
UniqueName
=
"ShipDate"
DataField
=
"ShipDate"
PickerType
=
"DatePicker"
HeaderText
=
"Ship Date"
DataFormatString
=
"{0:D}"
CurrentFilterFunction
=
"EqualTo"
DataType
=
"System.DateTime"
FilterListOptions
=
"VaryByDataType"
>
</
telerik:GridDateTimeColumn
>
SELECT
StoreNumber,
AO.BoothNumber,
AO.ItemID,
ItemDescription,
CONVERT
(
VARCHAR
,ShipDate,101)
AS
ShipDate, .....
<div style="text-align: right;"> |
<span style="cursor: pointer; cursor: hand;"> |
<asp:ImageButton runat="server" ID="Button1" ImageUrl="Outlook.gif" AlternateText="Export to iCalendar" |
CommandName="Export" OnClientClick="Export(this, event); return false;" /> |
</span> |
</div> |
private void WriteCalendar(string data) |
{ |
HttpResponse response = Page.Response; |
response.Clear(); |
response.Buffer = true; |
response.ContentType = "text/calendar"; |
response.ContentEncoding = Encoding.UTF8; |
response.Charset = "utf-8"; |
response.AddHeader("Content-Disposition", "attachment;filename=\"RadSchedulerExport.ics\""); |
response.Write(data); |
response.End(); |
} |
protected void RadScheduler1_AppointmentCommand(object sender, AppointmentCommandEventArgs e) |
{ |
if (e.CommandName == "Export") |
{ |
WriteCalendar(RadScheduler.ExportToICalendar(e.Container.Appointment)); |
} |
} |
<input type="image" name="MasterCalendar1$RadScheduler1$ctl138$Button1" id="MasterCalendar1_RadScheduler1_ctl138_Button1" src="Outlook.gif" alt="Export to iCalendar" onclick="Export(this, event); return false;" style="border-width:0px;" /> |
<telerik:RadCodeBlock runat="server"> |
<script type="text/javascript"> |
function Export(sender, e) |
{ |
$find("<%= RadAjaxManager1.ClientID %>").__doPostBack(sender.name, ""); |
} |
</script> |
</telerik:RadCodeBlock> |
<
asp:Button
runat
=
"server"
ID
=
"Button1"
OnClick
=
"Button1_Click"
Text
=
"Export to Excel"
/>
protected
void
Button1_Click(
object
sender, EventArgs e)
{
ConfigureExport();
RadGrid1.MasterTableView.ExportToExcel();
}
public
void
ConfigureExport()
{
RadGrid1.ExportSettings.ExportOnlyData =
true
;
}
protected
void
RgProductNeedDataSource(
object
sender, GridNeedDataSourceEventArgs e)
{
int
startRowIndex = rgProduct.CurrentPageIndex * rgProduct.PageSize;
int
totalRows;
int
maximumRows = rgProduct.PageSize;
var pageIndex = startRowIndex / maximumRows;
rgProduct.DataSource = _datacontext.Products.Page(pageIndex, maximumRows, p => p.ProductCode,
true
,
out
totalRows);
}