protected void loadBtn_Click(object sender, EventArgs e) { string fileId = "CustomPersistenceSettingsKey"; RadPersistenceManager1.StorageProviderKey = fileId; RadPersistenceManager1.LoadState(); RadPivotGrid1.Rebind(); }
protected void ButtonExcel_Click(object sender, EventArgs e) { string alternateText = (sender as ImageButton).AlternateText; RadPivotGrid1.ExportSettings.Excel.Format = (PivotGridExcelFormat)Enum.Parse(typeof(PivotGridExcelFormat), alternateText); RadPivotGrid1.ExportSettings.IgnorePaging = CheckBox1.Checked; RadPivotGrid1.ExportToExcel(); }
protected void RadPushButton1_Click(object sender, EventArgs e) { CustomerRFDataSource.DataBind(); RadPivotGrid1.Rebind(); BOMDataSource.DataBind(); RadGrid1.Rebind(); //SelectCommand="select distinct(part) as part from part where type = 'F' union select distinct(left(part,7)) as part from part where type = 'F' order by 1 asc"> }
protected void btnExport_Click(object sender, EventArgs e) { if (dtStart.SelectedDate == null || dtEnd.SelectedDate == null) { return; } string dateformat = "MMMdd"; RadPivotGrid1.ExportSettings.IgnorePaging = true; RadPivotGrid1.ExportSettings.FileName = "Press_" + ((DateTime)dtStart.SelectedDate).ToString(dateformat) + "_to_" + ((DateTime)dtEnd.SelectedDate).ToString(dateformat); RadPivotGrid1.ExportToExcel(); }
protected void ddlTerm_SelectedIndexChanged(object sender, EventArgs e) { if (ddlTerm.SelectedItem.Value == "-1") { term = string.Empty; } else { term = ddlTerm.SelectedItem.Value; } RadPivotGrid1.Rebind(); }
protected void btnExport_Click(object sender, EventArgs e) { try { RadPivotGrid1.ExportSettings.Excel.Format = (PivotGridExcelFormat)Enum.Parse(typeof(PivotGridExcelFormat), "Xlsx"); RadPivotGrid1.ExportSettings.IgnorePaging = true; RadPivotGrid1.ExportSettings.OpenInNewWindow = true; RadPivotGrid1.ExportSettings.FileName = "Summary"; RadPivotGrid1.ExportToExcel(); } catch (Exception ex) { RadWindowManager1.RadAlert(ex.Source + " - " + ex.Message, 400, 200, "Error!", null, ""); } }
protected void Page_Load(object sender, EventArgs e) { VehicleRadGridDataSource.DataBind(); RadPivotGrid1.Rebind(); }
protected void RadPushButton2_Click(object sender, EventArgs e) { RadPivotGrid1.ExportToExcel(); }
protected void chkHor_CheckedChanged(object sender, EventArgs e) { RadPivotGrid2.Visible = false; RadPivotGrid1.Visible = true; RadPivotGrid1.Rebind(); }
protected void ButtonWord_Click(object sender, System.Web.UI.ImageClickEventArgs e) { RadPivotGrid1.ExportSettings.IgnorePaging = CheckBox1.Checked; RadPivotGrid1.ExportToWord(); }
protected void btn_ConvertToExcel_Click(object sender, ImageClickEventArgs e) { RadPivotGrid1.ExportSettings.FileName = "Report"; RadPivotGrid1.ExportToExcel(); }