在网上找到一个例子。但是怎么跟数据库结合起来呢。如下
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Test.aspx.cs" Inherits="_Default" Debug="true" %><%@ Register assembly="Chartlet" namespace="FanG" tagprefix="cc1" %><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title>Chartlet Demo</title>
</head>
<body style="font-size:15pt; font-family:Arial;">
<form id="form1" runat="server">
<asp:Label ID="Label1" runat="server" Text="Label"></asp:Label>
<br />
<div>
<cc1:Chartlet ID="Chartlet2" runat="server" MaxValueY="100" GroupSize="1" Shadow-Distance="5" Shadow-Radius="8"
ChartType="Line" LineConnectionRadius="18" LineConnectionType="Round" LineWidth="4"/>
</div>
</form>
</body>
</html>后台代码:using System;
using System.Collections;
using System.Collections.Generic;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.Configuration;public partial class _Default : System.Web.UI.Page
{ string cs = WebConfigurationManager.ConnectionStrings["Chartlet"].ConnectionString;
protected void Page_Load(object sender, EventArgs e)
{
cs +=Server.MapPath("DB_51aspx/Chartlet.mdb")
SqlDataSource1.ConnectionString=cs; 、、
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(53);
ChartData[0].Add(40);
ChartData[0].Add(60);
ChartData[0].Add(57); 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组)
}
}如图红色部分,我不想用SqlDataSource1.ConnectionString的方式,想用dataset填充,如下
private System.Data.DataSet GetDSBySale()
{
SqlConnection con = new SqlConnection(ConfigurationSettings.AppSettings[0]);
con.Open();
string cmdStr = " SELECT top 100 createtime," + strData + " FROM Receive order by CreateTime desc ";
SqlDataAdapter da = new SqlDataAdapter(cmdStr, con);
System.Data.DataSet ds = new System.Data.DataSet();
da.Fill(ds, "Receive");
return ds;
}应该怎样转换,谢谢,在线等。
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Test.aspx.cs" Inherits="_Default" Debug="true" %><%@ Register assembly="Chartlet" namespace="FanG" tagprefix="cc1" %><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title>Chartlet Demo</title>
</head>
<body style="font-size:15pt; font-family:Arial;">
<form id="form1" runat="server">
<asp:Label ID="Label1" runat="server" Text="Label"></asp:Label>
<br />
<div>
<cc1:Chartlet ID="Chartlet2" runat="server" MaxValueY="100" GroupSize="1" Shadow-Distance="5" Shadow-Radius="8"
ChartType="Line" LineConnectionRadius="18" LineConnectionType="Round" LineWidth="4"/>
</div>
</form>
</body>
</html>后台代码:using System;
using System.Collections;
using System.Collections.Generic;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.Configuration;public partial class _Default : System.Web.UI.Page
{ string cs = WebConfigurationManager.ConnectionStrings["Chartlet"].ConnectionString;
protected void Page_Load(object sender, EventArgs e)
{
cs +=Server.MapPath("DB_51aspx/Chartlet.mdb")
SqlDataSource1.ConnectionString=cs; 、、
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(53);
ChartData[0].Add(40);
ChartData[0].Add(60);
ChartData[0].Add(57); 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组)
}
}如图红色部分,我不想用SqlDataSource1.ConnectionString的方式,想用dataset填充,如下
private System.Data.DataSet GetDSBySale()
{
SqlConnection con = new SqlConnection(ConfigurationSettings.AppSettings[0]);
con.Open();
string cmdStr = " SELECT top 100 createtime," + strData + " FROM Receive order by CreateTime desc ";
SqlDataAdapter da = new SqlDataAdapter(cmdStr, con);
System.Data.DataSet ds = new System.Data.DataSet();
da.Fill(ds, "Receive");
return ds;
}应该怎样转换,谢谢,在线等。
是的,谢谢,是没有用,但是也没用到dataset,怎么用呢
if (!IsPostBack)
{
this.lbtt.Text = "1";
SqlConnection con = new SqlConnection(ConfigurationSettings.AppSettings[0]);
con.Open();
// 注意前面第一个字段对应Keys,第二个字段为Values
strData = "DATA" + this.lbtt.Text;
string cmdStr = " SELECT top 100 createtime," + strData + " FROM Receive order by CreateTime desc ";
SqlDataAdapter da = new SqlDataAdapter(cmdStr, con);
System.Data.DataSet ds = new System.Data.DataSet();
da.Fill(ds, "Receive");
Chartlet2.BindChartData(ds);
}
错误 8 参数 1: 无法从“System.Data.DataSet”转换为“System.Web.UI.WebControls.SqlDataSource” D:\Program Files\MsgInfo\AreaSign\Chart.aspx.cs 40 37 D:\Program Files\MsgInfo\
if (!IsPostBack)
{
this.lbtt.Text = "1";
SqlConnection con = new SqlConnection(ConfigurationSettings.AppSettings[0]);
con.Open();
// 注意前面第一个字段对应Keys,第二个字段为Values
strData = "DATA" + this.lbtt.Text;
string cmdStr = " SELECT top 100 createtime," + strData + " FROM Receive order by CreateTime desc ";
SqlDataAdapter da = new SqlDataAdapter(cmdStr, con);
System.Data.DataSet ds = new System.Data.DataSet();
da.Fill(ds, "Receive");
Chartlet2.BindChartData(ds);
}
错误 8 参数 1: 无法从“System.Data.DataSet”转换为“System.Web.UI.WebControls.SqlDataSource” D:\Program Files\MsgInfo\AreaSign\Chart.aspx.cs 40 37 D:\Program Files\MsgInfo\