本文整理汇总了C#中System.Data.Common.DbDataReader.GetValue方法的典型用法代码示例。如果您正苦于以下问题:C# DbDataReader.GetValue方法的具体用法?C# DbDataReader.GetValue怎么用?C# DbDataReader.GetValue使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类System.Data.Common.DbDataReader
的用法示例。
在下文中一共展示了DbDataReader.GetValue方法的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: WorkoutPlan
public WorkoutPlan(DbDataReader reader)
{
_id = reader.GetInt64(0);
_title = reader.GetValue(1).ToString() == "" ? "" : reader.GetString(1);
_period = reader.GetValue(2).ToString() == "" ? (byte)0 : reader.GetByte(2);
_creatorId = reader.GetValue(3).ToString() == "" ? 0 : reader.GetInt64(3);
}
示例2: ReadDouble
public double? ReadDouble(DbDataReader reader, int index)
{
double d = double.NaN;
if (reader.IsDBNull(index))
return 0;
Object obj = reader.GetValue(index);
if (obj.GetType() == typeof(Decimal))
{
d = Decimal.ToDouble((Decimal)obj);
}
else if (obj.GetType() == typeof(double))
{
d = (double)obj;
}
else if (obj.GetType() == typeof(float))
{
d = (float)obj;
}
else if (obj.GetType() == typeof(string))
{
d = double.Parse((string)obj);
}
else
return null;
return d;
}
示例3: Map
public override object Map(DbDataReader dataReader, RowMapperContext context)
{
if (dataReader.IsDBNull(0))
return null;
return _converter(dataReader.GetValue(0));
}
示例4: DynamicEntityValue
public DynamicEntityValue(DbDataReader reader)
{
for(int i = 0; i < reader.FieldCount; i++)
{
this._nameValues.Add(reader.GetName(i), reader.GetValue(i));
}
}
示例5: Print
public static void Print(string sql, DbDataReader reader)
{
log.Info("Results of [" + sql + "]");
string results = "\n";
if (reader.HasRows)
{
for (int j = 0; j < reader.FieldCount; j++)
{
results += reader.GetName(j);
if (j < reader.FieldCount - 1)
{
results += "|";
}
}
results += "\n";
while (reader.Read())
{
for (int i = 0; i < reader.FieldCount; i++)
{
results += reader.GetValue(i);
if (i < reader.FieldCount - 1)
{
results += "|";
}
}
results += "\n";
}
results = results.Substring(0, results.Length - 1);
log.Info(results);
}
}
示例6: Map
public override object Map(DbDataReader dataReader, RowMapperContext context)
{
var arrayType = context.Type.GetElementType();
var array = Array.CreateInstance(arrayType, _posNames.Length);
for (int i = 0; i < _posNames.Length; i++)
{
if (!dataReader.IsDBNull(_posNames[i].Pos))
{
array.SetValue(dataReader.GetValue(_posNames[i].Pos), i);
}
}
return array;
}
示例7: ConvertRowToString
public static string ConvertRowToString(DbDataReader row, StringBuilder headers)
{
var output = new List<string>();
for (var i = 0; i < row.FieldCount; i++)
{
output.Add("" + row.GetValue(i));
}
if (headers.Length == 0)
{
for (var i = 0; i < row.FieldCount; i++)
{
headers.Append(row.GetName(i) + ", ");
}
}
return String.Join(", ", output.ToArray());
}
示例8: GetProjectInfo
protected ProjectInfo_LH GetProjectInfo(DbDataReader reader)
{
ProjectInfo_LH row = new ProjectInfo_LH();
row.Id = Convert.ToInt32(reader.GetValue(reader.GetOrdinal(ProjectInfo_LH.C_id)));
row.Projname = Convert.ToString(reader.GetValue(reader.GetOrdinal(ProjectInfo_LH.C_projName)));
row.Xmdm = Convert.ToInt32(reader.GetValue(reader.GetOrdinal(ProjectInfo_LH.C_xmdm)));
row.Zjdm = Convert.ToInt32(reader.GetValue(reader.GetOrdinal(ProjectInfo_LH.C_zjdm)));
row.Zmdm = Convert.ToInt32(reader.GetValue(reader.GetOrdinal(ProjectInfo_LH.C_zmdm)));
row.Sc = Convert.ToChar(reader.GetValue(reader.GetOrdinal(ProjectInfo_LH.C_sc)));
return row;
}
示例9: DataTable
public DataTable(DbDataReader reader)
{
this.fields = new List<string>();
this.data = new List<object[]>();
for (int i = 0; i < reader.FieldCount; i++)
{
fields.Add(reader.GetName(i));
}
while (reader.Read())
{
object[] values = new object[reader.FieldCount];
for (int i = 0; i < fields.Count; i++)
{
values[i] = reader.GetValue(reader.GetOrdinal(fields[i]));
}
data.Add(values);
}
}
示例10: ReadInt
public int? ReadInt(DbDataReader reader, int index)
{
if (reader.IsDBNull(index))
return 0;
int i;
Object obj = reader.GetValue(index);
if (obj.GetType() == typeof(int) ||
obj.GetType() == typeof(Int16) ||
obj.GetType() == typeof(Int32) ||
obj.GetType() == typeof(Int64))
i = Convert.ToInt32(obj);
else if (obj.GetType() == typeof(string))
i = int.Parse((string)obj);
else
return null;
return i;
}
示例11: CreateRow
private Dictionary<string, object> CreateRow(DbDataReader record, string[] columns) {
Dictionary<string, object> row = new Dictionary<string, object>(StringComparer.Ordinal);
for (int i = 0; i < columns.Length; i++) {
object value = record.GetValue(i);
if (value == DBNull.Value) {
value = null;
}
else {
Type valueType = value.GetType();
if (valueType == typeof(Guid)) {
value = value.ToString();
}
else if (valueType == typeof(DateTime)) {
value = ((DateTime)value).ToString("R", CultureInfo.InvariantCulture);
}
}
row[columns[i]] = value;
}
return row;
}
示例12: MapValue
private bool MapValue(GroupResult<PosName> posName, DbDataReader reader, Func<object, object> converter, object instance, PocoColumn pocoColumn, object defaultValue)
{
if (!reader.IsDBNull(posName.Key.Pos))
{
var value = converter != null ? converter(reader.GetValue(posName.Key.Pos)) : reader.GetValue(posName.Key.Pos);
pocoColumn.SetValue(instance, value);
return true;
}
if (_mappingOntoExistingInstance && defaultValue == null)
{
pocoColumn.SetValue(instance, null);
}
return false;
}
示例13: Donymous
/// <summary>
/// Load all values from DbDataReader
/// </summary>
/// <param name="reader">Reader from which to load all column values</param>
public Donymous(DbDataReader reader)
{
for (int i = 0; i < reader.FieldCount; i++)
this.memberValues[reader.GetName(i)] = reader.IsDBNull(i) ? null : reader.GetValue(i);
}
示例14: GetFromDataReader
public object GetFromDataReader(DbDataReader rset, int index)
{
return rset.GetValue(index) == DBNull.Value ? false : (bool) rset.GetValue(index);
}
示例15: Read
private static IEnumerable<object[]> Read(DbDataReader reader)
{
while (reader.Read())
{
var values = new List<object>();
for (int i = 0; i < reader.FieldCount; i++)
{
values.Add(reader.GetValue(i));
}
yield return values.ToArray();
}
}