dl_会飞的青蛙 dl_会飞的青蛙
关注数: 3 粉丝数: 52 发帖数: 10,438 关注贴吧数: 5
[翻问题解决了] Option ExplicitPublic appdisk As StringPublic conn As New ADODB.ConnectionPublic Rs As New ADODB.RecordsetPublic db As StringPrivate sSQL As StringPrivate iPage As IntegerPrivate Sub cmdNext_Click() If iPage + 1 = Rs.PageCount Then Rs.AbsolutePage = Rs.PageCount Else Rs.AbsolutePage = iPage + 1 iPage = iPage + 1 End IfEnd SubPrivate Sub Command1_Click() If iPage - 1 = 0 Then Rs.AbsolutePage = iPage Else Rs.AbsolutePage = iPage - 1 iPage = iPage - 1 End IfEnd SubPrivate Sub Form_Load() iPage = 1 Dim i As Integer On Error GoTo Err appdisk = Trim(App.Path) If Right(appdisk, 1) <> "\" Then appdisk = appdisk & "\" db = appdisk db = "Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=False;Data Source=" & db & "db1.mdb" conn.CursorLocation = adUseClient conn.Open db Rs.Open "select * from pump4", conn, adOpenDynamic, adLockOptimistic Rs.PageSize = 10 Set DataGrid1.DataSource = Rs DataGrid1.Columns(0).Width = 15 * 7 * 3 DataGrid1.Columns(1).Width = 15 * 7 * 10 DataGrid1.Columns(2).Width = 15 * 7 * 8 DataGrid1.Columns(3).Width = 15 * 7 * 7 DataGrid1.Columns(4).Width = 15 * 7 * 7 DataGrid1.Columns(5).Width = 15 * 7 * 7 DataGrid1.Columns(6).Width = 15 * 7 * 7 DataGrid1.Columns(7).Width = 15 * 7 * 7 DataGrid1.Columns(8).Width = 15 * 7 * 7 DataGrid1.Columns(9).Width = 15 * 7 * 7 DataGrid1.Columns(10).Width = 15 * 7 * 7 DataGrid1.Columns(11).Width = 15 * 7 * 9 DataGrid1.Columns(12).Width = 15 * 7 * 9 DataGrid1.Columns(13).Width = 15 * 7 * 9 DataGrid1.Columns(14).Width = 15 * 7 * 10 Exit SubErr: MsgBox Err.Number Unload MeEnd Sub
[简单些了个ACCESS数据倒入到ORACLE的小程序] 记得前几天有人问这个 正好今天需要 就写了一个!~'窗体text1 text2 text2 combo2 '引用 ado2.5+ oracle4.0Option ExplicitPublic appdisk As StringPublic conn As New ADODB.ConnectionPublic Rs As New ADODB.RecordsetPublic db As StringPublic oOraSess As ObjectPublic oOraDb As OraDatabaseConst ORADB_ORAMODE = &H1&Public OraCN As New ADODB.ConnectionPrivate sSQL As StringPrivate Sub Command1_Click() Dim i As Integer Dim j As Integer Dim sSQL As String Set oOraSess = CreateObject("OracleInProcServer.XOraSession") Set oOraDb = oOraSess.OpenDatabase(Text1.Text, Text2.Text & "/" & Text3.Text, ORADB_ORAMODE) On Error Resume Next For i = 0 To Combo2.ListCount - 1 Combo2.ListIndex = i Rs.Open "SELECT * FROM " & Combo2.Text & "", conn, adOpenKeyset, adLockPessimistic Rs.MoveFirst For t = 0 To Rs.RecordCount - 1 sSQL = "" sSQL = "INSERT INTO " & Combo2.Text & " VALUES(" & vbCrLf For j = 0 To Rs.Fields.Count - 1 If j = Rs.Fields.Count - 1 Then sSQL = sSQL & "'" & Rs.Fields(j) & "'" & vbCrLf Else sSQL = sSQL & "'" & Rs.Fields(j) & "'," & vbCrLf End If Next sSQL = sSQL & ")" oOraDb.ExecuteSQL sSQL Rs.MoveNext Next Rs.Close NextEnd SubPrivate Sub Form_Load() Dim i As Integer On Error GoTo Err db = "\\vs2003\001-开発\200705_広江\01_日本资料\広江ASS\HIROE\広江システム.mdb" db = "Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=False;Data Source=" & db conn.CursorLocation = adUseClient conn.Open db i = 0 Set Rs = conn.OpenSchema(adSchemaTables) If Rs.EOF = False Then Do Until Rs.EOF If Left(Rs!TABLE_NAME, 4) <> "MSys" Then Combo2.AddItem Rs!TABLE_NAME, i i = i + 1 End If Rs.MoveNext Loop End If Rs.Close Exit Sub Err: MsgBox Err.Number Unload MeEnd Sub
1 下一页