TechRepublic|Forums|Web Development

Web Development

General discussion

  • Creator
    Topic
  • October 4, 2004 at 6:50 am #2278315

    Connecting VB.Net to an Access Database

    Locked

    by wxdk · about 19 years, 6 months ago

    If someone could please send me code that I can use to connect an Access Database in VB.Net. I would greatly appreciate it. I need to be able to add delete and update from a form.

    Thanks,
    Mike Mangel
    wxdk@iup.edu

    Topic is locked This conversation is currently closed to new comments.
  • Creator
    Topic

All Comments

  • Author
    Replies
    • May 20, 2008 at 3:40 pm #2465646

      Try using imports System.Data.ODBC

      by aaroncool · about 15 years, 11 months ago

      In reply to Connecting VB.Net to an Access Database

      Dim oODBCConnection As OdbcConnection
      Dim sConnString As String = _
      “Driver={Microsoft Access Driver (*.mdb)};” & _
      “Dbq=C:\Test.mdb;” & _
      “Pwd=Password”
      oODBCConnection = New Odbc.OdbcConnection(sConnString)
      oODBCConnection.Open()

      Dim odr As OdbcDataReader
      Dim cmd As New OdbcCommand()
      cmd.Connection = oODBCConnection

      cmd.CommandText = “SELECT * FROM Log”

      odr = cmd.ExecuteReader()

      odr.Read()

      MsgBox(odr(“LogID”).ToString())

    • November 21, 2008 at 11:02 pm #2969335

      Check this link

      by chekuru.murali · about 15 years, 4 months ago

      In reply to Connecting VB.Net to an Access Database

  • Author
    Replies
Viewing 1 reply thread