'Begin读节点数据
nNode = 0
Open TheInFileNode For Input As #1
Do While Not EOF(1)
Line Input #1, LineTemp
nNode = nNode + 1
Loop
Close (1)ReDim LonNode(1 To nNode), LatNode(1 To nNode), NoNode(1 To nNode)
Open TheInFileNode For Input As #1
For I = 1 To nNode
Input #1, LatNode(I), LonNode(I), LineTemp
NoNode(I) = Val(LineTemp)
Next I
Close (1)
'End读节点数据
现在我的数据不是在TheInFileNode,而是在数据库里,我如何取出来并且代码实现???
比如取数据库中表gis_point,有三个字段,分别有经纬度和点的编号,
Set conn = New Adodb.Connection
Set rs = New Adodb.Recordset
conn.ConnectionString = "Driver={sql server};server=qyl;uid=sa;pwd=;database=AERMS"
conn.ConnectionTimeout = 30
conn.Open
rs.Open "select * from gis_point", conn, adOpenStatic, adLockReadOnly, adCmdText
这个TheInFileNode应该改成什么???
我是要取出表中的数据放在内存里。请帮我啊
nNode = 0
Open TheInFileNode For Input As #1
Do While Not EOF(1)
Line Input #1, LineTemp
nNode = nNode + 1
Loop
Close (1)ReDim LonNode(1 To nNode), LatNode(1 To nNode), NoNode(1 To nNode)
Open TheInFileNode For Input As #1
For I = 1 To nNode
Input #1, LatNode(I), LonNode(I), LineTemp
NoNode(I) = Val(LineTemp)
Next I
Close (1)
'End读节点数据
现在我的数据不是在TheInFileNode,而是在数据库里,我如何取出来并且代码实现???
比如取数据库中表gis_point,有三个字段,分别有经纬度和点的编号,
Set conn = New Adodb.Connection
Set rs = New Adodb.Recordset
conn.ConnectionString = "Driver={sql server};server=qyl;uid=sa;pwd=;database=AERMS"
conn.ConnectionTimeout = 30
conn.Open
rs.Open "select * from gis_point", conn, adOpenStatic, adLockReadOnly, adCmdText
这个TheInFileNode应该改成什么???
我是要取出表中的数据放在内存里。请帮我啊
解决方案 »
- 在网页上向EXCEL录入给定格式数据,怎么用程序写呢(关键是向excel写入数据那步)
- datagrid保存修改
- 在线等!!! listview 控件两个 如何确保将左边里的内容传入右边里的内容没有重复,通过什么属性?
- 如何在程序中更改TabScript控件的选定状态?
- 急急急!为什么在VB6简体精简版中在使用MSWINSOCK时,提示缺少许可证?
- VB与SQL Server的联合问题!情解决……谢拉~
- 关于VB无穷创建文件夹问题
- 有谁知道MAPGIS的免费下载地址
- 使用Adodc控件加上sql“insert in”语句插入新记录如何实现
- 命令发送的问题!
- 请问怎么在VB中插入IE控件?
- 连接数据库出错,谁可以帮我改一改,谢
Set conn = New Adodb.Connection
Set rs = New Adodb.Recordset
conn.ConnectionString = "Driver={sql server};server=qyl;uid=sa;pwd=;database=AERMS"
conn.ConnectionTimeout = 30
conn.Open
ReDim LonNode(1 To nNode), LatNode(1 To nNode), NoNode(1 To nNode)
rs.Open "select * from gis_point", conn, adOpenStatic, adLockReadOnly, adCmdText
for i=1 to rs.recordCount
lonNode(i)=rs.fields(0).value
LatNode(i)=rs.fields(1).value
NoNode(i)=val(rs.fields(2).value)
rs.MoveNext
Next
Set conn = New Adodb.Connection
Set rs = New Adodb.Recordset
conn.ConnectionString = "Driver={sql server};server=qyl;uid=sa;pwd=;database=AERMS"
conn.ConnectionTimeout = 30
conn.Open
rs.Open "select * from gis_point", conn, adOpenStatic, adLockReadOnly, adCmdText
dim nNode as integer,LonNode() as string,LatNode() as string,NoNode() as double
nNode=rs.RecordCount
reDim LonNode(1 To nNode), LatNode(1 To nNode), NoNode(1 To nNode)
for i=1 to nNode
lonNode(i)=rs.fields(0).value
LatNode(i)=rs.fields(1).value
NoNode(i)=val(rs.fields(2).value)
rs.MoveNext
Next
rs.Open "select * from gis_point", conn, adOpenStatic, adLockReadOnly, adCmdText
前面加上if rs.state=adstateopen then rs.close
然后再定义一个New Adodb.Recordset
其他雷同??
Set conn = New Adodb.Connection
Set rs = New Adodb.Recordset
conn.ConnectionString = "Driver={sql server};server=qyl;uid=sa;pwd=;database=AERMS"
conn.ConnectionTimeout = 30
conn.Open
rs.CursorLocation=adUseClient'设置客户端游标
rs.Open "select * from gis_point", conn, adOpenStatic, adLockReadOnly, adCmdText
dim nNode as integer,LonNode() as string,LatNode() as string,NoNode() as double
nNode=rs.RecordCount'获得记录条数
reDim LonNode(1 To nNode), LatNode(1 To nNode), NoNode(1 To nNode)
for i=1 to nNode
lonNode(i)=rs.fields(0).value
LatNode(i)=rs.fields(1).value
NoNode(i)=val(rs.fields(2).value)
rs.MoveNext
Next
-------------------
不用New Adodb.Recordset了,直接打开记录集就行了:
......
if rs.state=adstateopen then rs.close
rs.Open "select * from 另一个表名",3,2
Text1.Text=rs.Fields(0).Name
.....