C#的DataTable、List、Dictionary、JSON、XML之间的转换

1. DataTable转List

// 创建一个DataTable对象
DataTable dataTable = new DataTable();

// 将DataTable转换为List<DataRow>
List<DataRow> dataList = dataTable.AsEnumerable().ToList();

2. DataTable转Dictionary

// 创建一个DataTable对象
DataTable dataTable = new DataTable();

// 将DataTable转换为Dictionary
Dictionary<string, object> dictionary = dataTable.AsEnumerable()
    .ToDictionary(row => row.Field<string>("KeyColumn"), row => row.Field<object>("ValueColumn"));

3. DataTable转JSON

// 创建一个DataTable对象
DataTable dataTable = new DataTable();

// 将DataTable转换为JSON字符串
string json = JsonConvert.SerializeObject(dataTable, Formatting.Indented);

4. DataTable转XML

// 创建一个DataTable对象
DataTable dataTable = new DataTable();

// 将DataTable转换为XML字符串
string xml = dataTable.GetXml();

5. List转DataTable

// 创建一个List<DataRow>对象
List<DataRow> dataList = new List<DataRow>();

// 将List<DataRow>转换为DataTable
DataTable dataTable = dataList.CopyToDataTable();

6. List转Dictionary

// 创建一个List<KeyValuePair<string, string>>对象
List<KeyValuePair<string, string