whats wrong with this code???
the vb always tell that items is not a member?

Imports MySql.Data.MySqlClient

Public Class search
    Public conn As New MySqlConnection

    Private Sub search_load(ByVal server As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        If conn.State = ConnectionState.Closed Then
            conn.ConnectionString = "SERVER = localhost; USERID = root; PASSWORD =; DATABSE = kahuna  "
        End If
    End Sub

    Public Function WithDrawal(ByVal Amount As Decimal, _
      ByVal TransactionCode As Byte) As Double
        ' Add code here to perform the withdrawal,
        ' return a transaction code, 
        ' or to raise an overdraft error.
    End Function

    Public Sub LoadPeople()
        Dim sqlQuery As String = "SELECT * FROM reservation"
        Dim sqlAdapeter As New MySqlDataAdapter
        Dim sqlcmd As New MySqlCommand
        Dim rdr As MySqlDataReader = sqlcmd.ExecuteReader()
        Dim TABLE As New DataTable
        Dim i As Integer
        Dim Items As String = ""

        With sqlcmd
            .CommandText = sqlQuery
            .Connection = conn
        End With

        With sqlAdapeter
            .SelectCommand = sqlcmd
        End With

        For i = 0 To TABLE.Rows.Count - 1
            With Me
                With .Items(.Items.Count - 1).subitems

                End With
            End With
    End Sub

End Class
This article has been dead for over six months. Start a new discussion instead.