DataReader.GetString() via columnname

by

You’re looking for the GetOrdinal method:

this._MyField1 = reader.GetString(dr.GetOrdinal("field1"));
this._Myfield2 = reader.GetInt16(dr.GetOrdinal("field2"));

I generally cache the ordinals in an anonymous type for performance and readability:

// ...
using (IDataReader dr = cmd.ExecuteReader())
{
    var ordinals = new {
                           Foo = dr.GetOrdinal("Foo"),
                           Bar = dr.GetOrdinal("Bar")
                       };

    while (dr.Read())
    {
        DoSomething(dr.GetString(ordinals.Foo), dr.GetInt16(ordinals.Bar));
    }
}
// ...

More Related Contents:

  1. Merging two tables in SQL [closed]
  2. Get Parent with multiple children in desc order
  3. Syntax combine two stored procedure into one [closed]
  4. How can I schedule a job to run a SQL query daily?
  5. Convert Month Number to Month Name Function in SQL
  6. SQL Server 2012 column identity increment jumping from 6 to 1000+ on 7th entry [duplicate]
  7. How do I do top 1 in Oracle? [duplicate]
  8. Delete from two tables in one query
  9. Removing leading zeroes from a field in a SQL statement
  10. What are the most common SQL anti-patterns? [closed]
  11. Concatenate multiple result rows of one column into one, group by another column [duplicate]
  12. sql ORDER BY multiple values in specific order?
  13. Does SQLite3 not support foreign key constraints?
  14. ColdFusion adding extra quotes when constructing database queries in strings
  15. NOT NULL constraint over a set of columns
  16. Dynamic Pivot Table in SQL Server
  17. Optimized SQL for tree structures
  18. How can I determine the status of a job?
  19. How can I select rows with most recent timestamp for each key value?
  20. postgresql – sql – count of `true` values
  21. SQL: How can I get the value of an attribute in XML datatype?
  22. Execution sequence of Group By, Having and Where clause in SQL Server?
  23. Conditional SQL count
  24. Is it possible to execute a text file from SQL query?
  25. SELECT query with CASE condition and SUM()
  26. Left Join without duplicate rows from left table
  27. How do I compare two columns for equality in SQL Server?
  28. Designing SQL database to represent OO class hierarchy
  29. selecting top N rows for each group in a table
  30. Getting warning: Null value is eliminated by an aggregate or other SET operation

Leave a Comment