How to fill a datatable with List
How can convert a list to a datatable
[Serializable]
public class Item
{
public string Name { get; set; }
public double Price { get; set; }
public string @URL { get; set; }
public Item(string Name, string Price, string @URL)
{
this.Name = Name;
this.Price = Convert.ToDouble(Price);
this.@URL = @URL;
}
public override string ToString()
{
return this.Name;
}
}
I tried using:
static DataTable ConvertToDatatable(List<Item> list)
{
DataTable dt = new DataTable();
dt.Columns.Add("Name");
dt.Columns.Add("Price");
dt.Columns.Add("URL");
foreach (var item in list)
{
dt.Rows.Add(item.Name, Convert.ToString(item.Price), item.URL);
}
return dt;
}
and then tried to add the itemList to the itemTable:
List<Item> itemList = ...
itemTable = ConvertToDatatable(itemList);
itemDataView.DataSource = itemTable;
but i get itemDataView is null
Can anyone help me figure this out?
No comments:
Post a Comment