IList convert to datatable

13y18.1kVisual Basic .NET

Hello.

I need to convert Ilist to datatable using below method.But couldnt.Please help .

Here when I select items from checkbox of ultracomboeditor - I need to add them to datatable.So

this.ultraComboEditor1.CheckedListSettings.CheckBoxStyle = CheckStyle.CheckBox;

System.Collections.IList values = null;

values = this.ultraComboEditor1.Value as System.Collections.IList;

my Problem is to convert the ILIst to datatable.

using below method I want to convert IList to datatable.Please show how.

public DataTable ToDataTables(IList data)

{

PropertyDescriptorCollection props = TypeDescriptor.GetProperties(typeof(T));

DataTable table = new DataTable();

for (int i = 0; i < props.Count;i++ )

{

PropertyDescriptor prp = props[i];

table.Columns.Add(prp.Name,prp.PropertyType);

}

object[] values = new object[props.Count];

foreach(T item in data)

{

for (int i = 0; i < values.Length;i++ )

{

values[i] = props[i].GetValue(item);

}

table.Rows.Add(values);

}

return table;

}

Thanks in advance.

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vulpes13y ago
Accepted answer
Here's some sample code which shows how you can use your method to convert an IList to a DataTable:

using System;
using System.ComponentModel;
using System.Collections.Generic;
using System.Data;

public enum Gender
{
Male,
Female
}

public class Person
{
public string Name { get; set; }
public int Age { get; set; }
public Gender Sex {get; set; }
public bool Married { get; set; }
}

class Test
{
static void Main()
{
IList il = new List();
il.Add(new Person(){Name = "David", Age = 35, Sex = Gender.Male, Married = false});
il.Add(new Person(){Name = "Rita", Age = 27, Sex = Gender.Female, Married = true});
Test t = new Test();
DataTable dt = t.ToDataTables(il);

foreach(DataRow dr in dt.Rows)
{
Console.WriteLine("{0} {1} {2} {3}", dr["Name"], dr["Age"], (Gender)dr["Sex"], dr["Married"]);
}

Console.ReadKey();
}

public DataTable ToDataTables(IList data)
{
PropertyDescriptorCollection props = TypeDescriptor.GetProperties(typeof(T));
DataTable table = new DataTable();
for (int i = 0; i < props.Count;i++ )
{
PropertyDescriptor prp = props[i];
table.Columns.Add(prp.Name,prp.PropertyType);
}
object[] values = new object[props.Count];
foreach(T item in data)
{
for (int i = 0; i < values.Length;i++ )
{
values[i] = props[i].GetValue(item);
}
table.Rows.Add(values);
}
return table;
}
}

The output is:

David 35 Male False
Rita 27 Female True

I'm not familiar with the UltraComboEditor but I've been looking at the docs for it and, from what you say, it sounds like it's the CheckedItems property you want to convert to a DataTable.

Now the type of this property is CheckedValueListItemsCollectionand, as far as I can see, it doesn't implement either IList or its generic equivalent.

You'll therefore have to manufacture an IList from it.

What type of objects does your UltraComboEditor actually contain?
13y ago
thanks Vulpes.I did it with CheckedValueListItemsCollection:

CheckedValueListItemsCollection chekedItems = ultraComboEditor1.CheckedItems;

DataTable salestructureTable = new DataTable();
salestructureTable.Columns.Add("Secilenler",typeof(String));

foreach(ValueListItem item in chekedItems )
{
DataRow row_ = salestructureTable.NewRow();
row_[0] = item.DisplayText;
salestructureTable.Rows.Add(row_);
}
Jignesh Trivedi13y ago
hi,

Please check following link it might help you.

http://stackoverflow.com/questions/564366/convert-generic-list-enumerable-to-datatable
http://www.dotnetperls.com/convert-list-datatable