Monday, August 29, 2005
Converting Class Array to DataTable
//Variable Declarations
private DataTable dtTemp;
private static void FillData(PropertyInfo[] properties, DataTable dt, Object o)
{
DataRow dr = dt.NewRow();
foreach(PropertyInfo pi in properties)
dr[pi.Name] = pi.GetValue(o, null);
dt.Rows.Add(dr);
}
//All the Properties for the class array are converted to columns. We can always add a
//condition to include required columns alone.
private static DataTable CreateDataTable(PropertyInfo[] properties)
{
DataTable dt = new DataTable();
DataColumn dc = null;
foreach(PropertyInfo pi in properties)
{
dc = new DataColumn();
dc.ColumnName = pi.Name;
dc.DataType = pi.PropertyType;
dt.Columns.Add(dc);
}
return dt;
}
public static DataTable ConvertToDataTable(Object[] array)
{
PropertyInfo[] properties = array.GetType().GetElementType().GetProperties();
DataTable dt = CreateDataTable(properties);
if (array.Length != 0)
{
foreach(object o in array)
FillData(properties, dt, o);
}
return dt;
}
//Call like this
//Convert the Class Object Array to DataTable
dtTemp = ConvertToDataTable(clsData);
Comments:
private DataTable dtTemp;
private static void FillData(PropertyInfo[] properties, DataTable dt, Object o)
{
DataRow dr = dt.NewRow();
foreach(PropertyInfo pi in properties)
dr[pi.Name] = pi.GetValue(o, null);
dt.Rows.Add(dr);
}
//All the Properties for the class array are converted to columns. We can always add a
//condition to include required columns alone.
private static DataTable CreateDataTable(PropertyInfo[] properties)
{
DataTable dt = new DataTable();
DataColumn dc = null;
foreach(PropertyInfo pi in properties)
{
dc = new DataColumn();
dc.ColumnName = pi.Name;
dc.DataType = pi.PropertyType;
dt.Columns.Add(dc);
}
return dt;
}
public static DataTable ConvertToDataTable(Object[] array)
{
PropertyInfo[] properties = array.GetType().GetElementType().GetProperties();
DataTable dt = CreateDataTable(properties);
if (array.Length != 0)
{
foreach(object o in array)
FillData(properties, dt, o);
}
return dt;
}
//Call like this
//Convert the Class Object Array to DataTable
dtTemp = ConvertToDataTable(clsData);
posted by Kannan Meiappan : 8:31 PM
Valuable method for convert object array into datatable.Previously i used little bit complex method.Thanx a lot.
rgs chandima
rgs chandima
posted by 
Chandima Wijekoon : 10:11 PM
Chandima Wijekoon : 10:11 PM
Thanks Kannan for taking the time to figure this out and post it online.
posted by Unknown : 3:20 PM
Unknown : 3:20 PM
Es ist schade, dass ich mich jetzt nicht aussprechen kann - ist erzwungen, wegzugehen. Aber ich werde befreit werden - unbedingt werde ich schreiben dass ich denke. viagra kaufen cialis rezeptfrei [url=http//t7-isis.org]levitra bestellen[/url]
posted by 
: 9:14 AM
: 9:14 AM
Wow, nice post,there are many person searching about that now they will find enough resources by your post.Thank you for sharing to us.Please one more post about that..
posted by buy xanax : 9:54 AM
buy xanax : 9:54 AM
That is very good comment you shared.Thank you so much that for you shared those things with us.Im wishing you to carry on with ur achivments.All the best.
posted by viagra how it works : 8:21 PM
viagra how it works : 8:21 PM
houston dating service http://loveepicentre.com/testimonials.php list of radioactive dating techniques
posted by : 12:26 PM
: 12:26 PM
free ebook dictionary download http://audiobookscollection.co.uk/fr/Scattering-Theory/p192819/ download power of full engagement ebook [url=http://audiobookscollection.co.uk/de/Web-Development-With-Sas-by-Example/p106305/]ebook shannon butcher[/url] melissa de la cruz ebook
posted by : 1:14 AM
: 1:14 AM
ebook heliodorus ethiopian http://audiobooksplanet.co.uk/Rediscovery-A-Novel-of-Darkover/p225939/ private placement memo ebook shareware trial [url=http://audiobooksplanet.co.uk/Omar-Al-Zabir/m94709/]certified protection professional ebook[/url] ebook dictionary free download
posted by : 6:09 PM
: 6:09 PM
[url=http://certifiedpharmacy.co.uk/products/omnicef.htm][img]http://onlinemedistore.com/12.jpg[/img][/url]
chattanooga pharmacy technician http://certifiedpharmacy.co.uk/products/abana.htm internet pharmacy bulletin boiards [url=http://certifiedpharmacy.co.uk/catalogue/x.htm]pharmacy phone[/url]
katwijk pharmacy http://certifiedpharmacy.co.uk/categories/anti-herpes.htm inhouse pharmacy sumatriptan imigran imitrex tablets [url=http://certifiedpharmacy.co.uk/products/tretinoin-cream-0-05-.htm]tretinoin cream 0 05 [/url]
pennsylvania pharmacy leglisltion http://certifiedpharmacy.co.uk/products/evista.htm document control procedurein community pharmacy [url=http://certifiedpharmacy.co.uk/categories/weight-loss.htm]cals pharmacy snowbords[/url]
pharmacy degree online http://certifiedpharmacy.co.uk/products/differin.htm pharmacy requirements [url=http://certifiedpharmacy.co.uk/products/diamox.htm]diamox[/url]
chattanooga pharmacy technician http://certifiedpharmacy.co.uk/products/abana.htm internet pharmacy bulletin boiards [url=http://certifiedpharmacy.co.uk/catalogue/x.htm]pharmacy phone[/url]
katwijk pharmacy http://certifiedpharmacy.co.uk/categories/anti-herpes.htm inhouse pharmacy sumatriptan imigran imitrex tablets [url=http://certifiedpharmacy.co.uk/products/tretinoin-cream-0-05-.htm]tretinoin cream 0 05 [/url]
pennsylvania pharmacy leglisltion http://certifiedpharmacy.co.uk/products/evista.htm document control procedurein community pharmacy [url=http://certifiedpharmacy.co.uk/categories/weight-loss.htm]cals pharmacy snowbords[/url]
pharmacy degree online http://certifiedpharmacy.co.uk/products/differin.htm pharmacy requirements [url=http://certifiedpharmacy.co.uk/products/diamox.htm]diamox[/url]
posted by : 8:07 PM
: 8:07 PM
[url=http://certifiedpharmacy.co.uk/categories/stop-smoking.htm][img]http://onlinemedistore.com/1.jpg[/img][/url]
cvs pharmacy chester nj http://certifiedpharmacy.co.uk/products/terramycin.htm pharmacy technician training online [url=http://certifiedpharmacy.co.uk/products/zyvox.htm]what exam to take for pharmacy technician[/url]
caremark specialty pharmacy ma http://certifiedpharmacy.co.uk/products/aceon.htm jefferson pharmacy philadelphia [url=http://certifiedpharmacy.co.uk/products/arava.htm]arava[/url]
advanced compounding pharmacy http://certifiedpharmacy.co.uk/products/oxytrol.htm inventory management pharmacy [url=http://certifiedpharmacy.co.uk/catalogue/e.htm]denmark pharmacy history[/url]
pharmacy concerns http://certifiedpharmacy.co.uk/products/purim.htm myriad pharmacy [url=http://certifiedpharmacy.co.uk/products/glucophage.htm]glucophage[/url]
cvs pharmacy chester nj http://certifiedpharmacy.co.uk/products/terramycin.htm pharmacy technician training online [url=http://certifiedpharmacy.co.uk/products/zyvox.htm]what exam to take for pharmacy technician[/url]
caremark specialty pharmacy ma http://certifiedpharmacy.co.uk/products/aceon.htm jefferson pharmacy philadelphia [url=http://certifiedpharmacy.co.uk/products/arava.htm]arava[/url]
advanced compounding pharmacy http://certifiedpharmacy.co.uk/products/oxytrol.htm inventory management pharmacy [url=http://certifiedpharmacy.co.uk/catalogue/e.htm]denmark pharmacy history[/url]
pharmacy concerns http://certifiedpharmacy.co.uk/products/purim.htm myriad pharmacy [url=http://certifiedpharmacy.co.uk/products/glucophage.htm]glucophage[/url]
posted by : 7:04 PM
: 7:04 PM
dating blueridge guitar [url=http://freeinternetdating.info/romantic/romantic-call]romantic call[/url] glass door knob dating
liberal dating http://freeinternetdating.info/brides/princess-warrior-brides-from-another-planet jopline dating
thinkers and feelers dating [url=http://freeinternetdating.info/socialnetwork/browning-logo-myspace-layouts]cougar women dating[/url] d s dating sites
liberal dating http://freeinternetdating.info/brides/princess-warrior-brides-from-another-planet jopline dating
thinkers and feelers dating [url=http://freeinternetdating.info/socialnetwork/browning-logo-myspace-layouts]cougar women dating[/url] d s dating sites
posted by : 10:07 PM
: 10:07 PM
dating websites for sale http://loveepicentre.com/taketour/ american girls for dating
torrent double your dating [url=http://loveepicentre.com/articles/]forensic science carbon dating autopsy[/url] porn tube wives dating
adult dating swinging oregon [url=http://loveepicentre.com/advice/]sex dating in romeoville illinois[/url] totally free no payment dating sight [url=http://loveepicentre.com/user/Akron/]Akron[/url] dating sims new websites
Post a Comment
torrent double your dating [url=http://loveepicentre.com/articles/]forensic science carbon dating autopsy[/url] porn tube wives dating
adult dating swinging oregon [url=http://loveepicentre.com/advice/]sex dating in romeoville illinois[/url] totally free no payment dating sight [url=http://loveepicentre.com/user/Akron/]Akron[/url] dating sims new websites
posted by : 12:48 AM
: 12:48 AM
