ASP.NET学习基础三十：图表进行设计

/首先添加引用在COM引用中选择利用MICROSOFT WEB OFFICE XP COMPONENTS

//给ASP.NET用户添加权限。看EXCEL部分

//using OWC10;

//using System.IO;

String constr="Provider=SQLOLEDB.1;Password=sa;Persist Security Info=True;User ID=sa;Initial Catalog=dianxinkapin;Data Source=new";

  String command="select * from comeout";

 

OleDbConnection myConn = new OleDbConnection(constr) ;

myConn.Open ( ) ;

//创建一个 DataSet

DataSet  myDataSet = new DataSet ( ) ;

//用 OleDbDataAdapter 得到一个数据集

OleDbDataAdapter myCommand = new OleDbDataAdapter (command,constr ) ;

//把Dataset绑定person数据表

myCommand.Fill (myDataSet,command) ;

//关闭此OleDbConnection

//DataRow dr = ds.Tables["comeout"].Rows[1];

OleDbCommand myCmd1=new OleDbCommand("select * from comeout",myConn);

OleDbDataReader Dr1=myCmd1.ExecuteReader();

OWC10.ChartSpaceClass oChartSpace = new OWC10.ChartSpaceClass();

System.IO.StringWriter sw = new System.IO.StringWriter();

XmlDocument xDoc = new XmlDocument();

myDataSet.WriteXml(sw);//将数据库内容写到XML文件中

// clean up

myConn.Close();

xDoc.LoadXml(sw.ToString());

sw.Close(); 

System.Xml.XmlNodeList nodes;

nodes = xDoc.ChildNodes.Item(0).ChildNodes;

int nCount = nodes.Count;

string[] aNames = new string[nCount];

string[] aTotals = new string[nCount];

string names=String.Empty;

string totals =String.Empty;

int i = 0;//将XML文件中的内容写到数组里

for(i=1;i<nCount;i++)

{

oChartSpace.Charts[0].SeriesCollection[0].SetData(OWC10.ChartDimensionsEnum.chDimValues,

  Convert.ToInt32(OWC10.ChartSpecialDataSourcesEnum.chDataLiteral),totals );//第五个字段

string strFullPathAndName=Server.MapPath(System.DateTime.Now.Ticks.ToString() +".gif");

oChartSpace.ExportPicture( strFullPathAndName, "gif", 400, 300);//导出图象

ImageButton1.ImageUrl=strFullPathAndName;//加载图象

ImageButton1.Visible =true;

RemoveFiles(Server.MapPath("."));//删除GIF文件该部分程序在前面有。省略。