Get Cell Value from a DataTable in C#

by

The DataRow has also an indexer:

Object cellValue = dt.Rows[i][j];

But i would prefer the strongly typed Field extension method which also supports nullable types:

int number = dt.Rows[i].Field<int>(j);

or even more readable and less error-prone with the name of the column:

double otherNumber = dt.Rows[i].Field<double>("DoubleColumn");

More Related Contents:

  1. LINQ query on a DataTable
  2. How to read a CSV file into a .NET Datatable
  3. Read SQL Table into C# DataTable
  4. Best way to remove duplicate entries from a data table
  5. How to select min and max values of a column in a datatable?
  6. How to compare 2 dataTables
  7. C# – Fill a combo box with a DataTable
  8. Convert DataTable to generic List?
  9. DataTable to JSON [duplicate]
  10. DataTable equivalent in Java [duplicate]
  11. Best way to check if a Data Table has a null value in it
  12. Returning DataTables in WCF/.NET
  13. Convert DataTable to List
  14. How to convert DataTable to class Object?
  15. Replacing a DataReader with a DataTable
  16. DataTable internal index is corrupted
  17. How can I convert a DataTable to an XML file in C#?
  18. Why can’t I do foreach (var Item in DataTable.Rows)?
  19. How to enable assembly bind failure logging (Fusion) in .NET
  20. ReadOnlyCollection or IEnumerable for exposing member collections?
  21. Static Generic Class as Dictionary
  22. Extension methods syntax vs query syntax
  23. Refactoring code to avoid anti-pattern
  24. Is the sorting algorithm used by .NET’s `Array.Sort()` method a stable algorithm?
  25. Upload file on FTP
  26. Reverse a string with accent chars?
  27. Which objects can I use in a finalizer method?
  28. how to handle spaces in file path if the folder contains the space?
  29. Can I reuse HttpWebRequest without disconnecting from the server?
  30. Parsing field name with a colon in JSON

Leave a Comment