protected void Page_Load(object sender, EventArgs e)
{
//Please modify the connection string in web.config and choose the correct path of .mdb file.
//Step 1: Choose one appearance style from enum FanG.Chartlet.AppearanceStyles
Chartlet1.AppearanceStyle = FanG.Chartlet.AppearanceStyles.Bar_2D_StarryNight_FlatCrystal_Glow_TextureBorder;
//Alternative steps
//If you want to use other colors, decomments the statement below, and you can use different value (0 ~ 12)
//Chartlet1.FillShiftStep = 8;
//You can still setting other attributes here.
//Step 2: Bind a data source
Chartlet1.BindChartData(SqlDataSource1);
//OK, run your web form, a beautiful chart appears, does it?
//So simple Chartlet is.
//More info on http://www.Chartlet.cn
//========================================================//
Chartlet2.AppearanceStyle = FanG.Chartlet.AppearanceStyles.Line_2D_StarryNight_ThickRound_Glow_NoBorder;
Chartlet2.ChartTitle.Text = "Line Chart";
//You adjust some attributes based on AppearanceStyle selected
//Chartlet2.LineWidth = 2;
Chartlet2.MaxValueY = 1000;
Chartlet2.BindChartData(SqlDataSource1);
Chartlet3.AppearanceStyle = FanG.Chartlet.AppearanceStyles.Line_3D_StarryNight_FlatCrystalRound_NoGlow_NoBorder;
Chartlet3.Fill.ShiftStep = 7;
Chartlet3.ChartTitle.Text = "Pie Chart";
Chartlet3.BindChartData(SqlDataSource1);
Chartlet4.AppearanceStyle = FanG.Chartlet.AppearanceStyles.Pie_3D_Aurora_NoCrystal_NoGlow_NoBorder;
Chartlet4.Fill.ShiftStep = 9;
Chartlet4.ChartTitle.Text = "3D Pie Chart";
Chartlet4.BindChartData(SqlDataSource1);
}
protected void Page_Load(object sender, EventArgs e)
{
Label1.Text = Chartlet1.GetVersion();;
//Modify the conneciton string in web.config, so that program can find the database file.
//修改web.config里面的连接字符串，使之能够找到数据库文件
cs += Server.MapPath("App_Data/Chartlet.mdb");
SqlDataSource1.ConnectionString = cs;
//=====================================================================================================
//1. Bind data for first Chart, it's so easy.
//Note: If you have some Error in database connection, pelase modify connection string in web.config
//1.下面为第一个图表加载数据，使用BindChartData()方法,超级简单！
//注：数据库在App_Data/Chartlet.mdb,如果你运行时无法连接，可能需要修改web.config里面的连接字符串
//设置2个显示属性
//Attributes setting
Chartlet1.ChartTitle.Text = "Sales Accomplishment";
Chartlet1.YLabels.UnitText = "Million";
//绑定数据就是这么简单,直接一句话搞定
//You see, so easy! only 1 statement can bind all the data.
Chartlet1.BindChartData(SqlDataSource1);
//=====================================================================================================
//2. Bind data for 2nd Chart.
//2.为图表二添加后台数据(使用InitalizeData()方法）*/
//构造数据数组ArrayList[]
/*注： 这里构造数据数组时，是直接手填的，当然你在实际应用中应该是从数据库读出数据再构建这个数组*/
ArrayList ChartD21 = new ArrayList();
ChartD21.Add(53); ChartD21.Add(85); ChartD21.Add(60);
ChartD21.Add(40); ChartD21.Add(45); ChartD21.Add(53);
ChartD21.Add(60); ChartD21.Add(90); ChartD21.Add(76);
ChartD21.Add(57); ChartD21.Add(60); ChartD21.Add(53);
//只有一组数据的 ArrayList[]
ArrayList[] ChartData2 = { ChartD21 };
//将数据数组传入InitializeData()方法，后两个参数数据使用默认值
Chartlet2.InitializeData(ChartData2, null, null);
//======================================================================================================
//3. Bind data for 3rd chart and 4th chart.
// 3.为第三，四个图表加载数据，使用InitializeData()方法
//颜色图例数组
ArrayList ColorGuider = new ArrayList();
ColorGuider.Add("Laura");
ColorGuider.Add("Jesy");
ColorGuider.Add("Linda");
//X坐标轴标识数组
//Labels on X Axis
ArrayList XTitle = new ArrayList();
XTitle.Add("East");
XTitle.Add("South");
XTitle.Add("West");
XTitle.Add("North");
//图表数据（3组）
//Chart data (3 Groups)
ArrayList[] ChartData = new ArrayList[3];
ChartData[0] = new ArrayList();
ChartData[0].Add(170);
ChartData[0].Add(85);
ChartData[0].Add(5287);
ChartData[0].Add(910);
ChartData[0].Add(9);
ChartData[0].Add(3);
ChartData[1] = new ArrayList();
ChartData[1].Add(76);
ChartData[1].Add(68);
ChartData[1].Add(43);
ChartData[1].Add(99);
ChartData[2] = new ArrayList();
ChartData[2].Add(10);
ChartData[2].Add(77);
ChartData[2].Add(15);
ChartData[2].Add(79);
//图表数据（3组）
Chartlet3.AppearanceStyle = FanG.Chartlet.AppearanceStyles.Pie_3D_Aurora_NoCrystal_NoGlow_NoBorder;
Chartlet3.Fill.ShiftStep = 8;
Chartlet3.InitializeData(ChartData, XTitle, ColorGuider);
Chartlet4.InitializeData(ChartData, XTitle, ColorGuider);
//======================================================================================================
Label2.Text = Chartlet1.GetVersionDetail();
}
protected void Page_Load(object sender, EventArgs e)
{
string cs = WebConfigurationManager.ConnectionStrings["Chartlet"].ConnectionString + Server.MapPath("App_data\\Chartlet.mdb");
string sql = "Select Season,Sales,Profit,Cost,(Sales-Profit-Cost) as S1 from Sales where user='******' order by Profit DESC";
OleDbConnection cn = new OleDbConnection(cs);
OleDbDataAdapter da = new OleDbDataAdapter(sql, cn);
DataSet ds = new DataSet();
da.Fill(ds, "Jesy");
string sql2 = "select DTime,Sales,Cost from Sales order by Dtime ASC";
DataSet ds2 = new DataSet();
da = new OleDbDataAdapter(sql2, cn);
da.Fill(ds2, "Jesy");
/*选择外观基调*/
Chartlet1.AppearanceStyle = FanG.Chartlet.AppearanceStyles.Trend_2D_Aurora_ThinRound_Glow_NoBorder;
//调整折线连接点的大小
Chartlet1.LineConnectionRadius = 6;
//调整折线宽度
Chartlet1.Stroke.Width = 2;
//关闭投影效果
Chartlet1.Shadow.Enable = false;
//通过下面一句调整标题的高度
Chartlet1.ChartTitle.OffsetY = -10;
//下面一句是TrendChart必须要有的，是TrendChart中最重要的设置(StartTime,EndTime,TimeSpanType,XLabelDisplayFormat)
//如果你使用TrendChart，但是缺少了这一句，那么系统会提示：Please Set Chartlet.Trend attribute for Trend Chart
//详细介绍请参看Chartlet.Trend的参考手册
Chartlet1.Trend = new FanG.TrendAttributes("2009-04-29", "2009-5-11", FanG.Chartlet.TimeSpanTypes.Day, "MM-dd");
//图表标题
Chartlet1.ChartTitle.Text = "TrendChart(趋势图)";
//绑定数据
Chartlet1.BindChartData(ds2);
/******************************/
Chartlet2.AppearanceStyle = FanG.Chartlet.AppearanceStyles.Bar_2D_Aurora_FlatCrystal_NoGlow_NoBorder;
Chartlet2.ColorGuider.Font = new Font("Arial", 9, FontStyle.Italic);
Chartlet2.ColorGuider.ForeColor = Color.Green;
Chartlet2.ChartTitle.ForeColor = Color.Green;
Chartlet2.XLabels.ForeColor = Color.Green;
Chartlet2.YLabels.ForeColor = Color.Green;
Chartlet2.Tips.ForeColor = Color.Green;
Chartlet2.ChartTitle.Text = "BaseLine Attribute(基准线属性)";
Chartlet2.YLabels.ValueFormat = "0.";
//线面设置baseline属性，会产生一条基准线，基准线一下的数据会导致柱子负向增长
Chartlet2.BaseLineX = 360;
Chartlet2.BindChartData(ds);
/*****************************/
Chartlet3.AppearanceStyle = FanG.Chartlet.AppearanceStyles.Line_2D_StarryNight_ThickRound_Glow_NoBorder;
Chartlet3.Tips.Font = new Font("Verdana", 6, FontStyle.Regular);
Chartlet3.Tips.ForeColor = Color.Purple;
Chartlet3.ChartTitle.Font = new Font("Verdana", 12, FontStyle.Regular);
Chartlet3.YLabels.Font = new Font("Arial", 6);
Chartlet3.YLabels.UnitFont = new Font("Arial", 6);
Chartlet3.XLabels.Font = new Font("Arial", 11);
Chartlet3.XLabels.UnitFont = new Font("Arial", 6);
Chartlet3.XLabels.RotateAngle = 0;
Chartlet3.ChartTitle.Text = "自定义颜色、X坐标文字、ColorGuider文字";
Chartlet3.BaseLineX = 492;
//使用自定义颜色数组
//先定义一个自己的颜色数组
Color[] myColorA = { Color.Black, Color.Blue, Color.Green };
//在把它复制到你使用的Chartlet颜色数组中，如StarryNight
myColorA.CopyTo(Chartlet3.StarryNight, 0);
//折线连接符的大小
Chartlet3.LineConnectionRadius = 8;
Chartlet3.Stroke.Width = 3;
Chartlet3.BindChartData(ds);
//自定义ColorGuider的文字,必须放在BindChartData()后面
Chartlet3.GroupTitle = new string[] { "CG1", "CG2", "CG3", "CG4", "CG5" };
//自定义X坐标文字，必须放在BindChartData()后面
Chartlet3.AxisX = new string[] { "x1", "x2", "x3", "x4", "x5" };
/****************************/
Chartlet4.AppearanceStyle = FanG.Chartlet.AppearanceStyles.HBar_2D_Aurora_FlatCrystal_Glow_NoBorder;
Chartlet4.XLabels.RotateAngle = 0;
Chartlet4.ChartTitle.Text = "HBar-Pareto (横向柱图-柏拉图)";
Chartlet4.Fill.TextureEnable = true;
Chartlet4.BindChartData(ds);
}
protected void Page_Load(object sender, EventArgs e)
{
//请先修改Web.Config里面的数据库连接字符串的.mdb文件的路径
/***********************************************************/
//第一步：设置一个属性（只需要从枚举类型中选取就可以了）
Chartlet1.AppearanceStyle = FanG.Chartlet.AppearanceStyles.Bar_2D_Aurora_FlatCrystal_Glow_NoBorder;
//可选步骤
//如果你要改变颜色，请取消下面一行的注释，并可以修改参数的值 0 ～ 12 (预置了12种典型颜色)
Chartlet1.Fill.ShiftStep = 8;
Chartlet1.Crystal.Contraction = 0;
Chartlet1.Shadow.Distance = 2;
Chartlet1.Shadow.Alpha = 200;
//第二步：绑定一个数据源
Chartlet1.BindChartData(SqlDataSource1);
//好了，运行一下看看，是不是一个很美丽的图表出现了？
//Chartlet就这么简单
//更多信息请参看 http://www.Chartlet.cn
/*☆☆☆☆☆☆☆☆☆☆☆☆☆☆☆☆☆☆☆☆☆☆☆☆
* ☆ BindChartData()方法有四个构造函数，支持常见的四种数据源(DataSet,DataTable,DataView,SqlDataSource)
* ☆ BindChartData(DataSet DataSource)
* ☆ BindChartData(DataTable DataSource)
* ☆ BindChartData(DataView DataSource)
* ☆ BindChartData(SqlDataSource DataSource)
* ☆☆☆☆☆☆☆☆☆☆☆☆☆☆☆☆☆☆☆☆☆☆☆☆*/
/**********************************************************/
//========================================================//
Chartlet2.AppearanceStyle = FanG.Chartlet.AppearanceStyles.Line_2D_StarryNight_ThickRound_Glow_NoBorder;
Chartlet2.ChartTitle.Text = "2D Line Chart";
//在选择了AppearanceType的基础上进行微调
//Chartlet2.LineWidth = 2;
Chartlet2.MaxValueY = 1000;
Chartlet2.BindChartData(SqlDataSource1);
Chartlet3.AppearanceStyle = FanG.Chartlet.AppearanceStyles.Line_3D_Aurora_FlatCrystalRound_NoGlow_NoBorder;
/*************在选择了AppearanceType的基础上进行微调****************/
Chartlet3.Fill.ShiftStep = 7;
Chartlet3.LineConnectionRadius = 8;
//对于折线的颜色控制都使用StrokeColor属性（包括3D折线图）
Chartlet3.Stroke.ShiftStep = 8;
Chartlet3.Alpha3D = 200;
Chartlet2.Tips.Show = false;
//你可以取消注释下面一句，看看另一种效果
//Chartlet3.Crystal.Direction = FanG.Chartlet.Direction.BottomTop;
//************上面代码是在AppearanceType的基础上进行微调***********/
Chartlet3.ChartTitle.Text = "3D Line Chart";
Chartlet3.BindChartData(SqlDataSource1);
Chartlet4.AppearanceStyle = FanG.Chartlet.AppearanceStyles.Pie_3D_Aurora_NoCrystal_NoGlow_NoBorder;
Chartlet4.Fill.ShiftStep = 9;
Chartlet4.ChartTitle.Text = "3D Pie Chart";
Chartlet4.BindChartData(SqlDataSource1);
}
