Results 1 to 3 of 3

Thread: getting data in access database 2007

  1. #1

    Thread Starter
    New Member
    Join Date
    Feb 2008
    Posts
    8

    getting data in access database 2007

    how can i get data from access database 2007 and display it in the textbox and

    after displaying it, i can edit and save it back again in the database?



    im using vb 9 and access 2007

  2. #2
    I'm about to be a PowerPoster! Hack's Avatar
    Join Date
    Aug 2001
    Location
    Searching for mendhak
    Posts
    58,333

    Re: getting data in access database 2007

    Do you even have a connection established yet?

    Are you familiar with writing SQL queries?

    Have you taken a look at our Database FAQ section?

  3. #3

    Thread Starter
    New Member
    Join Date
    Feb 2008
    Posts
    8

    Re: getting data in access database 2007

    yes im already connected with my database.

    here's my codes, but i dont know how get it from my database.

    Code:
    Dim connectString As String = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=D:\project\Visual Basic\Try\login logout\login logout\dataKiddyPark.accdb"
            Dim cn As OleDbConnection = New OleDbConnection(connectString)
    
            cn.Open()
    
    
            Dim selectString As String = "SELECT lname, fname FROM tblMembers"
            Dim cmd As OleDbCommand = New OleDbCommand(selectString, cn)
            Dim reader As OleDbDataReader = cmd.ExecuteReader()

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width