How to fill a List(Of )

[mutlyp]

Hope someone can help me with this I just can't get my head around it.
I got this code off the net:
---------------------------------------------------------------------------------------------

Public Class Book
Private m_Name As String
Private m_Chapters As List(Of Chapter)

Public Property Name() As String
Get
Return m_Name
End Get
Set(ByVal value As String)
m_Name = value
End Set
End Property

Public Property Chapters() As List(Of Chapter)
Get
Return m_Chapters
End Get
Set(ByVal value As List(Of Chapter))
m_Chapters = value
End Set
End Property

End Class


Public Class Chapter
Private m_Title As String
Private m_Page As String

Public Property Title() As String
Get
Return m_Title
End Get
Set(ByVal value As String)
m_Title = value
End Set
End Property

Public Property Page() As String
Get
Return m_Page
End Get
Set(ByVal value As String)
m_Page = value
End Set
End Property

End Class

Public Sub New()
InitializeComponent()
Dim books As New ObservableCollection(Of Book)()

For i As Integer = 0 To 4
Dim book As New Book() With {.Name = "Book" + i.ToString()}

book.Chapters = New List(Of Chapter)()

For j As Integer = 0 To 4
book.Chapters.Add(New Chapter() With {.Title = "Chapter" + i.ToString() + "_" + j.ToString()})
Next

books.Add(book)
Next

Me.MainList.ItemsSource = books
End Sub

----------------------------------------------------------------------------------------------------
As you can see there is a List(Of Chapter)
And in the code it is populated with Hard Codeing "Chapter" into book.Chapters.Add
I need to know how do you do this with data from a SQL Database table.
So if I had two tables in a database one called Books and the other called Chapters
Books

BookID1 Book1

BookID2 Book2



Chapters

ChapterID1 BookID1 Chapter1

ChapterID2 BookID1 Chapter2

ChapterID3 BookID2 Chapter1a

ChapterID4 BookID2 Chapter2a

ChapterID5 BookID2 Chapter3a

How do I get this data into the List(of )?
Please help
thank you

[Cimperiali]

have a search for
SqlConnection
SqlCommand
SqlDataReader

when you're able to fill a sqlDataReader with the book data, you will be able to cycle thorugh records to load items of a List Of.
And while loading items of the list of books, you will also be able to query the db again to retrieve a sqlDataReader
full of chapters for the book you're on and to load those chapters in the appropriate List Of Capthers property of a Book object....

[Cimperiali]

Here a sample -it is one of the thousand way you could do it. The sample is a windows form done with VS 2010.
Even if it seems you could be working on WPF, the way to retrieve data from db can be the same.
I chosed the simplest.
Look inside SqlHelper.vb class and follow the comments. You will need to adjust connectionString and either to provide correct queries or to insert correct tables and fields in your db


By the way: you used an Observable class. I did not implement the pattern that it seems to be adequate for those kind of objects. If you want to explore it, have a look here
http://msdn.microsoft.com/en-us/library/dd990377.aspx

Cimpy