给个例子,谢谢
解决方案 »
- “对象变量或with块变量未设置”的错误。大家帮我看看怎么改阿。多谢!
- text
- 数据库创建,数据表创建?
- 如果用程序判断一台机子是不是局域网里提供上网上的代理服务器...
- 简、繁转换乱码的问题,比较急
- 菜鸟的问题!
- 打包问题:我在windows2000professional(sp3++)下打出来的东西,在别的windows2000professional(sq1),或window2000server下安装怎么老
- 怎样用递归法将一个表中的项目加入到TREEVIEW中?表格式内详!
- sql备份
- 应用程序在客户端,数据库在服务器端,问怎么样连接数据库为最佳?
- 模糊查询
- 请问如何让text控件中的文字起始位置向右偏移几个像素?
Dim re As ADODB.Recordset
Dim cn As String
cn = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=pubs"
Set re = New ADODB.Recordset
re.Open "select * from authors", cn, 3, 3
re.Save App.Path & "\aa.xml", adPersistXML
re.Close
End Sub
Dim rs As New ADODB.Recordset
Private Sub Command1_Click()
rs.CursorLocation = adUseClient
rs.Open "Select * from students", cn, adOpenStatic, adLockBatchOptimistic
MsgBox rs.RecordCount
'保存为XML
rs.Save "c:\bbb.xml", adPersistXML
rs.Close
'读取XML文件
rs.Open "c:\bbb.xml", cn, adOpenStatic, adLockReadOnly, adCmdFile
MsgBox rs.RecordCount
rs.Close
End SubPrivate Sub Form_Load()
If cn.State = 1 Then
cn.Close
End If
cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\db1.mdb"
End Sub
For i = LBound(CaseIDs) To UBound(CaseIDs)
sql = "select * from asa_evaluation where patient_case_id='" & CaseIDs(i) & "'"
Set rs = cn.Execute(sql)
If Not rs.EOF Then
rs.Save App.Path & "\aaa.xml", adPersistXML
End If
Next在表中有image类型数据,而且还报文件已存在的错误,我该怎么个改法呀。
方法前需要查找下文件是否已经存在。
可改为:if dir(App.Path & "\aaa.xml")<>"" then kill App.Path & "\aaa.xml"
rs.Save App.Path & "\aaa.xml", adPersistXML
不过再使用上述语句时,如果是App.path为根目录下,就不需要加“\"了。
rs.Save App.Path & "\aaa" & i & ".xml", adPersistXML
Dim strXMLDim fmstrXML = "<xml>"rs1.MoveFirstDo While Not rs1.EOFstrXML = strXML & "<row>"For Each fm In rs1.FieldsstrXML = strXML & "<" & fm.name & ">" & fm.Value & "</" & fm.name & ">"NextstrXML = strXML & "</row>"rs1.MoveNextLoopstrXML = strXML & "</xml>"
Private Sub Command1_Click()
Dim cn
Set cn = CreateObject("adodb.connection")
cn.open "ECCSDB", "ECCSDB", "ECCSDB"
Dim sql
sql = "SELECT * FROM ECCS_AGENT ORDER BY AGENTID" Set rs = CreateObject("adodb.recordset") 'rs.CursorLocation = adUseClient 该行编译通不过
rs.open sql, cn, 3, 3
'写XML
If Dir("E:\bbb.xml") <> "" Then Kill "E:\bbb.xml"
rs.Save "E:\bbb.xml", adPersistXML
MsgBox rs.RecordCount 该行 打出来的值为 -1 rs.Close
Set rs = Nothing
cn.Close
Set cn = Nothing
End Sub以上代码保存文件后是乱码,其实数据库中是有值的。还有我现在是在VB环境中测试,但是实际环境设计要在VBScript脚本中执行