将嵌套数组的类对象转换为DataTable可以通过以下步骤实现:
以下是一个示例代码,演示如何将嵌套数组的类对象转换为DataTable:
using System;
using System.Data;
public class Person
{
public string Name { get; set; }
public int Age { get; set; }
public Address Address { get; set; }
}
public class Address
{
public string Street { get; set; }
public string City { get; set; }
}
public static DataTable ConvertToDataTable(Person[] persons)
{
DataTable dataTable = new DataTable();
// 添加列
dataTable.Columns.Add("Name", typeof(string));
dataTable.Columns.Add("Age", typeof(int));
dataTable.Columns.Add("Street", typeof(string));
dataTable.Columns.Add("City", typeof(string));
// 添加行
foreach (Person person in persons)
{
DataRow row = dataTable.NewRow();
row["Name"] = person.Name;
row["Age"] = person.Age;
row["Street"] = person.Address.Street;
row["City"] = person.Address.City;
dataTable.Rows.Add(row);
}
return dataTable;
}
// 示例用法
Person[] persons = new Person[]
{
new Person { Name = "John", Age = 30, Address = new Address { Street = "123 Main St", City = "New York" } },
new Person { Name = "Jane", Age = 25, Address = new Address { Street = "456 Elm St", City = "Los Angeles" } }
};
DataTable dataTable = ConvertToDataTable(persons);
这样,你就可以将嵌套数组的类对象转换为DataTable,并且可以根据需要进行进一步的数据处理和操作。
领取专属 10元无门槛券
手把手带您无忧上云