2 // System.Data.SqlClient.SqlDataReader
5 // Konstantin Triger <kostat@mainsoft.com>
6 // Boris Kirzner <borisk@mainsoft.com>
8 // (C) 2005 Mainsoft Corporation (http://www.mainsoft.com)
12 // Permission is hereby granted, free of charge, to any person obtaining
13 // a copy of this software and associated documentation files (the
14 // "Software"), to deal in the Software without restriction, including
15 // without limitation the rights to use, copy, modify, merge, publish,
16 // distribute, sublicense, and/or sell copies of the Software, and to
17 // permit persons to whom the Software is furnished to do so, subject to
18 // the following conditions:
20 // The above copyright notice and this permission notice shall be
21 // included in all copies or substantial portions of the Software.
23 // THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND,
24 // EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF
25 // MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND
26 // NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE
27 // LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION
28 // OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION
29 // WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
32 using System.Data.SqlTypes;
33 using System.Data.ProviderBase;
37 namespace System.Data.SqlClient
39 public class SqlDataReader : AbstractDataReader
44 internal SqlDataReader(SqlCommand command) : base(command)
48 #endregion // Constructors
52 #endregion // Properties
56 protected sealed override SystemException CreateException(string message, SQLException e)
58 return new SqlException(message, e, (SqlConnection)_command.Connection);
61 protected sealed override SystemException CreateException(java.io.IOException e)
63 return new SqlException(e, (SqlConnection)_command.Connection);
66 public override String GetDataTypeName(int columnIndex)
69 string jdbcTypeName = Results.getMetaData().getColumnTypeName(columnIndex + 1);
71 return SqlConvert.JdbcTypeNameToDbTypeName(jdbcTypeName);
73 catch (SQLException e) {
74 throw CreateException(e);
78 protected override int GetProviderType(int jdbcType)
80 return (int)SqlConvert.JdbcTypeToSqlDbType(jdbcType);
83 // Gets the value of the specified column as a SqlBinary.
84 public SqlBinary GetSqlBinary(int columnIndex)
86 byte[] bytes = GetBytes(columnIndex);
87 if(IsDBNull(columnIndex)) {
88 return SqlBinary.Null;
91 return new SqlBinary(bytes);
95 // Gets the value of the specified column as a SqlBoolean.
96 public SqlBoolean GetSqlBoolean(int columnIndex)
98 bool boolean = GetBoolean(columnIndex);
99 if(IsDBNull(columnIndex)) {
100 return SqlBoolean.Null;
103 return new SqlBoolean(boolean);
107 // Gets the value of the specified column as a SqlByte.
108 public SqlByte GetSqlByte(int columnIndex)
110 byte byt = GetByte(columnIndex);
111 if(IsDBNull(columnIndex)) {
115 return new SqlByte(byt);
121 public virtual SqlBytes GetSqlBytes (int columnIndex)
123 byte [] bytes = GetBytes (columnIndex);
124 if (IsDBNull (columnIndex)) {
125 return SqlBytes.Null;
128 return new SqlBytes (bytes);
132 public virtual SqlChars GetSqlChars (int columnIndex)
134 SqlString sqlStr = GetSqlString (columnIndex);
136 return SqlChars.Null;
139 return new SqlChars (sqlStr);
143 [MonoNotSupported("SqlXml is not fully implemented")]
144 public virtual SqlXml GetSqlXml (int columnIndex)
146 throw new NotImplementedException ();
151 // Gets the value of the specified column as a SqlDecimal.
152 public SqlDecimal GetSqlDecimal(int columnIndex)
154 decimal dec = GetDecimal(columnIndex);
155 if(IsDBNull(columnIndex)) {
156 return SqlDecimal.Null;
159 return new SqlDecimal(dec);
163 // Gets the value of the specified column as a SqlDateTime.
164 public SqlDateTime GetSqlDateTime(int columnIndex)
166 DateTime dateTime = GetDateTime(columnIndex);
167 if(IsDBNull(columnIndex)) {
168 return SqlDateTime.Null;
171 return new SqlDateTime(dateTime);
175 // Gets the value of the specified column as a SqlDouble.
176 public SqlDouble GetSqlDouble(int columnIndex)
178 double doubl = GetDouble(columnIndex);
179 if(IsDBNull(columnIndex)) {
180 return SqlDouble.Null;
183 return new SqlDouble(doubl);
187 // Gets the value of the specified column as a SqlInt16.
188 public SqlInt16 GetSqlInt16(int columnIndex)
190 short s = GetInt16(columnIndex);
191 if(IsDBNull(columnIndex)) {
192 return SqlInt16.Null;
195 return new SqlInt16(s);
199 // Gets the value of the specified column as a SqlInt32.
200 public SqlInt32 GetSqlInt32(int columnIndex)
202 int i = GetInt32(columnIndex);
203 if(IsDBNull(columnIndex)) {
204 return SqlInt32.Null;
207 return new SqlInt32(i);
211 // Gets the value of the specified column as a SqlInt64.
212 public SqlInt64 GetSqlInt64(int columnIndex)
214 long l = GetInt64(columnIndex);
215 if(IsDBNull(columnIndex)) {
216 return SqlInt64.Null;
219 return new SqlInt64(l);
223 // Gets the value of the specified column as a SqlMoney.
224 public SqlMoney GetSqlMoney(int columnIndex)
226 decimal dec = GetDecimal(columnIndex);
227 if(IsDBNull(columnIndex)) {
228 return SqlMoney.Null;
231 return new SqlMoney(dec);
235 // Gets the value of the specified column as a SqlSingle.
236 public SqlSingle GetSqlSingle(int columnIndex)
238 float f = GetFloat(columnIndex);
239 if(IsDBNull(columnIndex)) {
240 return SqlSingle.Null;
243 return new SqlSingle(f);
247 // Gets the value of the specified column as a SqlString.
248 public SqlString GetSqlString(int columnIndex)
250 string str = GetString(columnIndex);
251 if(IsDBNull(columnIndex)) {
252 return SqlString.Null;
255 return new SqlString(str);
259 // Gets the value of the specified column as a SqlGuid.
260 public SqlGuid GetSqlGuid(int columnIndex)
262 object obj = GetValue(columnIndex);
263 if(IsDBNull(columnIndex)) {
268 return new SqlGuid((byte[])obj);
271 return new SqlGuid((string)obj);
276 // Gets all the attribute columns in the current row.
277 public int GetSqlValues(Object[] values)
279 int columnCount = FieldCount;
281 for (; i < values.Length && i < columnCount; i++) {
282 values[i] = GetSqlValue(i);
287 // Gets an Object that is a representation of the underlying SqlDbType Variant.
288 public Object GetSqlValue(int columnIndex)
291 int jdbcType = ResultsMetaData.getColumnType(columnIndex + 1);
292 SqlDbType sqlDbType = SqlConvert.JdbcTypeToSqlDbType(jdbcType);
295 case SqlDbType.BigInt : return GetSqlInt64(columnIndex);
296 case SqlDbType.Binary : return GetSqlBinary(columnIndex);
297 case SqlDbType.Bit : return GetSqlBoolean(columnIndex);
298 case SqlDbType.Char : return GetSqlString(columnIndex);
299 case SqlDbType.DateTime : return GetSqlDateTime(columnIndex);
300 case SqlDbType.Decimal : return GetSqlDecimal(columnIndex);
301 case SqlDbType.Float : return GetSqlDouble(columnIndex);
302 case SqlDbType.Image : return GetSqlBinary(columnIndex);
303 case SqlDbType.Int : return GetSqlInt32(columnIndex);
304 case SqlDbType.Money : return GetSqlDecimal(columnIndex);
305 case SqlDbType.NChar : return GetSqlString(columnIndex);
306 case SqlDbType.NText : return GetSqlString(columnIndex);
307 case SqlDbType.NVarChar : return GetSqlString(columnIndex);
308 case SqlDbType.Real : return GetSqlSingle(columnIndex);
309 case SqlDbType.UniqueIdentifier : return GetSqlGuid(columnIndex);
310 case SqlDbType.SmallDateTime : return GetSqlDateTime(columnIndex);
311 case SqlDbType.SmallInt : return GetSqlInt16(columnIndex);
312 case SqlDbType.SmallMoney : return GetSqlDecimal(columnIndex);
313 case SqlDbType.Text : return GetSqlString(columnIndex);
314 case SqlDbType.Timestamp : return GetSqlDateTime(columnIndex);
315 case SqlDbType.TinyInt : return GetSqlByte(columnIndex);
316 case SqlDbType.VarBinary : return GetSqlBinary(columnIndex);
317 case SqlDbType.VarChar : return GetSqlString(columnIndex);
318 case SqlDbType.Variant : return GetValue(columnIndex);
319 default : return GetValue(columnIndex);
322 catch (SQLException exp) {
323 throw new Exception(exp.Message);
328 protected bool IsCommandBehavior (CommandBehavior condition)
330 return (_command.Behavior & condition) == condition;
333 #endregion // Methods