标记 DateTable.WriteXml 输出

 代码

 

 1 namespace SQLTableTest
 2 {
 3     public partial class Form1 : Form
 4     {
 5         public Form1()
 6         {
 7             InitializeComponent();
 8         }
 9 
10         private void Form1_Load(object sender, EventArgs e)
11         {
12             SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings[0].ConnectionString);
13             SqlCommand sqlCommand =new SqlCommand("select * from tTestColumns;",conn);
14             SqlDataAdapter dataAdapter =new SqlDataAdapter(sqlCommand);
15             conn.Open();
16             DataTable dt =new DataTable();
17             dt.Locale = System.Globalization.CultureInfo.InvariantCulture;
18             dataAdapter.Fill(dt);
19             dataGridView1.AutoGenerateColumns = true;
20             dataGridView1.AutoResizeColumnHeadersHeight();
21             dataGridView1.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.AllCells );
22             dataGridView1.ReadOnly = true;
23             dataGridView1.DataSource = dt;
24             dt.TableName = "tTestColumns";
25             dt.WriteXml("c:/test/test.xml", XmlWriteMode.WriteSchema);
26 
27             
28         }
29     }
30 }

 

test.xml文件内容：

 1 <?xml version="1.0" standalone="yes"?>
 2 <NewDataSet>
 3   <xs:schema id="NewDataSet" xmlns="" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">
 4     <xs:element name="NewDataSet" msdata:IsDataSet="true" msdata:MainDataTable="tTestColumns" msdata:Locale="">
 5       <xs:complexType>
 6         <xs:choice minOccurs="0" maxOccurs="unbounded">
 7           <xs:element name="tTestColumns" msdata:Locale="">
 8             <xs:complexType>
 9               <xs:sequence>
10                 <xs:element name="id" type="xs:int" minOccurs="0" />
11                 <xs:element name="c_BigInt" type="xs:long" minOccurs="0" />
12                 <xs:element name="c_bit" type="xs:boolean" minOccurs="0" />
13                 <xs:element name="c_varchar50" type="xs:string" minOccurs="0" />
14                 <xs:element name="c_uniquei" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" type="xs:string" minOccurs="0" />
15                 <xs:element name="c_char10" type="xs:string" minOccurs="0" />
16                 <xs:element name="c_date" type="xs:dateTime" minOccurs="0" />
17                 <xs:element name="c_datetime" type="xs:dateTime" minOccurs="0" />
18                 <xs:element name="c_float" type="xs:double" minOccurs="0" />
19                 <xs:element name="c_text" type="xs:string" minOccurs="0" />
20               </xs:sequence>
21             </xs:complexType>
22           </xs:element>
23         </xs:choice>
24       </xs:complexType>
25     </xs:element>
26   </xs:schema>
27   <tTestColumns>
28     <id>1</id>
29     <c_BigInt>1</c_BigInt>
30     <c_bit>true</c_bit>
31     <c_varchar50>测试字符串</c_varchar50>
32     <c_date>2010-01-01T00:00:00+08:00</c_date>
33     <c_datetime>2010-01-01T10:10:10+08:00</c_datetime>
34     <c_float>1.123</c_float>
35     <c_text>测试字符串</c_text>
36   </tTestColumns>
37   <tTestColumns>
38     <id>2</id>
39     <c_BigInt>1234567890</c_BigInt>
40     <c_bit>false</c_bit>
41     <c_varchar50>测试字符串</c_varchar50>
42     <c_date>2010-01-01T00:00:00+08:00</c_date>
43     <c_datetime>2010-01-01T00:00:00+08:00</c_datetime>
44     <c_float>1.123</c_float>
45     <c_text>测试字符串</c_text>
46   </tTestColumns>
47   <tTestColumns>
48     <id>123</id>
49     <c_BigInt>23423</c_BigInt>
50     <c_varchar50>测试字符串</c_varchar50>
51     <c_date>2010-01-01T00:00:00+08:00</c_date>
52     <c_datetime>2010-01-01T00:00:00+08:00</c_datetime>
53     <c_float>1.123</c_float>
54     <c_text>测试字符串</c_text>
55   </tTestColumns>
56   <tTestColumns>
57     <id>1234</id>
58     <c_BigInt>123456</c_BigInt>
59     <c_varchar50 />
60     <c_text>测试字符串</c_text>
61   </tTestColumns>
62 </NewDataSet>

 

 

最后鄙视一下这个编辑器，只有在IE下才能用，什么年代了，发博都这么困难！