求助高手TChart连接数据库问题

来源:百度知道 编辑:UC知道 时间:2024/06/19 18:48:53
Dim conn As New ADODB.Connection
Dim rs As New ADODB.Recordset
Dim connstr As String
Dim sql As String

Private Sub form_load()

connstr = "driver={microsoft access driver (*.mdb)};dbq=" & App.Path & "\Ex.mdb"
conn.Open connstr
sql = "select * from aaa"
rs.Open sql, conn, adOpenKeyset, adLockPessimistic

With TChart1
TChart1.AddSeries (scLine)

.Series(0).Clear

Axis = .Axis.AddCustom(False)
.Axis.Custom(Axis).StartPosition = 0
.Axis.Custom(Axis).EndPosition = 100
.Axis.Custom(Axis).AxisPen.Color = vbRed
.Axis.Custom(Axis).Labels.Font.Color = vbRed
.Series(0).VerticalAxisCustom = Axis
.Axis.Custom(Axis).Maximum = 1500
.Axis.Custom(Axis).Minimum = 0
Randomize
Set TChart1.Series(0).DataSource = rs
TChart1.Ser

在rs.open 之前,就该先更改运行状态CursorLocation

rs.CursorLocation=adUseClient
sql = "select * from aaa"
rs.Open sql, conn, adOpenKeyset, adLockPessimistic
Set TChart1.Series(0).DataSource = rs
set rs=nothing