dataAdapter

public static class DataAdapter
{
/// <summary>
/// DataRow转换成Hash对象
/// </summary>
/// <param name="row"></param>
/// <returns></returns>
public static Dictionary<string,object> DataRowToHashTable(DataRow row)
{
Dictionary<string, object> record = new Dictionary<string, object>();
for (int j = 0; j < row.Table.Columns.Count; j++)// 行数大于0
{
object cellValue = row[j];//cellValue来记录第一行数据，第二行数据
if (cellValue.GetType() == typeof(DBNull))//如果数据不为空
cellValue = null;
record[row.Table.Columns[j].ColumnName] = cellValue;//ColumnName列名
}
return record;
}

/// <summary>
/// DataRow转换成Hash对象
/// </summary>
/// <param name="row"></param>
/// <returns></returns>
public static Dictionary<string, object> DataRowToHashTable(DataRow row, Dictionary<string, object> record)
{
for (int j = 0; j < row.Table.Columns.Count; j++)
{
object cellValue = row[j];
if (cellValue.GetType() == typeof(DBNull))
cellValue = null;
record[row.Table.Columns[j].ColumnName] = cellValue;
}
return record;
}
}

转载于:https://www.cnblogs.com/ZkbFighting/p/7688726.html