C # directly create a able and add data to it (custom datatable)

Http://blog.csdn.net/diyoosjtu/article/details/7585111

 

[CSHARP]
View plaincopyprint?

1. Datatable dt = new datatable ("cart ");
2. Datacolumn DC1 = new datacolumn ("prizename", type. GetType ("system. String "));
3. Datacolumn DC2 = new datacolumn ("point", type. GetType ("system. int16 "));
4. Datacolumn DC3 = new datacolumn ("Number", type. GetType ("system. int16 "));
5. Datacolumn dc4 = new datacolumn ("totalpoint", type. GetType ("system. int64 "));
6. Datacolumn dC5 = new datacolumn ("prizeid", type. GetType ("system. String "));
7. DT. Columns. Add (DC1 );
8. DT. Columns. Add (DC2 );
9. DT. Columns. Add (DC3 );
10. DT. Columns. Add (dc4 );
11. DT. Columns. Add (dC5 );
12. // The above code completes the datatable architecture, but there is no data in it
    
13. For (INT I = 0; I <10; I ++)
14. {
15. Datarow DR = DT. newrow ();
16. Dr ["prizename"] = "doll ";
17. Dr ["point"] = 10;
18. Dr ["Number"] = 1;
19. Dr ["totalpoint"] = 10;
20. Dr ["prizeid"] = "001 ";
21. DT. Rows. Add (DR );
22. }
23. // Fill in 10 identical records
25. Someone will do this.
26. Datarow DR = new datarow ();
27. ..
28. DT. Rows. Add (DR );
29. This is not acceptable, because a datarow must belong to a datatable and cannot be created out of thin air, just as a record must belong to a table.
31. Someone else does this.
32. Datarow DR = DT. newrow ();
33. Dr ["prizename"] = "doll ";
34. Dr ["point"] = 10;
35. Dr ["Number"] = 1;
36. Dr ["totalpoint"] = 10;
37. Dr ["prizeid"] = "001 ";
38. For (INT I = 0; I <10; I ++)
39. {
40. DT. Rows. Add (DR );
41. }
42. This is also wrong, because the datatable already has this datarow, it is like a table that cannot have two identical records, each time newrow ()

 

[CSHARP]
View plaincopyprint?

1. Datatable dt = new datatable ("cart ");
2. Datacolumn DC1 = new datacolumn ("prizename", type. GetType ("system. String "));
3. Datacolumn DC2 = new datacolumn ("point", type. GetType ("system. int16 "));
4. Datacolumn DC3 = new datacolumn ("Number", type. GetType ("system. int16 "));
5. Datacolumn dc4 = new datacolumn ("totalpoint", type. GetType ("system. int64 "));
6. Datacolumn dC5 = new datacolumn ("prizeid", type. GetType ("system. String "));
7. DT. Columns. Add (DC1 );
8. DT. Columns. Add (DC2 );
9. DT. Columns. Add (DC3 );
10. DT. Columns. Add (dc4 );
11. DT. Columns. Add (dC5 );
12. // The above code completes the datatable architecture, but there is no data in it
    
13. For (INT I = 0; I <10; I ++)
14. {
15. Datarow DR = DT. newrow ();
16. Dr ["prizename"] = "doll ";
17. Dr ["point"] = 10;
18. Dr ["Number"] = 1;
19. Dr ["totalpoint"] = 10;
20. Dr ["prizeid"] = "001 ";
21. DT. Rows. Add (DR );
22. }
23. // Fill in 10 identical records
25. Someone will do this.
26. Datarow DR = new datarow ();
27. ..
28. DT. Rows. Add (DR );
29. This is not acceptable, because a datarow must belong to a datatable and cannot be created out of thin air, just as a record must belong to a table.
31. Someone else does this.
32. Datarow DR = DT. newrow ();
33. Dr ["prizename"] = "doll ";
34. Dr ["point"] = 10;
35. Dr ["Number"] = 1;
36. Dr ["totalpoint"] = 10;
37. Dr ["prizeid"] = "001 ";
38. For (INT I = 0; I <10; I ++)
39. {
40. DT. Rows. Add (DR );
41. }
42. This is also wrong, because the datatable already has this datarow, it is like a table that cannot have two identical records, each time newrow ()