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
Printable View
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
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?
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()