2 // System.Data.SqlClient.SqlDataReader
\r
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;
36 namespace System.Data.SqlClient
38 public class SqlDataReader : System.Data.Common.AbstractDataReader
43 internal SqlDataReader(SqlCommand command) : base(command)
47 #endregion // Constructors
51 #endregion // Properties
55 protected override SystemException CreateException(string message, SQLException e)
\r
57 return new SqlException(message, e, (SqlConnection)_command.Connection);
\r
60 protected override SystemException CreateException(java.io.IOException e)
\r
62 return new SqlException(e, (SqlConnection)_command.Connection);
\r
65 public override String GetDataTypeName(int columnIndex)
\r
68 string jdbcTypeName = Results.getMetaData().getColumnTypeName(columnIndex + 1);
\r
70 return SqlConvert.JdbcTypeNameToDbTypeName(jdbcTypeName);
\r
72 catch (SQLException e) {
\r
73 throw CreateException(e);
\r
77 protected override int GetProviderType(int jdbcType)
79 return (int)SqlConvert.JdbcTypeToSqlDbType(jdbcType);
82 // Gets the value of the specified column as a SqlBinary.
83 public SqlBinary GetSqlBinary(int columnIndex)
85 byte[] bytes = GetBytes(columnIndex);
86 if(IsDBNull(columnIndex)) {
87 return SqlBinary.Null;
90 return new SqlBinary(bytes);
94 // Gets the value of the specified column as a SqlBoolean.
95 public SqlBoolean GetSqlBoolean(int columnIndex)
97 bool boolean = GetBoolean(columnIndex);
98 if(IsDBNull(columnIndex)) {
99 return SqlBoolean.Null;
102 return new SqlBoolean(boolean);
\r
106 // Gets the value of the specified column as a SqlByte.
107 public SqlByte GetSqlByte(int columnIndex)
109 byte byt = GetByte(columnIndex);
110 if(IsDBNull(columnIndex)) {
114 return new SqlByte(byt);
\r
119 // Gets the value of the specified column as a SqlDecimal.
120 public SqlDecimal GetSqlDecimal(int columnIndex)
122 decimal dec = GetDecimal(columnIndex);
123 if(IsDBNull(columnIndex)) {
124 return SqlDecimal.Null;
127 return new SqlDecimal(dec);
\r
131 // Gets the value of the specified column as a SqlDateTime.
132 public SqlDateTime GetSqlDateTime(int columnIndex)
134 DateTime dateTime = GetDateTime(columnIndex);
135 if(IsDBNull(columnIndex)) {
136 return SqlDateTime.Null;
139 return new SqlDateTime(dateTime);
\r
143 // Gets the value of the specified column as a SqlDouble.
144 public SqlDouble GetSqlDouble(int columnIndex)
146 double doubl = GetDouble(columnIndex);
147 if(IsDBNull(columnIndex)) {
148 return SqlDouble.Null;
151 return new SqlDouble(doubl);
\r
155 // Gets the value of the specified column as a SqlInt16.
156 public SqlInt16 GetSqlInt16(int columnIndex)
158 short s = GetInt16(columnIndex);
159 if(IsDBNull(columnIndex)) {
160 return SqlInt16.Null;
163 return new SqlInt16(s);
\r
167 // Gets the value of the specified column as a SqlInt32.
168 public SqlInt32 GetSqlInt32(int columnIndex)
170 int i = GetInt32(columnIndex);
171 if(IsDBNull(columnIndex)) {
172 return SqlInt32.Null;
175 return new SqlInt32(i);
\r
179 // Gets the value of the specified column as a SqlInt64.
180 public SqlInt64 GetSqlInt64(int columnIndex)
182 long l = GetInt64(columnIndex);
183 if(IsDBNull(columnIndex)) {
184 return SqlInt64.Null;
187 return new SqlInt64(l);
\r
191 // Gets the value of the specified column as a SqlMoney.
192 public SqlMoney GetSqlMoney(int columnIndex)
194 decimal dec = GetDecimal(columnIndex);
195 if(IsDBNull(columnIndex)) {
196 return SqlMoney.Null;
199 return new SqlMoney(dec);
203 // Gets the value of the specified column as a SqlSingle.
204 public SqlSingle GetSqlSingle(int columnIndex)
206 float f = GetFloat(columnIndex);
207 if(IsDBNull(columnIndex)) {
208 return SqlSingle.Null;
211 return new SqlSingle(f);
\r
215 // Gets the value of the specified column as a SqlString.
216 public SqlString GetSqlString(int columnIndex)
218 string str = GetString(columnIndex);
219 if(IsDBNull(columnIndex)) {
220 return SqlString.Null;
223 return new SqlString(str);
\r
227 // Gets the value of the specified column as a SqlGuid.
228 public SqlGuid GetSqlGuid(int columnIndex)
230 object obj = GetValue(columnIndex);
231 if(IsDBNull(columnIndex)) {
235 if (obj is byte[]) {
\r
236 return new SqlGuid((byte[])obj);
\r
239 return new SqlGuid((string)obj);
\r
244 // Gets all the attribute columns in the current row.
245 public int GetSqlValues(Object[] values)
247 int columnCount = FieldCount;
249 for (; i < values.Length && i < columnCount; i++) {
250 values[i] = GetSqlValue(i);
255 // Gets an Object that is a representation of the underlying SqlDbType Variant.
256 public Object GetSqlValue(int columnIndex)
259 int jdbcType = ResultsMetaData.getColumnType(columnIndex + 1);
260 SqlDbType sqlDbType = SqlConvert.JdbcTypeToSqlDbType(jdbcType);
262 switch (sqlDbType) {
\r
263 case SqlDbType.BigInt : return GetSqlInt64(columnIndex);
\r
264 case SqlDbType.Binary : return GetSqlBinary(columnIndex);
\r
265 case SqlDbType.Bit : return GetSqlBoolean(columnIndex);
\r
266 case SqlDbType.Char : return GetSqlString(columnIndex);
\r
267 case SqlDbType.DateTime : return GetSqlDateTime(columnIndex);
\r
268 case SqlDbType.Decimal : return GetSqlDecimal(columnIndex);
\r
269 case SqlDbType.Float : return GetSqlDouble(columnIndex);
\r
270 case SqlDbType.Image : return GetSqlBinary(columnIndex);
\r
271 case SqlDbType.Int : return GetSqlInt32(columnIndex);
\r
272 case SqlDbType.Money : return GetSqlDecimal(columnIndex);
\r
273 case SqlDbType.NChar : return GetSqlString(columnIndex);
\r
274 case SqlDbType.NText : return GetSqlString(columnIndex);
\r
275 case SqlDbType.NVarChar : return GetSqlString(columnIndex);
\r
276 case SqlDbType.Real : return GetSqlSingle(columnIndex);
\r
277 case SqlDbType.UniqueIdentifier : return GetSqlGuid(columnIndex);
\r
278 case SqlDbType.SmallDateTime : return GetSqlDateTime(columnIndex);
\r
279 case SqlDbType.SmallInt : return GetSqlInt16(columnIndex);
\r
280 case SqlDbType.SmallMoney : return GetSqlDecimal(columnIndex);
\r
281 case SqlDbType.Text : return GetSqlString(columnIndex);
\r
282 case SqlDbType.Timestamp : return GetSqlDateTime(columnIndex);
\r
283 case SqlDbType.TinyInt : return GetSqlByte(columnIndex);
\r
284 case SqlDbType.VarBinary : return GetSqlBinary(columnIndex);
\r
285 case SqlDbType.VarChar : return GetSqlString(columnIndex);
\r
286 case SqlDbType.Variant : return GetValue(columnIndex);
\r
287 default : return GetValue(columnIndex);
\r
290 catch (SQLException exp) {
291 throw new Exception(exp.Message);
295 #endregion // Methods