How can I convert a able to a list <t>?

From: http://blog.csdn.net/dinglang_2009/article/details/6951138

Yesterday at work, I encountered a problem: I needed to convert the queried datatable data source to a list <t> generic set (known as the T type ). First, I want to use "generic" (isn't that nonsense? All said to be converted to a list <t> generic set), and "reflection" is also used. Haha. Soon I made a small instance and passed the test. Below I will post the code and share it with you. The Code has detailed annotations, so readers can clearly understand my ideas.

First, this is a general conversion class I wrote to complete this operation. It is also the core part of this function:

 

[Java]View plaincopy

1. Using system;
2. Using system. Collections. Generic;
3. Using system. LINQ;
4. Using system. text;
5. Using system. Data;
6. Using system. collections;
7. Using system. reflection;
8. Namespace databletolist
9. {
10. Class converthelper <t> where T: New ()
11. {
12. /// <Summary>
13. /// Use reflection and generics
14. /// </Summary>
15. /// <Param name = "DT"> </param>
16. /// <Returns> </returns>
17. Public static list <t> converttolist (datatable DT)
18. {
20. // Define a set
21. List <t> TS = new list <t> ();
23. // Obtain the model type
24. Type type = typeof (t );
25. // Define a Temporary Variable
26. String tempname = string. empty;
27. // Traverse all data rows in the datatable
28. Foreach (datarow DR in DT. Rows)
29. {
30. T = new T ();
31. // Obtain the public attributes of this model
32. Propertyinfo [] propertys = T. GetType (). getproperties ();
33. // Traverse all attributes of the object
34. Foreach (propertyinfo PI in propertys)
35. {
36. Tempname = pi. Name; // assign the attribute name to the Temporary Variable
37. // Check whether the datatable contains this column (column name = Object attribute name)
38. If (Dt. Columns. Contains (tempname ))
39. {
40. // Determine whether the property has a setter
41. If (! Pi. canwrite) continue; // This attribute cannot be written and jumps out directly.
42. // Value
43. Object value = Dr [tempname];
44. // If it is not empty, the property assigned to the object
45. If (value! = Dbnull. value)
46. Pi. setvalue (T, value, null );
47. }
48. }
49. // Add an object to a generic set
50. TS. Add (t );
51. }
53. Return ts;
55. }
56. }
57. }

The example called in the main method is as follows:

 

 

[CSHARP]View plaincopy

1. Using system;
2. Using system. Collections. Generic;
3. Using system. LINQ;
4. Using system. text;
5. Using system. Data;
6. Using system. collections;
7. Using system. reflection;
10. Namespace databletolist
11. {
12. Class Program
13. {
14. Static void main (string [] ARGs)
15. {
16. Datatable dt = createdt (); // obtain a datatable
17. // Obtain the generic set based on the object type and datatable
18. List <person> List = converthelper <person>. converttolist (DT );
19. // Print the output by traversing the generic set.
20. Foreach (VAR item in List)
21. {
22. Console. writeline (item. tostring ());
23. }
25. Console. readkey ();
26. }
27. /// <Summary>
28. /// Create a able and add data for testing.
29. /// </Summary>
30. /// <Returns> </returns>
31. Public static datatable createdt ()
32. {
34. Datatable dt = new datatable ();
35. DT. Columns. Add (New datacolumn ("ID", typeof (system. int32 )));
36. DT. Columns. Add (New datacolumn ("name", typeof (system. String )));
37. DT. Columns. Add (New datacolumn ("Address", typeof (system. String )));
39. DT. Rows. Add (1, "Dylan", "SZ ");
40. DT. Rows. Add (2, "Jay", "tw ");
41. DT. Rows. Add (3, "CQ", "HK ");
42. Return DT;
43. }
45. }
47. }

The following is the code of a simple custom class:

 

 

[CSHARP]View plaincopy

1. Using system;
2. Using system. Collections. Generic;
3. Using system. LINQ;
4. Using system. text;
6. Namespace databletolist
7. {
8. Class person
9. {
10. Private int ID;
12. Public int ID
13. {
14. Get {return ID ;}
15. Set {id = value ;}
16. }
17. Private string name;
19. Public string name
20. {
21. Get {return name ;}
22. Set {name = value ;}
23. }
24. Private string address;
26. Public String address
27. {
28. Get {return address ;}
29. Set {address = value ;}
30. }
32. Public override string tostring ()
33. {
34. Return "Person:" + ID + "," + name + "," + address;
35. }
36. }
37. }

How can I convert a able to a list <t>?