C# - Convert SqlDataReader to ArrayList

Question

Is there a way to convert SqlDataReader to arrayList?

I have to pass the results of a query from one page to another so that I can then bind it to a gridview. However, I can't pass the SqlDataReader object in the session.

How can I achieve the following?:

if (rdr.HasRows == true)
                    {
                        while (rdr.Read())
                        {
                             arraylist.add(whole row); //pseudo code
                        }
                    }

Thank you :)

I would fill a DataTable with a SqlDataAdapter and use that as DataSource. — Tim Schmelter
– Tim Schmelter, Commented Jun 22, 2013 at 16:49
Why would you want to use ArrayList rather than a List<T>? — Jon Skeet
– Jon Skeet, Commented Jun 22, 2013 at 16:57
May be duplicate of - stackoverflow.com/questions/1370543/… — user2323308
– user2323308, Commented Jun 22, 2013 at 16:59
I don't know. I thought that an arraylist would do the job hehe :s — Matthew
– Matthew, Commented Jun 22, 2013 at 16:59

Steve · Accepted Answer · 2013-06-22 16:54:57Z

3

You could use a SqlDataReader to build a DataTable and pass this object

DataTable dt = new DataTable();
if (rdr.HasRows == true)
     dt.Load(rdr);

A very complete example with various options available could be found on MSDN
Now you could pass the whole DataTable instance and use it to bind the GridView

edited Jun 22, 2013 at 16:54

answered Jun 22, 2013 at 16:49

Steve

217k22 gold badges242 silver badges296 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

C# - Convert SqlDataReader to ArrayList

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related