public void Bindchart1()
{
DataSet ds = new DataSet();
string username = Convert.ToString(Session["username"]);
ds = obj.BuySharesStatistics(username);
DataTable ChartData = ds.Tables[0];
//storing total rows count to loop on each Record
string[] XPointMember = new string[ChartData.Rows.Count];
int[] YPointMember = new int[ChartData.Rows.Count];
for (int count = 0; count < ChartData.Rows.Count; count++)
{
//storing Values for X axis
XPointMember[count] = ChartData.Rows[count]["symbol"].ToString();
//storing values for Y Axis
YPointMember[count] = Convert.ToInt32(ChartData.Rows[count]["quantity"]);
}
//binding chart control
Chart1.Series[0].Points.DataBindXY(XPointMember, YPointMember);
//Setting width of line
Chart1.Series[0].BorderWidth = 10;
//setting Chart type
Chart1.Series[0].ChartType = SeriesChartType.Pie;
foreach (Series charts in Chart1.Series)
{
foreach (DataPoint point in charts.Points)
{
switch (point.AxisLabel)
{
case "AAPL": point.Color = Color.RoyalBlue; break;
case "ACH": point.Color = Color.SaddleBrown; break;
case "BAB": point.Color = Color.SpringGreen; break;
case "DAL": point.Color = Color.AliceBlue; break;
case "DWSN": point.Color = Color.Aqua; break;
case "EXPE": point.Color = Color.Beige; break;
case "FCF": point.Color = Color.Bisque; break;
case "GYRO": point.Color = Color.BlanchedAlmond; break;
case "HFWA": point.Color = Color.BlueViolet; break;
case "INFY": point.Color = Color.Brown; break;
case "LAKE": point.Color = Color.BurlyWood; break;
case "NATI": point.Color = Color.CadetBlue; break;
case "OFC": point.Color = Color.Chocolate; break;
case "PCTY": point.Color = Color.Cornsilk; break;
case "SAND": point.Color = Color.DarkGoldenrod; break;
case "VTA": point.Color = Color.DarkKhaki; break;
case "WPPGY": point.Color = Color.DarkOrchid; break;
case "XLY": point.Color = Color.DeepPink; break;
case "YHOO": point.Color = Color.DarkOrchid; break;
case "YUM": point.Color = Color.DeepPink; break;
}
point.Label = string.Format("{0:0} - {1}", point.YValues[0], point.AxisLabel);
}
}
//Enabled 3D
Chart1.ChartAreas["ChartArea1"].Area3DStyle.Enable3D = true;
Chart1.Visible = true;
Chart2.Visible = false;
Chart3.Visible = false;
}
