GetName 2. GetBoolean 1. GetDataTypeName 1. GetOrdinal 1. GetSchemaTable 1. IsDBNull 1. NextResult 1. Related in langs. Reload Go. Info Go.
RateManager Java. ResultMerger Java. TextManager Python. Inheritance: System. OracleDataReader Class Documentation. Ejemplo n. Mostrar archivo. AddDays 1. AddDays CreateCommand ; cmd. Read ; connection. ToDateTime startDate. Inherited from MarshalByRefObject. Dispose Boolean. Equals Object. Determines whether the specified object is equal to the current object. Inherited from Object. GetBoolean Int GetByte Int GetChar Int GetData Int Returns a nested data reader for the requested column.
GetDataTypeName Int GetDateTime Int GetDbDataReader Int GetDecimal Int GetDouble Int Gets the value of the specified column as a double-precision floating point number. GetFieldType Int Gets the value of the specified column as the requested type. Asynchronously gets the value of the specified column as the requested type. GetFloat Int Gets the value of the specified column as a single-precision floating-point number.
GetGuid Int Gets the value of the specified column as a globally-unique identifier GUID. Serves as the default hash function. GetInt16 Int GetInt32 Int GetInt64 Int GetName Int GetOracleBFile Int GetOracleBinary Int GetOracleDateTime Int GetOracleLob Int GetOracleMonthSpan Int GetOracleNumber Int Stack Overflow for Teams — Collaborate and share knowledge with a private group.
Create a free Team What is Teams? Collectives on Stack Overflow. Learn more. Ask Question. Asked 7 years, 3 months ago. Active 7 years, 3 months ago. Viewed 20k times. GetCommand SQL ; cmd. GetInt16 0 ; yos. GetDecimal 2 ; yos. GetString 3 ; yearsOfService. Full error is: An exception of type 'System. Improve this question. Analytic Lunatic Analytic Lunatic 3, 21 21 gold badges 68 68 silver badges bronze badges.
GetDecimal 1 ; how come you are not referencing the field by name and the checking it value prior to just assigning the value..? Look up Null Coalesce — MethodMan. Remarks A case-sensitive search is made to locate the specified column by its name. Return Value The provider-specific type of the specified column.
If the attribute is a UDT, this method may return any of the following: A. GetProviderSpecificValue This method returns an object that represents the underlying provider-specific value of the specified ordinal. Return Value An Object that is a representation of the underlying provider-specific field type. Remarks If the column is an Oracle object or collection column, and a custom type mapping exists, a custom type is returned. GetProviderSpecificValues This method returns an array of objects that represent the underlying provider-specific values.
Return Value The number of Object instances in the array. Remarks The OracleDataReader. GetSchemaTable method returns the SchemaTable. The columns of the SchemaTable are in the order shown. String The name of the column. ColumnOrdinal System. Int32 The 0 -based ordinal of the column. ColumnSize System. Int64 The maximum possible length of a value in the column.
NumericPrecision System. Int16 The maximum precision of the column, if the column is a numeric data type. NumericScale System. Int16 The scale of the column. IsUnique System. Boolean Indicates whether or not the column is unique. IsUnique is guaranteed to be true if one of the following applies in descending order of priority: the column constitutes a base table primary key by itself and a NOT NULL constraint has been defined on the column there is a unique constraint or a unique index that applies only to this column and a NOT NULL constraint has been defined on the column the column is an explicitly selected ROWID IsUnique is false if the column can contain duplicate values in the base table.
The default is false. IsKey System. Boolean Indicates whether or not the column is a key column. This set of columns can be generated from one of the following in descending order of priority: A base table primary key with the following condition: A NOT NULL constraint must be defined on the column or on all of the columns, in the case of a composite primary key. IsRowID System. BaseColumnName System. String The name of the column in the database if an alias is used for the column.
BaseSchemaName System. String The name of the schema in the database that contains the column. BaseTableName System.
String The name of the table or view in the database that contains the column. DataType System. RuntimeType Maps to the common language runtime type.
ProviderType Oracle. AllowDBNull System. Boolean true if null values are allowed, otherwise false. IsAliased System. Boolean true if the column is an alias; otherwise false. IsByteSemantic System. Boolean IsByteSemantic is: true if the ColumnSize value uses bytes semantics false if ColumnSize uses character semantics This value is always true when connected to a database version earlier than Oracle9 i.
IsExpression System. Boolean true if the column is an expression; otherwise false. IsHidden System. Boolean true if the column is hidden; otherwise false. IsReadOnly System. Boolean true if the column is read-only; otherwise false. IsLong System. UdtTypeName System. String The type name of the UDT. IsIdentity System. Boolean true if the column is an identity column; otherwise false.
IsAutoIncrement System. Boolean true if the column assigns values to new rows in fixed increments; otherwise false. Not Available in ODP. NET, Managed Driver. GetString This method returns the string value of the specified column. Return Value The string value of the column.
Return Value The TimeSpan value of the column. GetValue This method returns the column value as a. Return Value The value of the column as a. Implements IDataRecord Exceptions InvalidOperationException - The connection is closed, the reader is closed, Read has not been called, all rows have been read, or no valid custom type mapping has been specified for the Oracle Object or Oracle Collection column.
Value is returned See Also: "Oracle. GetValues This method gets all the column values as. Return Value The number of objects in the values array. Return Value A.
Remarks This method should be called to check for NULL values before calling the other accessor methods. NextResult This method advances the data reader to the next result set. Remarks NextResult is used when reading results from stored procedure execution that return more than one result set.
Read This method reads the next row in the result set. Remarks The initial position of the data reader is before the first row. Inherited from System. Gets a value indicating the depth of nesting for the current row.
Specifies the size of OracleDataReader 's internal cache. Gets the number of columns in the result set. Indicates whether the OracleDataReader has one or more rows.
Gets the number of fields in the OracleDataReader that are hidden. Indicates whether or not the data reader is closed. Gets the value of the column Overloaded. Gets the number of rows changed, inserted, or deleted by execution of the SQL statement. Gets the number of fields in the OracleDataReader that are not hidden.
0コメント