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);
}