Advertisement
Guest User

Untitled

a guest
Mar 27th, 2015
204
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.71 KB | None | 0 0
  1. Dim conn As System.Data.OleDb.OleDbConnection = New System.Data.OleDb.OleDbConnection(Configuration.ConfigurationManager.ConnectionStrings("ACCESS_DB_DataConnectionString").ToString())
  2. Dim comm As System.Data.OleDb.OleDbCommand = New System.Data.OleDb.OleDbCommand("Select * FROM " + accessTable)
  3. Dim rdr As System.Data.OleDb.OleDbDataReader
  4.  
  5. Try
  6. conn.Open()
  7. rdr = comm.ExecuteReader
  8.  
  9. While rdr.Read
  10. InsertRecord()
  11. End While
  12. rdr.Close()
  13. Catch ex As Exception
  14. 'Error
  15. Finally
  16. comm.Dispose()
  17. conn.Close()
  18. conn.Dispose()
  19. End Try
  20. End Sub
  21.  
  22. Private Sub InsertRecord()
  23. 'What do I do here? Select into? But how?
  24. End Sub
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement