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;
    }
}