How to Convert Lists to DataTables in .NET

Photo by Min An: https://www.pexels.com/photo/silhouette-photo-of-trees-962312/

In .NET, you can easily convert a list into a data table using the following steps:

1. Define a class that represents the structure of your data table. For example:

csharp
public class Person
{
    public int Id { get; set; }
    public string Name { get; set; }
    public int Age { get; set; }
}

2. Create a list of objects of this class type:

List<Person> people = new List<Person>();
people.Add(new Person { Id = 1, Name = "John", Age = 30 });
people.Add(new Person { Id = 2, Name = "Mary", Age = 25 });

3. Create a new data table:

DataTable dataTable = new DataTable();

4. Add columns to the data table:

csharp
dataTable.Columns.Add("Id", typeof(int));
dataTable.Columns.Add("Name", typeof(string));
dataTable.Columns.Add("Age", typeof(int));

5. Loop through the list and add rows to the data table:

foreach (Person person in people)
{
    DataRow row = dataTable.NewRow();
    row["Id"] = person.Id;
    row["Name"] = person.Name;
    row["Age"] = person.Age;
    dataTable.Rows.Add(row);
}

6. You can now use the dataTable object as a regular data table in your .NET application.

This method can be useful when working with data that needs to be displayed or processed in a tabular format, such as when working with databases or when generating reports.