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