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
相关资源：dataAdapter用法大全