Export (0) Print
Expand All

SqlDataReader Methods

The SqlDataReader type exposes the following members.

  NameDescription
Public method Supported by the .NET Compact Framework Close Closes the SqlDataReader object. (Overrides DbDataReader.Close().)
Public method CreateObjRef Creates an object that contains all the relevant information required to generate a proxy used to communicate with a remote object. (Inherited from MarshalByRefObject.)
Public method Dispose Overloaded. Releases the resources used by the DbDataReader and calls Close.
Public method Supported by the .NET Compact Framework Equals Determines whether the specified Object is equal to the current Object. (Inherited from Object.)
Protected method Supported by the .NET Compact Framework Finalize Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection. (Inherited from Object.)
Public method Supported by the .NET Compact Framework GetBoolean Gets the value of the specified column as a Boolean. (Overrides DbDataReader.GetBoolean(Int32).)
Public method Supported by the .NET Compact Framework GetByte Gets the value of the specified column as a byte. (Overrides DbDataReader.GetByte(Int32).)
Public method Supported by the .NET Compact Framework GetBytes Reads a stream of bytes from the specified column offset into the buffer an array starting at the given buffer offset. (Overrides DbDataReader.GetBytes(Int32, Int64, Byte[], Int32, Int32).)
Public method Supported by the .NET Compact Framework GetChar Gets the value of the specified column as a single character. (Overrides DbDataReader.GetChar(Int32).)
Public method Supported by the .NET Compact Framework GetChars Reads a stream of characters from the specified column offset into the buffer as an array starting at the given buffer offset. (Overrides DbDataReader.GetChars(Int32, Int64, Char[], Int32, Int32).)
Public method Supported by the .NET Compact Framework GetData Overloaded.
Public method Supported by the .NET Compact Framework GetDataTypeName Gets a string representing the data type of the specified column. (Overrides DbDataReader.GetDataTypeName(Int32).)
Public method Supported by the .NET Compact Framework GetDateTime Gets the value of the specified column as a DateTime object. (Overrides DbDataReader.GetDateTime(Int32).)
Public method GetDateTimeOffset Retrieves the value of the specified column as a DateTimeOffset object.
Protected method GetDbDataReader Returns a DbDataReader object for the requested column ordinal that can be overridden with a provider-specific implementation. (Inherited from DbDataReader.)
Public method Supported by the .NET Compact Framework GetDecimal Gets the value of the specified column as a Decimal object. (Overrides DbDataReader.GetDecimal(Int32).)
Public method Supported by the .NET Compact Framework GetDouble Gets the value of the specified column as a double-precision floating point number. (Overrides DbDataReader.GetDouble(Int32).)
Public method GetEnumerator Returns an IEnumerator that iterates through the SqlDataReader. (Overrides DbDataReader.GetEnumerator().)
Public method Supported by the .NET Compact Framework GetFieldType Gets the Type that is the data type of the object. (Overrides DbDataReader.GetFieldType(Int32).)
Public method Supported by the .NET Compact Framework GetFloat Gets the value of the specified column as a single-precision floating point number. (Overrides DbDataReader.GetFloat(Int32).)
Public method Supported by the .NET Compact Framework GetGuid Gets the value of the specified column as a globally unique identifier (GUID). (Overrides DbDataReader.GetGuid(Int32).)
Public method Supported by the .NET Compact Framework GetHashCode Serves as a hash function for a particular type. (Inherited from Object.)
Public method Supported by the .NET Compact Framework GetInt16 Gets the value of the specified column as a 16-bit signed integer. (Overrides DbDataReader.GetInt16(Int32).)
Public method Supported by the .NET Compact Framework GetInt32 Gets the value of the specified column as a 32-bit signed integer. (Overrides DbDataReader.GetInt32(Int32).)
Public method Supported by the .NET Compact Framework GetInt64 Gets the value of the specified column as a 64-bit signed integer. (Overrides DbDataReader.GetInt64(Int32).)
Public method GetLifetimeService Retrieves the current lifetime service object that controls the lifetime policy for this instance. (Inherited from MarshalByRefObject.)
Public method Supported by the .NET Compact Framework GetName Gets the name of the specified column. (Overrides DbDataReader.GetName(Int32).)
Public method Supported by the .NET Compact Framework GetOrdinal Gets the column ordinal, given the name of the column. (Overrides DbDataReader.GetOrdinal(String).)
Public method GetProviderSpecificFieldType Gets an Object that is a representation of the underlying provider-specific field type. (Overrides DbDataReader.GetProviderSpecificFieldType(Int32).)
Public method GetProviderSpecificValue Gets an Object that is a representation of the underlying provider specific value. (Overrides DbDataReader.GetProviderSpecificValue(Int32).)
Public method GetProviderSpecificValues Gets an array of objects that are a representation of the underlying provider specific values. (Overrides DbDataReader.GetProviderSpecificValues(Object[]).)
Public method Supported by the .NET Compact Framework GetSchemaTable Returns a DataTable that describes the column metadata of the SqlDataReader. (Overrides DbDataReader.GetSchemaTable().)
Public method Supported by the .NET Compact Framework GetSqlBinary Gets the value of the specified column as a SqlBinary.
Public method Supported by the .NET Compact Framework GetSqlBoolean Gets the value of the specified column as a SqlBoolean.
Public method Supported by the .NET Compact Framework GetSqlByte Gets the value of the specified column as a SqlByte.
Public method GetSqlBytes Gets the value of the specified column as SqlBytes.
Public method GetSqlChars Gets the value of the specified column as SqlChars.
Public method Supported by the .NET Compact Framework GetSqlDateTime Gets the value of the specified column as a SqlDateTime.
Public method Supported by the .NET Compact Framework GetSqlDecimal Gets the value of the specified column as a SqlDecimal.
Public method Supported by the .NET Compact Framework GetSqlDouble Gets the value of the specified column as a SqlDouble.
Public method Supported by the .NET Compact Framework GetSqlGuid Gets the value of the specified column as a SqlGuid.
Public method Supported by the .NET Compact Framework GetSqlInt16 Gets the value of the specified column as a SqlInt16.
Public method Supported by the .NET Compact Framework GetSqlInt32 Gets the value of the specified column as a SqlInt32.
Public method Supported by the .NET Compact Framework GetSqlInt64 Gets the value of the specified column as a SqlInt64.
Public method Supported by the .NET Compact Framework GetSqlMoney Gets the value of the specified column as a SqlMoney.
Public method Supported by the .NET Compact Framework GetSqlSingle Gets the value of the specified column as a SqlSingle.
Public method Supported by the .NET Compact Framework GetSqlString Gets the value of the specified column as a SqlString.
Public method Supported by the .NET Compact Framework GetSqlValue Returns the data value in the specified column as a SQL Server type.
Public method Supported by the .NET Compact Framework GetSqlValues Fills an array of Object that contains the values for all the columns in the record, expressed as SQL Server types.
Public method GetSqlXml Gets the value of the specified column as an XML value.
Public method Supported by the .NET Compact Framework GetString Gets the value of the specified column as a string. (Overrides DbDataReader.GetString(Int32).)
Public method GetTimeSpan Retrieves the value of the specified column as a TimeSpan object.
Public method Supported by the .NET Compact Framework GetType Gets the type of the current instance. (Inherited from Object.)
Public method Supported by the .NET Compact Framework GetValue Gets the value of the specified column in its native format. (Overrides DbDataReader.GetValue(Int32).)
Public method Supported by the .NET Compact Framework GetValues Populates an array of objects with the column values of the current row. (Overrides DbDataReader.GetValues(Object[]).)
Public method InitializeLifetimeService Obtains a lifetime service object to control the lifetime policy for this instance. (Inherited from MarshalByRefObject.)
Protected method IsCommandBehavior Determines whether the specified CommandBehavior matches that of the SqlDataReader .
Public method Supported by the .NET Compact Framework IsDBNull Gets a value that indicates whether the column contains non-existent or missing values. (Overrides DbDataReader.IsDBNull(Int32).)
Protected method Supported by the .NET Compact Framework MemberwiseClone Overloaded.
Public method Supported by the .NET Compact Framework NextResult Advances the data reader to the next result, when reading the results of batch Transact-SQL statements. (Overrides DbDataReader.NextResult().)
Public method Supported by the .NET Compact Framework Read Advances the SqlDataReader to the next record. (Overrides DbDataReader.Read().)
Public method Supported by the .NET Compact Framework ToString Returns a string that represents the current object. (Inherited from Object.)
Top

  NameDescription
Public Extension Method Cast Converts the elements of an IEnumerable to the specified type. (Defined by Enumerable.)
Public Extension Method OfType Filters the elements of an IEnumerable based on a specified type. (Defined by Enumerable.)
Top

Community Additions

ADD
Show:
© 2014 Microsoft