| static private JdbcTypeToSqlDbType ( int jdbcType ) : SqlDbType | ||
| jdbcType | int | |
| return | SqlDbType | |
protected internal sealed override void SetParameterDbType(ResultSet res)
{
int dataType = res.getInt("DATA_TYPE");
SqlDbType = SqlConvert.JdbcTypeToSqlDbType(dataType);
JdbcType = dataType;
}
protected override int GetProviderType(int jdbcType)
{
return((int)SqlConvert.JdbcTypeToSqlDbType(jdbcType));
}
// Gets an Object that is a representation of the underlying SqlDbType Variant.
public Object GetSqlValue(int columnIndex)
{
try
{
int jdbcType = ResultsMetaData.getColumnType(columnIndex + 1);
SqlDbType sqlDbType = SqlConvert.JdbcTypeToSqlDbType(jdbcType);
switch (sqlDbType)
{
case SqlDbType.BigInt:
return(GetSqlInt64(columnIndex));
case SqlDbType.Binary:
return(GetSqlBinary(columnIndex));
case SqlDbType.Bit:
return(GetSqlBoolean(columnIndex));
case SqlDbType.Char:
return(GetSqlString(columnIndex));
case SqlDbType.DateTime:
return(GetSqlDateTime(columnIndex));
case SqlDbType.Decimal:
return(GetSqlDecimal(columnIndex));
case SqlDbType.Float:
return(GetSqlDouble(columnIndex));
case SqlDbType.Image:
return(GetSqlBinary(columnIndex));
case SqlDbType.Int:
return(GetSqlInt32(columnIndex));
case SqlDbType.Money:
return(GetSqlDecimal(columnIndex));
case SqlDbType.NChar:
return(GetSqlString(columnIndex));
case SqlDbType.NText:
return(GetSqlString(columnIndex));
case SqlDbType.NVarChar:
return(GetSqlString(columnIndex));
case SqlDbType.Real:
return(GetSqlSingle(columnIndex));
case SqlDbType.UniqueIdentifier:
return(GetSqlGuid(columnIndex));
case SqlDbType.SmallDateTime:
return(GetSqlDateTime(columnIndex));
case SqlDbType.SmallInt:
return(GetSqlInt16(columnIndex));
case SqlDbType.SmallMoney:
return(GetSqlDecimal(columnIndex));
case SqlDbType.Text:
return(GetSqlString(columnIndex));
case SqlDbType.Timestamp:
return(GetSqlDateTime(columnIndex));
case SqlDbType.TinyInt:
return(GetSqlByte(columnIndex));
case SqlDbType.VarBinary:
return(GetSqlBinary(columnIndex));
case SqlDbType.VarChar:
return(GetSqlString(columnIndex));
case SqlDbType.Variant:
return(GetValue(columnIndex));
default:
return(GetValue(columnIndex));
}
}
catch (SQLException exp)
{
throw new Exception(exp.Message);
}
}
