為什么你的ColumnCount 也= 6?
把妳數据庫的字段列出來,不要用*
把妳數据庫的字段列出來,不要用*
解决方案 »
- 如何调用记事本
- 请教:关于VB调用Crystal报表的问题
- VB中如何快速读取并显示大图?
- 还是目录树的老问题,找了资料,可是没有解决.谢谢.
- 关于CommonDialog和ListBox的问题。。。
- ftpfindfirstfile如何用在非21端口连接中?
- 讨论:VB做主表与明细表的程序,怎么做最好?
- 有关报表打印的超难问题,可能与vb和打印机接口有关,高分求指点!
- 求助:ado打开txt文件时为何无法与其他程序共享?在线等候
- (100分)Access查询生成的SQL,想在程序过程里把Adodc1.RecordSource
- dll的调用问题!
- 请问:在Datareport中怎样实现本页小计、总计?
Dim scmd As String,Sql as String
Dim rs As new Adodb.RecordsetSql = "Provider=SQLOLEDB.1;password=;Persist Security Info=False;User ID=sa;Initial Catalog=ZNXG;Data Source=127.1.1.0"
Conn.Open (Sql)
'If rs.State = 1 Then rs.Close
rs.Open "select * from cs", con, adOpenForwardOnly, adLockReadOnly
If Not rs.EOF Then
With MSChart1
.Refresh
.ColumnCount = 6
.RowCount = rs.RecordCount
For Column = 1 To 6
.Column = Column
.ColumnLabel = "Line_" & CStr(Column)
Next
For Row = 1 To rs.RecordCount
.Row = Row
.RowLabel = CStr(rs.Fields(0).Value)
For Column = 1 To 6
.Column = Column
.Row = Row
.Data = IIf(IsNull(rs.Fields("rq").Value), 0, rs.Fields("kll").Value)
Next
rs.MoveNext
If rs.EOF Then Exit For
Next
End With
End If