This interface provides access to column values when you use a data reader. You can retrieve a value from a column using the indexer for IDataRecord with the column name or index. Alternatively, you can use one of the typed accessor methods to retrieve a column value by index and convert it to the specified type in one step. For example, GetInt32( ) retrieves the specified column value and casts it to the System.Int32 type. Provider-specific data readers add methods that return data using source-specific data types. You can use the FieldCount property to determine how many columns are in a table. However, if you aren't positioned on a record (for example, you havn't called IDataReader.Read( ) ), this property returns 0.

public interface IDataRecord {
// Public Instance Properties
   public int FieldCount{get; } 
   public object this[string name]{get; } 
   public object this[int i]{get; } 
// Public Instance Methods
   public bool GetBoolean( int i);  
   public byte GetByte( int i);  
   public long GetBytes(int i, long fieldOffset, byte[ ] buffer, int bufferoffset, int length);
   public char GetChar( int i);  
   public long GetChars(int i, long fieldoffset, char[ ] buffer, int bufferoffset, int length);
   public IDataReader GetData( int i);  
   public string GetDataTypeName( int i);  
   public DateTime GetDateTime( int i);  
   public decimal GetDecimal( int i);  
   public double GetDouble( int i);  
   public Type GetFieldType( int i);  
   public float GetFloat( int i);  
   public Guid GetGuid( int i);  
   public short GetInt16( int i);  
   public int GetInt32( int i);  
   public long GetInt64( int i);  
   public string GetName( int i);  
   public int GetOrdinal( string name);  
   public string GetString( int i);  
   public object GetValue( int i);  
   public int GetValues( object[ ] values);  
   public bool IsDBNull( int i);  
}

Implemented By

IDataReader , System.Data.Common.DbDataRecord , System.Data.OleDb.OleDbDataReader , System.Data.OracleClient.OracleDataReader , System.Data.SqlClient.SqlDataReader