各位高手能否帮忙贴一些关于MSchart控件的用法,特别是数据库的!!
谢谢!!
50分相送!!
谢谢!!
50分相送!!
解决方案 »
- vb winsock文件上传(post)失败,谁能帮修改下!附完整代码
- VB Picture控件问题(取桌面后如何安比例缩小图像)
- 有沈阳,用vb做开发的朋友吗?
- 寻找ctListBar1控件!!!!那位大哥有帮忙发一个!!!
- 求救!!!
- 如何编写程序载入?
- 如何在程序中更改活动窗口标题栏颜色?
- 请问如何把三组数字合并在一齐,比如:a=2,b=3,c=4 ,合并之后为234,就像合并字符串的&一样,多谢
- 在vb里怎么得到存储过程的返回值,还有怎么带参数 最好有例子
- 在SQLSERVER里用SELECT INTO导出DBF,XLS表的问题!!
- 谁能帮我找个例子!
- 公用变量如果定义很多的话会对程序有影响吗?
Dim Rs As New adodb.Recordset
CN.ConnectionString = "Provider=sqloledb;Data Source=pmserver;Initial Catalog=northwind;User Id=sa;Password=sa;"
CN.Open
Rs.CursorLocation = adUseClient
Rs.Open "select top 10 * from orders", CN, adOpenDynamic, adLockBatchOptimistic With MSChart1
.ChartType = VtChChartType2dLine
.TitleText = "折线图示例"
.RowCount = Rs.RecordCount
For I = 1 To Rs.RecordCount
.Row = I
.Data = Rs("freight")
.RowLabel = Rs("freight")
.ColumnCount = 1
.ColumnLabel = "freight"
Rs.MoveNext
Next End With
.ChartType 图表类型
.Data 数据
Private Sub Command1_Click()
If MSHFlexGrid1.TextMatrix(MSHFlexGrid1.Row, 2) <> "" And IsNull(MSHFlexGrid1.TextMatrix(MSHFlexGrid1.Row, 2)) = False Then '该表格有数据
With MSChart1
.ChartType = VtChChartType2dPie
.ColumnCount = 2
.RowCount = 1
Dim XXX As Double
XXX = Val(MSHFlexGrid1.TextMatrix(MSHFlexGrid1.Row, 2))
.TitleText = "饼图示例 完成百分比"
.Column = 1
.Row = 1
.Data = XXX
.ColumnLabel = "完成百分比" & str(XXX) & "%"
.Column = 2
.Row = 1
.Data = 100 - XXX
.ColumnLabel = "剩余百分比" & str(100 - XXX) & "%"
End With
' With MSChart1
' .ChartType = VtChChartType2dPie
' .ColumnCount = 2
' .RowCount = 1
' Dim XXX As Double
' XXX = Val(MSHFlexGrid1.TextMatrix(MSHFlexGrid1.Row, 2))
' .TitleText = "饼图示例 完成百分比"
' .Column = 1
' .Row = 1
' .Data = XXX
' .ColumnLabel = "完成百分比" & Str(XXX) & "%"
' .Column = 2
' .Row = 1
' .Data = 100 - XXX
' .ColumnLabel = "剩余百分比" & Str(100 - XXX) & "%"
' End With
End IfEnd Sub
If MSHFlexGrid1.TextMatrix(MSHFlexGrid1.Row, 2) <> "" And IsNull(MSHFlexGrid1.TextMatrix(MSHFlexGrid1.Row, 2)) = False Then '该表格有数据
With MSChart1
.ChartType = VtChChartType2dBar
.ColumnCount = 2
.RowCount = MSHFlexGrid1.Rows - 1
.RowCount = 1
.TitleText = "直方图示例 本旬出口数量与去年同期对比值"
Dim XXX, XXXX As Double
For I = 1 To MSHFlexGrid1.Rows - 1
XXX = Val(MSHFlexGrid1.TextMatrix(MSHFlexGrid1.Row, 2))
XXXX = Val(MSHFlexGrid1.TextMatrix(MSHFlexGrid1.Row, 2))
.Column = 1
.Row = 1
.Data = XXX
.Column = 2
.Row = 1
.Data = XXXX
.RowLabel = MSHFlexGrid1.TextMatrix(I, 1)
.RowLabel = ""
Next I
.Column = 1
.ColumnLabel = "本旬出口数量"
.Column = 2
.ColumnLabel = "去年同期对比百分数"
End With
End If
End Sub