Member Avatar for ExtremeGTSlayer

i'm new using VB 2008. so i hope somebody could help me. my problem is i want whenever the listbox is checked then the info in the listbox can be shown in multiple textbox along with picture. i used MS Access as my database. here i attach my code. i hope someone could teach me what's wrong and so on. thanks

Library.zip (332.59 KB)
  • 2 Contributors
  • 2 Replies
  • 80 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by ExtremeGTSlayer
Member Avatar for crazyhorse09

Just use the code tags to show your code, so we don't have to download it.

Member Avatar for ExtremeGTSlayer

hm, thanks for the response. when load form, i call the ShowBookLibrary and only book title showing in listbox

'Display the book title only
Private Sub ShowBookLibrary(ByVal conn As OleDbConnection)
Dim select_cmd As New OleDbCommand("SELECT * FROM Library", conn)
Dim reader As OleDbDataReader = select_cmd.ExecuteReader()
IstLibBook.Items.Clear()
Do While reader.Read()
IstLibBook.Items.Add(reader.Item("Title").ToString)
Loop
reader.Close()
End Sub

in my database(Library) have columns --> Title, Author, BookStatus, BookDue
so, this is where i'm stuck.

Private Sub IstLibBook_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles IstLibBook.SelectedIndexChanged
BookTitle.Text = CStr(IstLibBook.SelectedItem)
'Author.Text
'BookDue.Text
'BookStatus.Text
'GetPicture
End Sub

what am i suppost to do to make the other textbox showing the info about the book from the database?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.