如何在没有webservices的情况下使用highchart来创建图表 [英] How to craete chart using highchart without webservices
本文介绍了如何在没有webservices的情况下使用highchart来创建图表的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我想创建饼图,从sqlserver数据库绑定记录。我必须在c#编码而不添加webservices方法。
我尝试过什么:
已经使用webservies完成
I want to create pie chart,binding records from sqlserver database.I have to in c# coding without adding webservices method.
What I have tried:
Already done using webservies
<pre lang="c#"> }
[WebMethod]
public List<FruitEnity> FruitAnalysis()
{
List<FruitEnity> fruitinfo = new List<FruitEnity>();
DataSet ds = new DataSet();
using (SqlConnection con = new SqlConnection("Data Source=XXXX;User Id=XXXX;
Password=XXXX;DataBase=XXXX"))
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.CommandText = "select name,value from tbl_fruitanalysis";
cmd.Connection = con;
using (SqlDataAdapter da = new SqlDataAdapter(cmd))
{
da.Fill(ds, "FruitAnalysis");
}
}
}
if (ds != null)
{
if (ds.Tables.Count > 0)
{
if (ds.Tables["FruitAnalysis"].Rows.Count > 0)
{
foreach (DataRow dr in ds.Tables["FruitAnalysis"].Rows)
{
fruitinfo.Add(new FruitEnity { Name = dr["name"].ToString(),
Value = Convert.ToInt32(dr["value"]) });
}
}
}
}
return fruitinfo;
}
推荐答案
对于SQL Server
示例,请参阅: C#中的HighCharts数据绑定 [ ^ ]
这是一个纯HTML示例:
For anSQL Server
example, see: HighCharts databinding in C#[^]
Here is a pure HTML example:
DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
<html>
<head>
<title>Bar Chart</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<script src="http://code.jquery.com/jquery-1.9.1.js" type="text/javascript"></script>
<script src="http://code.highcharts.com/highcharts.js" type="text/javascript"></script>
<script src="http://code.highcharts.com/modules/exporting.js" type="text/javascript"></script>
<script type="text/javascript">
(function(){
(function() {
('# container')。highcharts({
chart:{
type:'bar'
},
title:{
text:'MyFruit database info'
},
xAxis:{
类别:['记录','碎片','用户']
},
yAxis:{
title:{
text:'values'
}
},
series:[
{
name:'MyFruit_Sites',
data:[10, 50,4]
},{
名称:'MyFruit_Devices',
数据:[50 0,80,3]
}
]
});
//按钮处理程序
('#container').highcharts({ chart: { type: 'bar' }, title: { text: 'MyFruit database info' }, xAxis: { categories: ['Records', 'Fragmentation', 'Users'] }, yAxis: { title: { text: 'Values' } }, series: [ { name: 'MyFruit_Sites', data: [10, 50, 4] }, { name: 'MyFruit_Devices', data: [500, 80, 3] } ] }); // the button handler
这篇关于如何在没有webservices的情况下使用highchart来创建图表的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文