Am creating a bible reference application, using Microsoft Office Access as Database. The point is, am able to code retrieving individual bible verse through its corresponding chapter, and show it on a textbox, but now wants to show all the records and fields in the access-db in a textbox, so that the bible can also be accessed as a whole in textbox. Is this possible? I have attempted, using the following:
Dim command As OleDbCommand = New OleDbCommand() connection.Open() command.Connection = connection command.CommandText = "Select * from NewTestament Dim dr As OleDbDataReader = command.ExecuteReader() While dr.Read() LblBibleVerses2.Text = dr("*").ToString() End While dr.Close() connection.Close()
My fields in access db are: BibleReference and BibleReadings. Table name is 'NewTestament'