Convert datareader into ArrayList

SKhna · February 25th, 2008, 05:00 PM

Hi
I am trying to convert the datreader into ArrayList. The ArrayList consist of four columns But what i am all getting is All the data in one column with multiple rows. What i actually what is to store all the data in ArrayList with the same format as it appeared in datareader so that i can bound it with GridView.

My current code is given bellow:

Code:

   Dim dr As SqlDataReader = cmd.ExecuteReader()
        Dim al As New ArrayList

        If (dr.HasRows) Then

            While (dr.Read())

                Dim fields As Integer = dr.FieldCount()
                ' Dim a As Integer

                For fields = 0 To dr.FieldCount - 1
                    al.Add(dr.Item(fields))
                Next
            End While
        End If

dparsons · February 25th, 2008, 05:06 PM

O.o First Peter has given you a good jumping off point in this post:

http://p2p.wrox.com/topic.asp?TOPIC_ID=69286

Second, why are you going about binding a GridView like this?

Third, what do you expect is going to happen based on your code? You simply loop all of the fields in your datareader and add the values of a given field to your arraylist...which is 1 Dimensional.

A better approach would be to use a DataSet or a DataTable.

http://www.google.com/search?hl=en&r...Using+DataSets

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
================================================== =========
.: Wrox Technical Editor / Author :.
Wrox Books 24 x 7
================================================== =========

planoie · February 26th, 2008, 10:48 AM

SKhna,

First, as Doug pointed out an ArrayList is 1 dimension. If you want to put more than 1 bit of data into it for each item, you need to put in something which itself has the several bits of data (like a class instance).

If you are dealing with tabular data, use a tabular object like the DataReader or DataTable.

You can bind a DataReader directly to a control, so there's no reason to convert or copy the data.

-Peter
peterlanoie.blog