How do I loop through rows with a data reader in C#?

by

That’s the way the DataReader works, it’s designed to read the database rows one at a time.

while(reader.Read()) 
{
  var value1 = reader.GetValue(0); // On first iteration will be hello
  var value2 = reader.GetValue(1); // On first iteration will be hello2
  var value3 = reader.GetValue(2); // On first iteration will be hello3
}

More Related Contents:

  1. ERROR: Cannot convert method group ‘CopyToDataTable’ to non-delegate type ‘System.Data.DataTable’. Did you intend to invoke the method?
  2. Read SQL Table into C# DataTable
  3. How I can filter a Datatable?
  4. Efficient DataTable Group By
  5. Export DataTable to Excel File
  6. How to calculate the sum of the datatable column in asp.net?
  7. Datatable to html Table
  8. How to convert DataTable to class Object?
  9. Create Dynamic Threads in c# [closed]
  10. Split string into two separate strings [duplicate]
  11. Sql: Incorrect syntax near ‘(‘ [closed]
  12. How do you convert a DataTable into a generic list?
  13. datetime.parse and making it work with a specific format
  14. ASP.NET file download from server
  15. Get all links on html page?
  16. What is the best way to lock cache in asp.net?
  17. Sys.WebForms.PageRequestManagerParserErrorException: The message received from the server could not be parsed
  18. Dynamic MySQL database connection for Entity Framework 6
  19. Encrypt cookies in ASP.NET
  20. Asmx web service how to return JSON and not XML?
  21. Find all child controls of specific type using Enumerable.OfType() or LINQ
  22. How to natively enable JSONP for existing WCF service?
  23. POST string to ASP.NET Web Api application – returns null
  24. Creating a ASP.NET application converting text to speech
  25. How to convert datetime to timestamp using C#/.NET (ignoring current timezone)
  26. MVC4 – Bundling does not work when optimizations are set to true
  27. Error 500.19 with 0x8007000d when running ASP.NET Core app in IIS despite AspNetCoreModule being installed
  28. Change CSS classes from code
  29. How do you Sort a DataTable given column and direction?
  30. Best way to restrict access by IP address?

Leave a Comment