private void ImageToPdf(Document myDocument, out System.IO.MemoryStream stream, out iTextSharp.text.Image gif, int chart) { stream = new System.IO.MemoryStream(); switch (chart) { case 1: Chart1.SaveImage(stream, System.Drawing.Imaging.ImageFormat.Jpeg); break; case 2: Chart2.SaveImage(stream, System.Drawing.Imaging.ImageFormat.Jpeg); break; case 3: Chart3.SaveImage(stream, System.Drawing.Imaging.ImageFormat.Jpeg); break; case 4: Chart4.SaveImage(stream, System.Drawing.Imaging.ImageFormat.Jpeg); break; case 5: Chart5.SaveImage(stream, System.Drawing.Imaging.ImageFormat.Jpeg); break; } Chart1.SaveImage(stream, System.Drawing.Imaging.ImageFormat.Jpeg); gif = iTextSharp.text.Image.GetInstance(stream.ToArray()); gif.Alignment = Element.ALIGN_CENTER; //gif.ScaleAbsolute(10, 10); }
private void loadChart5() { string queryString = (@"SELECT * FROM ( SELECT[pitchno], [pitcher], [pitchtype] FROM[dbo].[pitchData] WHERE pitchcall = 'StrikeCalled' ) AS SourceTable PIVOT(COUNT([pitchno]) FOR [pitchtype] IN([Splitter], [Fastball], [Sinker], [ChangeUp], [Cutter], [Curveball], [Slider])) AS PivotTable;" ); DataTable ChartData5 = new DataTable(); using (SqlConnection connection = new SqlConnection(connectionString)) { connection.Open(); using (SqlDataAdapter sqlQueryAdapter = new SqlDataAdapter(queryString, connection)) { sqlQueryAdapter.SelectCommand.CommandTimeout = 120; DataSet dataSet = new DataSet(); sqlQueryAdapter.Fill(dataSet); connection.Close(); ChartData5 = dataSet.Tables[0]; } } DataView dv = new DataView(ChartData5); Chart5.DataSource = dv; Chart5.DataBind(); foreach (Series cs in Chart5.Series) { Debug.WriteLine(cs.Name); cs.ChartType = SeriesChartType.StackedColumn; } //Setting width of line Chart5.Series[0].BorderWidth = 10; }
private void LoadChartData4() { Chart5.ChartAreas[0].AxisX.MajorGrid.Enabled = false; Chart5.ChartAreas[0].AxisY.MajorGrid.Enabled = false; string query = "SELECT comment_type,Ccount from tbl_cat_wise_comment "; SqlDataAdapter da = new SqlDataAdapter(query, con); DataTable table = new DataTable(); da.Fill(table); DataView dv = table.DefaultView; Chart5.DataBind(); Chart5.Series["Series1"].Points.DataBindXY(dv, "comment_type", dv, "Ccount"); getdata1(); }
protected void DropDownList5_SelectedIndexChanged(object sender, EventArgs e) { if (!DropDownList3.SelectedValue.Equals("-1") && !DropDownList4.SelectedValue.Equals("-1") && !DropDownList5.SelectedValue.Equals("-1")) { GridView7.Visible = true; Chart5.Visible = true; GridView7.DataBind(); Chart5.DataBind(); Label8.Text = DropDownList3.SelectedItem.Text + " " + DropDownList5.SelectedItem.Text + " Result Summary"; if (GridView7.Rows.Count == 0) { Label8.Text = "No Results"; } } else { Label8.Visible = false; GridView7.Visible = false; Chart5.Visible = false; } }
private void View6_DataBind() { Label31.Text = DropDownList13.SelectedItem.Text; Label32.Text = DropDownList14.SelectedItem.Text; Label30.Text = DropDownList12.SelectedItem.Text + ": " + DropDownList13.SelectedItem.Text + " Vs " + DropDownList14.SelectedItem.Text; GridView8.DataSource = SqlDataSource16; GridView8.DataBind(); GridView9.DataBind(); GridView9.Visible = true; Chart5.DataSource = SqlDataSource16; Chart5.DataBind(); if (Chart5.Series[0].Points.Count > 0 || Chart5.Series[1].Points.Count > 0) { Label31.Text = DropDownList13.SelectedItem.Text; Label32.Text = DropDownList14.SelectedItem.Text; Label31.Visible = true; Label32.Visible = true; } Chart5.Visible = true; }
protected void DropDownList3_SelectedIndexChanged(object sender, EventArgs e) { //chart 5 string pitchcall = DropDownList3.SelectedValue.ToString(); Debug.WriteLine(pitchcall); string queryString = (@"SELECT * FROM ( SELECT[pitchno], [pitcher], [pitchtype] FROM[dbo].[pitchData] WHERE pitchcall = @pitchcall ) AS SourceTable PIVOT(COUNT([pitchno]) FOR [pitchtype] IN([Splitter], [Fastball], [Sinker], [ChangeUp], [Cutter], [Curveball], [Slider])) AS PivotTable;" ); DataTable ChartData5 = new DataTable(); using (SqlConnection connection = new SqlConnection(connectionString)) { connection.Open(); using (SqlDataAdapter sqlQueryAdapter = new SqlDataAdapter(queryString, connection)) { sqlQueryAdapter.SelectCommand.Parameters.AddWithValue("@pitchcall", pitchcall); sqlQueryAdapter.SelectCommand.CommandTimeout = 120; DataSet dataSet = new DataSet(); sqlQueryAdapter.Fill(dataSet); connection.Close(); ChartData5 = dataSet.Tables[0]; } } DataView dv = new DataView(ChartData5); Chart5.DataSource = dv; Chart5.DataBind(); foreach (Series cs in Chart5.Series) { cs.Enabled = false; Debug.WriteLine(cs.Name); cs.ChartType = SeriesChartType.StackedColumn; foreach (DataPoint point in cs.Points) { Debug.WriteLine("pitcher: " + (double)point.YValues.GetValue(0)); if ((double)point.YValues.GetValue(0) != 0) { Debug.WriteLine("not empty"); cs.Enabled = true; } } } //Setting width of line Chart5.Series[0].BorderWidth = 10; }