private void loadChart6() { //chart 6 string queryString = (@"SELECT * FROM ( SELECT[spinrate], [pitcher], [pitchtype] FROM[dbo].[pitchData] --WHERE spinrate >= 2416.54 ) AS SourceTable PIVOT(avg([spinrate]) FOR[pitchtype] IN([Splitter], [Fastball], [Sinker], [ChangeUp], [Cutter], [Curveball], [Slider])) AS PivotTable ORDER BY pitcher ASC;" ); DataTable ChartData6 = SqlQueryExecute(queryString); DataView dv = new DataView(ChartData6); Chart6.DataSource = dv; Chart6.DataBind(); foreach (Series cs in Chart6.Series) { cs.Enabled = false; Debug.WriteLine(cs.Name); cs.ChartType = SeriesChartType.Point; foreach (DataPoint point in cs.Points) { if ((double)point.YValues.GetValue(0) != 0) { Debug.WriteLine("not empty"); cs.Enabled = true; } } } //Setting width of line Chart6.Series[0].BorderWidth = 10; }
private void View5_dataBind() { GridView7.DataSource = SqlDataSource20; GridView6.DataSource = SqlDataSource19; GridView6.DataBind(); GridView7.DataBind(); Chart6.DataSource = SqlDataSource19; Chart6.DataBind(); Chart6.Visible = true; if (Chart6.Series[0].Points.Count > 0 || Chart6.Series[1].Points.Count > 0) { Label21.Visible = true; Label22.Visible = true; // Label19.Text = DropDownList9.SelectedValue + " Vs Me " + DropDownList8.SelectedItem.Text + " results"; } Label22.Text = DropDownList9.SelectedItem.Text; Label20.Text = DropDownList8.SelectedItem.Text + " " + DropDownList9.SelectedItem.Text + " Vs ME"; }