To generate a datatable based on generic input list with header translation capability and determination of specific members of the list
There is a sample project in the solution, which uses this library and it is totally easy to understand. If you had any problem, let me know.
1- You got a Model as Product like this :
public class Product
{
public Product()
{
}
public Product(int id, string name, string address)
{
Id = id;
Name = name;
Address = address;
}
[Display(Name = "Id", ResourceType = typeof(TranslateResource))]
public int Id { get; set; }
[Display(Name = "Name", ResourceType = typeof(TranslateResource))]
public string Name { get; set; }
[Display(Name = "Address", ResourceType = typeof(TranslateResource))]
public string Address { get; set; }
}
2- You call a method and it have returned a list of product like this
IEnumerable<Procudt> result = myMethod();
3- If you need to convert the result to .net datatable with specific headers, you just need to use .ToDataTable extension of IEnumerable :
var dataTableOverload01 = products.ToDataTable();
4- If you need to specify some of the Prodcut's property as datatable columns, call this overload :
var dataTableOverload03 = products.ToDataTable((Product p) => p.Name, p => p.Address);
5- If you need to translate the datatable column's header with .NET ResourceManager, call this overload :
var dataTableOverload02 = products.ToDataTable(resourceManager);
If you need to translate specific properties in the result datatable, you need to decorate the properties with Display attribute
[Display(Name = "Id", ResourceType = typeof(TranslateResource))]
public int Id { get; set; }