xaml重点代码：

1. <Grid>
   
2. <TextBlock HorizontalAlignment="Left" Margin="10,21,0,0" TextWrapping="Wrap" Text="文本路径： " VerticalAlignment="Top"/>
   
3. <TextBox Name="txtFileName" HorizontalAlignment="Left" Height="23" Margin="79,18,0,0" TextWrapping="Wrap" VerticalAlignment="Top" Width="276"/>
   
4. <Button Name="btnOpen" Content="浏览" HorizontalAlignment="Left" Margin="387,18,0,0" VerticalAlignment="Top" Width="75" Click="btnOpen_Click"/>
   
5. <Button Name="btnImport" Content="文档汇入数据库" HorizontalAlignment="Left" Margin="200,122,0,0" VerticalAlignment="Top" Width="110" Click="btnImport_Click"/>
   
6. <Button Name="btnExport" Content="数据库汇出文档" HorizontalAlignment="Left" Margin="352,122,0,0" VerticalAlignment="Top" Width="110" Click="btnExport_Click"/>
   
7. </Grid>
   

复制代码

xaml.cs重点代码：

1. using System;
   
2. using System.Collections.Generic;
   
3. using System.Configuration;
   
4. using System.Data;
   
5. using System.Data.SqlClient;
   
6. using System.IO;
   
7. using System.Linq;
   
8. using System.Windows;
   
9. using Microsoft.Win32;
   
10. 
    
11. namespace test1
    
12. {
    
13. /// <summary>
    
14. /// case14.xaml 的交互逻辑
    
15. /// </summary>
    
16. public partial class case14 : Window
    
17. {
    
18. public case14()
    
19. {
    
20. InitializeComponent();
    
21. }
    
22. 
    
23. /// <summary>
    
24. /// 浏览按钮方法
    
25. /// </summary>
    
26. /// <param name="sender"></param>
    
27. /// <param name="e"></param>
    
28. private void btnOpen_Click(object sender, RoutedEventArgs e)
    
29. {
    
30. try
    
31. {
    
32. OpenFileDialog ofd = new OpenFileDialog();
    
33. ofd.InitialDirectory = @"C:\Users\mavis\Desktop";
    
34. ofd.Filter = @"TXT 文件|*.txt|所有文件|*.*";
    
35. if (ofd.ShowDialog() == true)
    
36. {
    
37. txtFileName.Text = ofd.FileName;
    
38. }
    
39. }
    
40. catch (Exception ex)
    
41. {
    
42. MessageBox.Show(ex.Message);
    
43. }
    
44. }
    
45. 
    
46. /// <summary>
    
47. /// 文档汇入数据库
    
48. /// </summary>
    
49. /// <param name="sender"></param>
    
50. /// <param name="e"></param>
    
51. private void btnImport_Click(object sender, RoutedEventArgs e)
    
52. {
    
53. try
    
54. {
    
55. if (txtFileName.Text.Trim().Length == 0)
    
56. {
    
57. MessageBox.Show("请先选择要汇入的TXT文档！");
    
58. return;
    
59. }
    
60. string connStr = ConfigurationManager.ConnectionStrings["dbConnStr"].ConnectionString;
    
61. //File.ReadAllLines是把文件一次读取到string集合中
    
62. //对于大的文件用流的方式 FileStream
    
63. //乱码发生在保存和读取的编码不一致的情况下
    
64. //File.ReadLines没有第二个参数的重载是采用UTF8编码
    
65. IEnumerable<string> lines = File.ReadLines(txtFileName.Text.Trim());
    
66. foreach (string line in lines)
    
67. {
    
68. string[] str = line.Split('\t');
    
69. string name = str[0]; //姓名
    
70. int age = Convert.ToInt32(str[1]); //年龄
    
71. bool sex = Convert.ToBoolean(str[2]); //性别
    
72. float height = float.Parse(str[3]); //身高
    
73. float pay = float.Parse(str[4]); //工资
    
74. using (SqlConnection conn = new SqlConnection(connStr))
    
75. {
    
76. conn.Open();
    
77. using (SqlCommand cmd = conn.CreateCommand())
    
78. {
    
79. cmd.CommandText = "INSERT INTO dbo.T_Staff( Name, Age, Sex, Height, Pay )VALUES( @name, @age, @sex, @height, @pay)";
    
80. cmd.Parameters.Add(new SqlParameter("@name", name));
    
81. cmd.Parameters.Add(new SqlParameter("@age", age));
    
82. cmd.Parameters.Add(new SqlParameter("@sex", sex));
    
83. cmd.Parameters.Add(new SqlParameter("@height", height));
    
84. cmd.Parameters.Add(new SqlParameter("@pay", pay));
    
85. cmd.ExecuteNonQuery();
    
86. }
    
87. }
    
88. }
    
89. MessageBox.Show(lines.Count() + "条数据已经成功汇入数据库！");
    
90. }
    
91. catch (Exception ex)
    
92. {
    
93. MessageBox.Show(ex.Message);
    
94. }
    
95. }
    
96. 
    
97. /// <summary>
    
98. /// 数据库汇出文档
    
99. /// </summary>
    
100. /// <param name="sender"></param>
     
101. /// <param name="e"></param>
     
102. private void btnExport_Click(object sender, RoutedEventArgs e)
     
103. {
     
104. try
     
105. {
     
106. if (txtFileName.Text.Trim().Length == 0)
     
107. {
     
108. MessageBox.Show("请先选择要汇入的TXT文档！");
     
109. return;
     
110. }
     
111. string connStr = ConfigurationManager.ConnectionStrings["dbConnStr"].ConnectionString;
     
112. DataSet ds = new DataSet();
     
113. using (SqlConnection conn = new SqlConnection(connStr))
     
114. {
     
115. conn.Open();
     
116. using (SqlCommand cmd = conn.CreateCommand())
     
117. {
     
118. cmd.CommandText = "SELECT * FROM dbo.T_Staff";
     
119. SqlDataAdapter adapter = new SqlDataAdapter(cmd);
     
120. adapter.Fill(ds);
     
121. }
     
122. }
     
123. DataRowCollection rows = ds.Tables[0].Rows;
     
124. string[] str = new string[rows.Count];
     
125. for (int i = 0; i < rows.Count; i++)
     
126. {
     
127. str[i] = rows[i]["Name"].ToString() + "\t" + rows[i]["Age"].ToString() + "\t" + rows[i]["Sex"].ToString() + "\t" + rows[i]["Height"].ToString() + "\t" + rows[i]["Pay"].ToString();
     
128. }
     
129. File.WriteAllLines(txtFileName.Text, str);
     
130. MessageBox.Show("数据库资料汇出到TXT文档成功！");
     
131. }
     
132. catch (Exception ex)
     
133. {
     
134. MessageBox.Show(ex.Message);
     
135. }
     
136. }
     
137. }
     
138. }

复制代码

厉害哟{:soso_e179:}