howto get table from property

[aniskhan]

i have a class with database operations

now i want a property that can return the data captured in the dataReader.

how to code this property so that it returns the data as arraylist or some thing else...

ReadOnly Property reader()
        Get
            Dim arr As new ArrayList

            While dataReader.Read
                arr.Add(dataReader.GetString(0))
            End While

            Return arr
        End Get
End Property

suggest a way to get the whole table...Thanx

 

[jmcilhinney]

If you want the whole table then why return an ArrayList? Why not return a DataTable. If you know the schema of the table beforehand then you can hardcode that into the method. If you don't know the schema beforehand then you can call GetSchemaTable on the DataReader to get all the information you need to build a DataTable. Once you've done that you can then populate it with the data from the DataReader.