private void BindChartToData() { // Create a series Series series = new Series("Series", ViewType.Line); series.ArgumentScaleType = ScaleType.DateTime; series.ValueScaleType = ScaleType.Numerical; ((LineSeriesView)series.View).LineMarkerOptions.Size = 20; // Bind series to data series.DataSource = ManualDataSet.RetrieveDataCache().Tables[0]; series.ArgumentDataMember = "MyDateTime"; series.ValueDataMembers.AddRange(new string[] { "MyData" }); WebChartControl1.Series.Add(series); // Adjust X axis options ((XYDiagram)WebChartControl1.Diagram).AxisX.DateTimeOptions.Format = DateTimeFormat.Custom; ((XYDiagram)WebChartControl1.Diagram).AxisX.DateTimeOptions.FormatString = "HH:mm:ss"; ((XYDiagram)WebChartControl1.Diagram).AxisX.Label.Staggered = true; ((XYDiagram)WebChartControl1.Diagram).AxisX.DateTimeMeasureUnit = DateTimeMeasurementUnit.Hour; //((XYDiagram)WebChartControl1.Diagram).AxisX.GridSpacingAuto = false; //((XYDiagram)WebChartControl1.Diagram).AxisX.GridSpacing = 1; WebChartControl1.DataBind(); }
public static DataSet RetrieveDataCache() { if (HttpContext.Current.Session["dataset"] == null) { HttpContext.Current.Session["dataset"] = ManualDataSet.CreateData(); } return((DataSet)HttpContext.Current.Session["dataset"]); }
public static ManualDataSet CreateData() { ManualDataSet ds = new ManualDataSet(); DataTable table = ds.Tables["table"]; table.Rows.Add(new object[] { 0, DateTime.Today, "A", 103 }); table.Rows.Add(new object[] { 1, DateTime.Today, "B", 200 }); table.Rows.Add(new object[] { 2, DateTime.Today, "C", 446 }); return(ds); }
public static ManualDataSet CreateData() { ManualDataSet ds = new ManualDataSet(); DataTable table = ds.Tables["table"]; table.Rows.Add(new object[] { 0, DateTime.Today, "A", 103 }); table.Rows.Add(new object[] { 1, DateTime.Today, "B", 200 }); table.Rows.Add(new object[] { 2, DateTime.Today.AddDays(1), "A", 788 }); table.Rows.Add(new object[] { 3, DateTime.Today.AddDays(1), "B", 787 }); table.Rows.Add(new object[] { 4, DateTime.Today.AddDays(2), "A", 152 }); table.Rows.Add(new object[] { 5, DateTime.Today.AddDays(2), "B", 565 }); return(ds); }
public static DataSet CreateData() { DataSet ds = new ManualDataSet(); DataTable table = ds.Tables["table"]; table.Rows.Add(new object[] { 0, DateTime.Today.AddHours(1), "A", 103 }); table.Rows.Add(new object[] { 1, DateTime.Today.AddHours(3), "B", 200 }); table.Rows.Add(new object[] { 2, DateTime.Today.AddHours(6), "C", 446 }); table.Rows.Add(new object[] { 3, DateTime.Today.AddHours(10), "D", 788 }); table.Rows.Add(new object[] { 4, DateTime.Today.AddHours(15), "E", 674 }); table.Rows.Add(new object[] { 5, DateTime.Today.AddHours(20), "F", 452 }); return(ds); }
private Stream ExecuteMerge(string templateName, DocumentFormat documentFormat) { Stream result = new MemoryStream(); MailMergeOptions mailMergeOptions = documentServer.CreateMailMergeOptions(); if (templateName == "preview1") { documentServer.LoadDocument(Page.MapPath("~/App_Data/InvoicesDetail.rtf")); List <Invoice> invoices = new List <Invoice>(10); invoices.Add(new Invoice(0, "Invoice1", 10.0m)); invoices.Add(new Invoice(1, "Invoice2", 15.0m)); invoices.Add(new Invoice(2, "Invoice3", 20.0m)); mailMergeOptions.DataSource = invoices; } else if (templateName == "preview2") { documentServer.LoadDocument(Page.MapPath("~/App_Data/SamplesDetail.rtf")); mailMergeOptions.DataSource = ManualDataSet.CreateData().Tables[0]; } else if (templateName == "all") { Stream part1 = ExecuteMerge("preview1", documentFormat); Stream part2 = ExecuteMerge("preview2", documentFormat); part1.Seek(0, SeekOrigin.Begin); part2.Seek(0, SeekOrigin.Begin); documentServer.LoadDocument(part1, documentFormat); documentServer.Document.AppendDocumentContent(part2, documentFormat); documentServer.SaveDocument(result, documentFormat); return(result); } documentServer.Options.MailMerge.ViewMergedData = true; documentServer.Options.Export.Html.EmbedImages = true; mailMergeOptions.MergeMode = MergeMode.JoinTables; documentServer.MailMerge(mailMergeOptions, result, documentFormat); return(result); }
protected void WebChartControl1_CustomCallback(object sender, DevExpress.XtraCharts.Web.CustomCallbackEventArgs e) { string[] parameters = e.Parameter.Split(';'); DateTime originalArgument = Convert.ToDateTime(hfOriginalArgument.Value, CultureInfo.InvariantCulture); DateTime argument = Convert.ToDateTime(parameters[0], CultureInfo.InvariantCulture); double value = Convert.ToDouble(parameters[1]); DataTable table = ManualDataSet.RetrieveDataCache().Tables[0]; for (int i = 0; i < table.Rows.Count; i++) { if (Convert.ToDateTime(table.Rows[i]["MyDateTime"]) == originalArgument) { table.Rows[i]["MyDateTime"] = argument; table.Rows[i]["MyData"] = value; break; } } }
protected void Page_Load(object sender, EventArgs e) { ASPxPivotGrid1.DataSource = ManualDataSet.CreateData().Tables[0]; ASPxPivotGrid1.DataBind(); if (!IsPostBack) { Session["selectedRowIndex"] = 0; Session["selectedColIndex"] = 0; ASPxPivotGrid1.RetrieveFields(); ASPxPivotGrid1.Fields["MyData"].Area = DevExpress.XtraPivotGrid.PivotArea.DataArea; ASPxPivotGrid1.Fields["MyRow"].Area = DevExpress.XtraPivotGrid.PivotArea.RowArea; ASPxPivotGrid1.Fields["MyDateTime"].Area = DevExpress.XtraPivotGrid.PivotArea.ColumnArea; ASPxPivotGrid1.Fields["MyDateTime"].ValueFormat.FormatType = DevExpress.Utils.FormatType.DateTime; ASPxPivotGrid1.Fields["MyDateTime"].ValueFormat.FormatString = "d"; ((XYDiagram)WebChartControl1.Diagram).AxisX.DateTimeOptions.Format = DateTimeFormat.ShortDate; } PrepareChartData(); FillChart(); }
private DataSet GetSimpleChartDataCache() { if(Session["chartData"] == null) Session["chartData"] = ManualDataSet.CreateData(); return (DataSet)Session["chartData"]; }