Fill an array (or arraylist) from SqlDataReader

by

It is possible. In .NET 2.0+, SqlDataReader inherits from DbDataReader, which implements IEnumerable (non-generic one). This means that you can use LINQ:

List<string> list = (from IDataRecord r in dataReader
                     select (string)r["FieldName"]
                    ).ToList();

That said, the loop is still there, it’s just hidden in Enumerable.Select, rather than being explicit in your code.

More Related Contents:

  1. How can I add user-supplied input to an SQL statement?
  2. ExecuteReader requires an open and available Connection. The connection’s current state is Connecting
  3. Get the generated SQL statement from a SqlCommand object?
  4. SQLite Database Locked exception
  5. c# Using Parameters.AddWithValue in SqlDataAdapter
  6. SqlConnection SqlCommand SqlDataReader IDisposable
  7. SqlBulkCopy from a List
  8. Exception when AddWithValue parameter is NULL
  9. Use of SqlParameter in SQL LIKE clause not working
  10. Insert into C# with SQLCommand
  11. WHERE IN (array of IDs)
  12. How can I retrieve a list of parameters from a stored procedure in SQL Server
  13. How to fill a datatable with List [duplicate]
  14. Thread safety for DataTable
  15. How to fill Dataset with multiple tables?
  16. DataTable equivalent in Java [duplicate]
  17. What’s better: DataSet or DataReader?
  18. Using SqlDataAdapter to insert a row
  19. How do I re-write a SQL query as a parameterized query?
  20. How do I create a DataTable, then add rows to it?
  21. Add WHERE clauses to SQL dynamically / programmatically
  22. Check if a SQL table exists
  23. Unable to find the requested .Net Framework Data Provider – SQLite
  24. Unable to connect to localDB in VS2012 – “A network-related or instance-specific error occurred while establishing a connection to SQL Server…”
  25. How do I extract data from a DataTable?
  26. What is the difference between dataview and datatable?
  27. Reading a date using DataReader
  28. What ‘length’ parameter should I pass to SqlDataReader.GetBytes()
  29. How to know actual problem because of which SqlException is thrown?
  30. How to give ADO.NET Parameters

Leave a Comment