this throws an exception, when the field does not exist:
reader.IsDbNull(reader.GetOrdinal("FieldName")) => bang
Why not return -1 ?
Why does reader.GetOrdinal("FieldName") throw an exception?
2.3k Views Asked by Elisabeth At
1
There are 1 best solutions below
Related Questions in ADO.NET
- Are there drawbacks to leaving a SqlConnection open long-term?
- Stored procedure's output parameters not updating
- An unhandled exception of type 'system.data.oledb.oledbexception'
- how to get current row index when reading DbDataReader in ADO.net
- Entity Framework throws Invalid object name
- Ignore max length property on ADO.NET DataTable
- How to fill two different datagrid from one mysql table in c#
- Ado.net running SQL Server stored procedure can't retrieve output value when using ExecuteReader
- DBConcurrency exception not occuring when data has been updated elsewhere
- Use wildcards in ado.net sybase parameter
- How to copy rows from a DataTable to another DataTable WITHOUT deleting existing rows?
- Use in operator in stored query in ms access with ado.net
- How to use entity framework with business objects
- ADO.Net INSERT not inserting data
- SQL Server 2012 - Bulk insert error - This operation conflicts with another pending operation on this transaction
Related Questions in FIELD
- How to hide a field on a one2many in openerp?
- How to automatically detect X/Y fields in CSV
- Fill every field on page with a string using a bookmarklet
- Incorrect Extraction of fields in Splunk
- Symfony 2 value on Enitty field
- django: disable tinymce for one certain field
- Moving all fields from one object into another
- Using reserved word field name in DocumentDB
- How to change some specific fields of a structure without using for loop in matlab?
- Abstract fields implemented by static final class?
- how to add field inside hr_timesheet_sheet.sheet?
- rails fields for conditional
- Java reflection - get field value
- linux cut command with field-value condition
- How do change field length with arcobject
Related Questions in EXISTS
- Correct Usage of IF Exists in SQL
- Verify youtube api v3 video exists JS
- How to check if a file exists when it was no file extension? C#
- Check for column existence in mySQL
- HTML/Java: .exists() always returns true
- if exist on an XML node in XmlNodeList C#
- SQL Server: IF EXISTS massively slowing down a query
- how to create a stored procedure containing request where not exists in mysql database
- c# List.Exists returns true with "false && true"
- SQL do not insert duplicates
- DB2 Case When Exists
- What is the best way to update a one table from another in SQL?
- file_exists is not work !(php)
- If Any of These Files Don't Exist Execute Target
- Check if key exists in hash using value from another hash as hash name
Related Questions in SQLDATAREADER
- MultipleActiveResultSet is disabled but it works fine
- Getting "Incorrect syntax near"-error with SqlDataReader
- I have menustrip and each of items have its combobox
- Passing IDataReader to inherited classes not closing connections ExecuteDataReaderAsync in C#
- Getting a "There is already an open DataReader associated with this Command which must be closed first" error
- List in Vb.net Sqldatareader
- Invalid attempt to read when no data is present by SqlDataReader
- DbDataReader.GetFieldValue<DateTime> throws casting exception
- Fetch row and Save in Variable
- Use Generic class with SqlDataReader GetValue
- In C#, SQL connection is printing: 'System.Data.SqlClient.SqlDataReader'
- Column longtext exceeds the MaxLength limit
- SQL SELECT protocol in C#
- Invalid attempt to call Read when reader is closed
- NpgsqlDataReader Select statement- Not Working for camelCase data Tables
Related Questions in ORDINAL
- How to make a Highstocks x-axis even and regular?
- How do I set a model sub-parameter named "method" from caret's train() function
- Export function from dll by ordinal only does not hide function name
- CFA in R (lavaan) with ordinal data - polychoric correlation included?
- Setting Ordinal Enum values to start from 1 instead of 0
- Convert a string to ordinal upper or lower case
- How do I increase or decrease an ordered factor's level? (Make a factor equal to the very next level)
- Python CGI using "st", "nd", "rd" and "th"
- Pseudo R squared for cumulative link function
- Matrix conditioning in ordinal logistic regression
- Designing an algorithm for detecting anamoly and statistical significance for ordinal data using python
- st, rd, th... date in ordinal form javascript
- Access columns of a table by index instead of name in SQL Server stored procedure
- Why does reader.GetOrdinal("FieldName") throw an exception?
- Using the Ruby Date class for Astronomical data
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
I'll try to guess here.
The common pattern for this method is to call GetOrdinal for column name and then call GetXXX() methods with given ordinal which is faster than do a search by column's name every time.
Therefore in case of exception here we fail fast and we can't ignore it. Wihtout exception we will try to find a column that doesn't exist and then try to find a field by given ordinal (without checking for -1 which is very easy to omit in this case) and only here we will realise that something went wrong few steps before (may be even too many steps before).