Dataset simple demonstration

Code:

1. Using system;
2. Using system. IO;
3. Using system. Collections. Generic;
4. Using system. LINQ;
5. Using system. Data;
6. Using system. text;
7. Using system. runtime. serialization. formatters. Binary;
9. Namespace simpledataset
10. {
11. Class Program
12. {
13. Static void main (string [] ARGs)
14. {
15. Console. Write ("****** fun with datasets *****/N ");
16. Dataset carsinventoryds = new dataset ("Car inventory ");
17. Carsinventoryds. extendedproperties ["timestamp"] = datetime. now;
18. Carsinventoryds. extendedproperties ["datasetid"] = guid. newguid ();
19. Carsinventoryds. extendedproperties ["company"] = "Intertech training ";
21. Datacolumn caridcolumn = new datacolumn ("carid", typeof (INT ));
22. Caridcolumn. Caption = "Car ID ";
23. Caridcolumn. readonly = true;
24. Caridcolumn. allowdbnull = false;
25. Caridcolumn. Unique = true;
26. Caridcolumn. autoincrement = true;
27. Caridcolumn. autoincrementseed = 0;
28. Caridcolumn. autoincrementstep = 1;
29. Datacolumn carmakecolumn = new datacolumn ("make", typeof (string ));
30. Datacolumn carcolorcolumn = new datacolumn ("color", typeof (string ));
31. Datacolumn carpetnamecolumn = new datacolumn ("petname", typeof (string ));
32. Carpetnamecolumn. Caption = "pet name ";
34. Datatable inventroytable = new datatable ("inventroy ");
35. Inventroytable. Columns. addrange (New datacolumn []
36. {Caridcolumn, carmakecolumn, carcolorcolumn, carpetnamecolumn });
37. Datarow Carrow = inventroytable. newrow ();
38. Inventroytable. primarykey = new datacolumn [] {inventroytable. Columns [0]};
39. Carrow ["make"] = "BMW ";
40. Carrow ["color"] = "black ";
41. Carrow ["petname"] = "Hamlet ";
42. Inventroytable. Rows. Add (Carrow );
43. Carrow = inventroytable. newrow ();
44. Carrow [1] = "Saab ";
45. Carrow [2] = "red ";
46. Carrow [3] = "Sea Breeze ";
47. Inventroytable. Rows. Add (Carrow );
48. Manipulatedatarowstate ();
49. Carsinventoryds. Tables. Add (inventroytable );
51. Datacolumn customidcolumn = new datacolumn ("customid", typeof (INT ));
52. Customidcolumn. Caption = "customid ID ";
53. Customidcolumn. readonly = true;
54. Customidcolumn. allowdbnull = false;
55. Customidcolumn. Unique = true;
56. Customidcolumn. autoincrement = true;
57. Customidcolumn. autoincrementseed = 1987;
58. Customidcolumn. autoincrementstep = 1;
59. Datacolumn firstcolumn = new datacolumn ("firstname", typeof (string ));
60. Datacolumn lastcolumn = new datacolumn ("lastname", typeof (string ));
61. Firstcolumn. Caption = "first name ";
62. Datatable customtable = new datatable ("Custom ");
63. Customtable. Columns. addrange (New datacolumn [] {customidcolumn, firstcolumn, lastcolumn });
64. Datarow customrow = customtable. newrow ();
65. Customtable. primarykey = new datacolumn [] {customtable. Columns [0]};
66. Customrow ["firstname"] = "Xue ";
67. Customrow ["lastname"] = "Yong ";
68. Customtable. Rows. Add (customrow );
69. Customrow = customtable. newrow ();
70. Customrow [1] = "Zhang ";
71. Customrow [2] = "Chuang ";
72. Customtable. Rows. Add (customrow );
73. Manipulatedatarowstate ();
74. Carsinventoryds. Tables. Add (customtable );
75. Printdataset (carsinventoryds );
76. Foreach (datatable DT in carsinventoryds. Tables)
77. Printtable (DT );
78. Datasetasxml (carsinventoryds );
79. Datasetasbinary (carsinventoryds );
81. }
82. Static void datasetasbinary (Dataset carsinventoryds)
83. {
84. Carsinventoryds. remotingformat = serializationformat. Binary;
85. Filestream FS = new filestream ("binarycars. bin", filemode. Create );
86. Binaryformatter bformat = new binaryformatter ();
87. Bformat. serialize (FS, carsinventoryds );
88. FS. Close ();
89. Carsinventoryds. Clear ();
90. FS = new filestream ("binarycars. bin", filemode. Open );
91. Dataset DATA = (Dataset) bformat. deserialize (FS );
92. }
93. Static void datasetasxml (Dataset carsinventoryds)
94. {
95. Carsinventoryds. writexml ("carsdataset. xml ");
96. Carsinventoryds. writexmlschema ("carsdataset. XSD ");
97. Carsinventoryds. Clear ();
98. Carsinventoryds. readxml ("carsdataset. xml ");
99. }
100. Static void printdataset (Dataset DS)
101. {
102. Console. writeline ("datasset is named: {0}", DS. datasetname );
103. Foreach (system. Collections. dictionaryentry de in DS. extendedproperties)
104. {
105. Console. writeline ("Key = {0}, value = {1}", De. Key, De. value );
106. }
107. Foreach (datatable DT in DS. Tables)
108. {
109. Console. writeline ("-> {0} table:", DT. tablename );
110. For (INT curcol = 0; curcol <DT. Columns. Count; curcol ++)
111. {
112. Console. Write (Dt. Columns [curcol]. columnname + "/T ");
113. }
114. Console. writeline ("/n -------------------------------");
116. For (INT currow = 0; currow <DT. Rows. Count; currow ++)
117. {
118. For (INT curcol = 0; curcol <DT. Columns. Count; curcol ++)
119. {
120. Console. Write (Dt. Rows [currow] [curcol]. tostring () + "/T ");
121. }
122. Console. writeline ();
123. }
124. }
125. }
126. Static void printtable (datatable DT)
127. {
128. Datatablereader dtreader = DT. createdatareader ();
129. While (dtreader. Read ())
130. {
131. For (INT I = 0; I <dtreader. fieldcount; I ++)
132. {
133. Console. writeline ("{0}/T", dtreader. getvalue (I). tostring (). Trim ());
134. }
135. Console. writeline ();
136. }
137. Dtreader. Close ();
138. }
139. Private Static void manipulatedatarowstate ()
140. {
141. Datatable temp = new datatable ("Temp ");
142. Temp. Columns. Add (New datacolumn ("tempcolumn", typeof (INT )));
143. Datarow ROW = temp. newrow ();
144. Console. writeline ("after calling newrow (): {0}", row. rowstate );
145. Temp. Rows. Add (ROW );
146. Console. writeline ("after calling rows. Add (): {0}", row. rowstate );
147. Row ["tempcolumn"] = 10;
148. Console. writeline ("after first assignment: {0}", row. rowstate );
149. Temp. acceptchanges ();
150. Console. writeline ("after calling acceptchanges: {0}", row. rowstate );
151. Row ["tempcolumn"] = 11;
152. Console. writeline ("after first modify: {0}", row. rowstate );
153. Temp. Rows [0]. Delete ();
154. Console. writeline ("after calling Delete: {0}", row. rowstate );
156. }
157. }
158. }