ASP.NET Web Pages - Chart °ïÖúÆ÷

Chart - ÖÚ¶àÓÐÓÃµÄ ASP.NET Web °ïÖúÆ÷Ö®Ò»¡£

Chart Helper

ÔÚǰһÕ£¬ÄúÒѾ­Ñ§µ½ÁËÈçºÎʹÓÃÒ»¸ö ASP.NET ¡°°ïÖúÆ÷¡±¡£

ÄúÒÑѧµ½ÈçºÎʹÓà ¡°WebGrid °ïÖúÆ÷¡±ÔÚÍø¸ñÖÐÏÔʾÊý¾Ý¡£

±¾Õ½²½âÈçºÎÔÚͼ±íÖÐÏÔʾÊý¾Ý£¬Í¨¹ýʹÓà ¡°Chart °ïÖúÆ÷¡±¡£

¡°Chart °ïÖúÆ÷¡±Äܹ»Í¨¹ý¶àÖÖ¸ñʽºÍ±ê¼Ç´´½¨²»Í¬ÀàÐ͵Äͼ±íͼƬ¡£ËüÄܹ»´´½¨±ê׼ͼ±í£¬±ÈÈçÃæ»ýͼ¡¢Ìõ״ͼ¡¢ÖùÐÎͼ¡¢ÏßͼºÍ±ýͼ£¬ÒÔ¼°¸üרҵµÄͼ±í£¨±ÈÈç¹ÉƱ×ßÊÆÍ¼£©¡£

ÏÔʾÔÚͼ±íÖеÄÊý¾Ý¿ÉÒÔÊÇÀ´×ÔÊý×é¡¢Êý¾Ý¿â»òÎļþÖеÄÊý¾Ý¡£

À´×ÔÊý×éµÄͼ±í

ÏÂÀýչʾµÄ´úÂëʹÓÃÀ´×ÔÊý×éµÄÊý¾ÝÏÔʾͼ±í£º

ʵÀý

@{ 
var myChart = new Chart(width: 600, height: 400) 
   .AddTitle("Employees") 
   .AddSeries(chartType: "column",
      xValue: new[] {  "Peter", "Andrew", "Julie", "Mary", "Dave" }, 
      yValues: new[] { "2", "6", "4", "5", "3" }) 
   .Write();
}

ÔËÐÐʵÀý

new Chart ´´½¨ÐµÄͼ±í¶ÔÏ󣬲¢ÉèÖÃÆä¿í¶ÈºÍ¸ß¶È¡£

AddTitle ·½·¨¹æ¶¨Í¼±íµÄ±êÌâ¡£

AddSeries ·½·¨Ïòͼ±íÌí¼ÓÊý¾Ý¡£

chartType ²ÎÊý¶¨Òåͼ±íµÄÀàÐÍ¡£

xValue ²ÎÊý¶¨Òå x ÖáµÄÖµ¡£

yValues ²ÎÊý¶¨Òå y ÖáµÄÖµ¡£

Write() ·½·¨ÏÔʾͼ±í¡£

À´×ÔÊý¾Ý¿âµÄͼ±í

Äú¿ÉÒÔÊ×ÏÈÔËÐÐÒ»´ÎÊý¾Ý¿â²éѯ£¬È»ºóʹÓýá¹ûÖеÄÊý¾ÝÀ´´´½¨Í¼±í£º

ʵÀý

@{ 
var db = Database.Open("SmallBakery"); 
var dbdata = db.Query("SELECT Name, Price FROM Product"); 
var myChart = new Chart(width: 600, height: 400) 
   .AddTitle("Product Sales") 
   .DataBindTable(dataSource: dbdata, xField: "Name")
   .Write();
}

ÔËÐÐʵÀý

var db = Database.Open ´ò¿ªÊý¾Ý¿â£¨²¢°ÑÊý¾Ý¿â¶ÔÏ󸳸ø±äÁ¿ db£©¡£

var dbdata = db.Query ÔËÐÐÊý¾Ý¿â²éѯ£¬²¢°Ñ½á¹û±£´æµ½ dbdata ÖС£

new Chart ´´½¨ÐµÄͼ±í¶ÔÏ󣬲¢ÉèÖÃÆä¿í¶ÈºÍ¸ß¶È¡£

AddTitle ·½·¨¹æ¶¨Í¼±íµÄ±êÌâ¡£

DataBindTable ·½·¨½«Êý¾ÝÔ´°ó¶¨µ½Í¼±í¡£

Write() ·½·¨ÏÔʾͼ±í¡£

ʹÓà DataBindTable ·½·¨µÄÌæ´ú·½°¸ÊÇʹÓà AddSeries£¨²Î¼ûǰһ¸öÀý×Ó£©¡£DataBindTable ¸üÒ×ʹÓ㬵«ÊÇ AddSeries µÄÉìËõÐÔ¸üÇ¿£¬ÒòΪËüÄܹ»¸ü¾«È·µØ¹æ¶¨Í¼±íºÍÊý¾Ý£º

ʵÀý

@{ 
var db = Database.Open("SmallBakery"); 
var dbdata = db.Query("SELECT Name, Price FROM Product"); 
var myChart = new Chart(width: 600, height: 400) 
   .AddTitle("Product Sales") 
   .AddSeries(chartType:"Pie",
      xValue: dbdata, xField: "Name",
      yValues: dbdata, yFields: "Price")
   .Write();
}

ÔËÐÐʵÀý

À´×Ô XML Êý¾ÝµÄͼ±í

Éú³Éͼ±íµÄµÚÈý¸öÑ¡ÏîÊÇʹÓà XML Îļþ×÷Ϊͼ±íµÄÊý¾Ý£º

ʵÀý

@using System.Data;

@{
var dataSet = new DataSet();
dataSet.ReadXmlSchema(Server.MapPath("data.xsd"));
dataSet.ReadXml(Server.MapPath("data.xml"));
var dataView = new DataView(dataSet.Tables[0]);
var myChart = new Chart(width: 600, height: 400)
   .AddTitle("Sales Per Employee")
   .AddSeries("Default", chartType: "Pie",
      xValue: dataView, xField: "Name",
      yValues: dataView, yFields: "Sales")
   .Write();}
}

ÔËÐÐʵÀý

VUE