// from module 'c:\winnt\assembly\gac\system.data\1.0.3300.0__b77a5c561934e089\system.data.dll' public sealed class System.Data.SqlClient.SqlDataReader : MarshalByRefObject, System.Collections.IEnumerable, System.Data.IDataReader, IDisposable, System.Data.IDataRecord { // Fields // Constructors // Properties public int Depth { virtual get; } public int FieldCount { virtual get; } public bool IsClosed { virtual get; } public object this[ string name ] { virtual get; } public object this[ int i ] { virtual get; } public int RecordsAffected { virtual get; } // Methods public virtual void Close(); public virtual System.Runtime.Remoting.ObjRef CreateObjRef(Type requestedType); public virtual bool Equals(object obj); public virtual bool GetBoolean(int i); public virtual byte GetByte(int i); public virtual long GetBytes(int i, long dataIndex, byte[] buffer, int bufferIndex, int length); public virtual char GetChar(int i); public virtual long GetChars(int i, long dataIndex, char[] buffer, int bufferIndex, int length); public virtual System.Data.IDataReader GetData(int i); public virtual string GetDataTypeName(int i); public virtual DateTime GetDateTime(int i); public virtual Decimal GetDecimal(int i); public virtual double GetDouble(int i); public virtual Type GetFieldType(int i); public virtual float GetFloat(int i); public virtual Guid GetGuid(int i); public virtual int GetHashCode(); public virtual short GetInt16(int i); public virtual int GetInt32(int i); public virtual long GetInt64(int i); public virtual object GetLifetimeService(); public virtual string GetName(int i); public virtual int GetOrdinal(string name); public virtual System.Data.DataTable GetSchemaTable(); public System.Data.SqlTypes.SqlBinary GetSqlBinary(int i); public System.Data.SqlTypes.SqlBoolean GetSqlBoolean(int i); public System.Data.SqlTypes.SqlByte GetSqlByte(int i); public System.Data.SqlTypes.SqlDateTime GetSqlDateTime(int i); public System.Data.SqlTypes.SqlDecimal GetSqlDecimal(int i); public System.Data.SqlTypes.SqlDouble GetSqlDouble(int i); public System.Data.SqlTypes.SqlGuid GetSqlGuid(int i); public System.Data.SqlTypes.SqlInt16 GetSqlInt16(int i); public System.Data.SqlTypes.SqlInt32 GetSqlInt32(int i); public System.Data.SqlTypes.SqlInt64 GetSqlInt64(int i); public System.Data.SqlTypes.SqlMoney GetSqlMoney(int i); public System.Data.SqlTypes.SqlSingle GetSqlSingle(int i); public System.Data.SqlTypes.SqlString GetSqlString(int i); public object GetSqlValue(int i); public int GetSqlValues(object[] values); public virtual string GetString(int i); public Type GetType(); public virtual object GetValue(int i); public virtual int GetValues(object[] values); public virtual object InitializeLifetimeService(); public virtual bool IsDBNull(int i); public virtual bool NextResult(); public virtual bool Read(); public virtual string ToString(); } // end of System.Data.SqlClient.SqlDataReader
public sealed class System.Data.SqlClient.SqlDataReader :
MarshalByRefObject,
System.Collections.IEnumerable,
System.Data.IDataReader,
IDisposable,
System.Data.IDataRecord
{ // Fields // Constructors // Properties
public int Depth { virtual get; }
public int FieldCount { virtual get; }
public bool IsClosed { virtual get; }
public object this[ string name ] { virtual get; }
public object this[ int i ] { virtual get; }
public int RecordsAffected { virtual get; } // Methods
public virtual void Close();
public virtual System.Runtime.Remoting.ObjRef CreateObjRef(Type requestedType);
public virtual bool Equals(object obj);
public virtual bool GetBoolean(int i);
public virtual byte GetByte(int i);
public virtual long GetBytes(int i, long dataIndex, byte[] buffer, int bufferIndex, int length);
public virtual char GetChar(int i);
public virtual long GetChars(int i, long dataIndex, char[] buffer, int bufferIndex, int length);
public virtual System.Data.IDataReader GetData(int i);
public virtual string GetDataTypeName(int i);
public virtual DateTime GetDateTime(int i);
public virtual Decimal GetDecimal(int i);
public virtual double GetDouble(int i);
public virtual Type GetFieldType(int i);
public virtual float GetFloat(int i);
public virtual Guid GetGuid(int i);
public virtual int GetHashCode();
public virtual short GetInt16(int i);
public virtual int GetInt32(int i);
public virtual long GetInt64(int i);
public virtual object GetLifetimeService();
public virtual string GetName(int i);
public virtual int GetOrdinal(string name);
public virtual System.Data.DataTable GetSchemaTable();
public System.Data.SqlTypes.SqlBinary GetSqlBinary(int i);
public System.Data.SqlTypes.SqlBoolean GetSqlBoolean(int i);
public System.Data.SqlTypes.SqlByte GetSqlByte(int i);
public System.Data.SqlTypes.SqlDateTime GetSqlDateTime(int i);
public System.Data.SqlTypes.SqlDecimal GetSqlDecimal(int i);
public System.Data.SqlTypes.SqlDouble GetSqlDouble(int i);
public System.Data.SqlTypes.SqlGuid GetSqlGuid(int i);
public System.Data.SqlTypes.SqlInt16 GetSqlInt16(int i);
public System.Data.SqlTypes.SqlInt32 GetSqlInt32(int i);
public System.Data.SqlTypes.SqlInt64 GetSqlInt64(int i);
public System.Data.SqlTypes.SqlMoney GetSqlMoney(int i);
public System.Data.SqlTypes.SqlSingle GetSqlSingle(int i);
public System.Data.SqlTypes.SqlString GetSqlString(int i);
public object GetSqlValue(int i);
public int GetSqlValues(object[] values);
public virtual string GetString(int i);
public Type GetType();
public virtual object GetValue(int i);
public virtual int GetValues(object[] values);
public virtual object InitializeLifetimeService();
public virtual bool IsDBNull(int i);
public virtual bool NextResult();
public virtual bool Read();
public virtual string ToString();
} // end of System.Data.SqlClient.SqlDataReader
而我写成SqlDataAdapter了。