DataSet dataSet = DbHelperSQL.Query(sql);//数据表查询
DataTable dataTable = dataSet.table[0];//获取DataTable
public static Dictionary<string, object> DataTableToDictionary(DataTable dataTable)
{
Dictionary<string, object> result = new Dictionary<string, object>();
if (dataTable != null)
{
foreach (DataRow dataRow in dataTable.Rows)
{
foreach (DataColumn dataColumn in dataTable.Columns)
{
result.Add(dataColumn.ColumnName, dataRow[dataColumn].ToString());
}
}
}
else
{
result = null;
}
return result;
}