Hello
I saw this code in the internet:
Dim bs As New BindingSource
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim conn As New SqlConnection("Server = .\SQLExpress;Database = NorthWind; Integrated Security = SSPI;")
Dim dt As New DataTable
Dim da As New SqlDataAdapter("Select * from Categories", conn)
da.Fill(dt)
bs.DataSource = dt
DataRepeater1.DataSource = bs
End Sub
The DataRepeater has a DrawItem event which allows us to put the data in the controls for each item. You can also use this event for formatting the data for display
Private Function GetBitmap(ByVal Pic() As Byte) As Bitmap
Dim ms As New System.IO.MemoryStream
Dim bm As Bitmap
ms.Write(Pic, 78, Pic.Length - 78)
bm = New Bitmap(ms)
Return bm
End Function
Private Sub DataRepeater1_DrawItem(ByVal sender As Object, ByVal e As Microsoft.VisualBasic.PowerPacks.DataRepeaterItemEventArgs) Handles DataRepeater1.DrawItem
Dim currItem As DataRowView = bs.Item(e.DataRepeaterItem.ItemIndex)
DirectCast(e.DataRepeaterItem.Controls("pbCategory"), PictureBox).Image = GetBitmap(DirectCast(currItem.Item("Picture"), Byte()))
DirectCast(e.DataRepeaterItem.Controls("lblName"), Label).Text = currItem.Item("CategoryName").ToString
End Sub
My problem is I encountered an error
"Object reference not set to an instance of an object." on the line "
DirectCast(e.DataRepeaterItem.Controls("pbCategory"), PictureBox).Image = GetBitmap(DirectCast(currItem.Item("Picture"), Byte()))"
Can you guys tell me whats causing me this error? Thanks in advance :)