OleDbDataReader to ArrayList in C#

Question

How to iterate through OleDbDataReader and put its elements into ArrayList?

Here is my code:

// ...

ArrayList list = new ArrayList();

while(myReader.Read())
{
    foreach(string s in myReader) // I got an Exception here
    {
        list.Add(s);
    }
}

// ...

Label lbl = new Label();
lbl.Text = list[i] as string;

and here is the Exception:

System.InvalidCastException: Unable to cast object of type 'System.Data.Common.DataRecordInternal' to type 'System.String'.

I don't get it. What are you trying to do? Put strings from all available columns into a list, regardless of the column name or type? — GSerg
– GSerg, Commented Dec 17, 2011 at 12:27

Davide Piras · Accepted Answer · 2011-12-17 12:31:38Z

1

try this:

while (myReader.Read())
{
  list.Add(myReader.GetString(0));
}

edited Dec 17, 2011 at 12:31

answered Dec 17, 2011 at 12:24

Davide Piras

44.7k10 gold badges103 silver badges150 bronze badges

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

4 Comments

Eng.Fouad Over a year ago

I am not sure why I got this error: Cannot convert type 'char' to 'string'

Davide Piras Over a year ago

edit your question with your new code, without seeing it is impossible to answer!

GSerg Over a year ago

This answer is apparently wrong. GetString returns a string, and foreach in a string is looping through the characters of the string.

shenhengbin Over a year ago

If you donnt know the datatype , you could use myReader.GetValue(0) + ""

Collectives™ on Stack Overflow

OleDbDataReader to ArrayList in C#

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related