`
strugglesMen
  • 浏览: 111525 次
  • 性别: Icon_minigender_2
  • 来自: 杭州
社区版块
存档分类
最新评论

C#读取TXT文件的代码实现

阅读更多
    C#读取TXT文件是如何是实现的呢?本文就向你讲述C#读取TXT文件的实现方法和代码。

    C#读取TXT文件之HTML的文件:

  1. ﹤body﹥
  2. ﹤formid="form1"runat="server"
  3. ﹤div﹥
  4.  ﹤/div﹥
  5. ﹤tableborder="0"cellpadding="0"
  6. cellspacing="0"style="width:603px;height:148px"
  7. ﹤tr﹥
  8. ﹤tdstyle="width:100px"
  9. 序号:﹤asp:TextBoxID="TextBox1"runat="server"
  10. ﹤/asp:TextBox﹥﹤/td﹥
  11. ﹤tdstyle="width:100px"
  12. 姓名:﹤asp:TextBoxID="TextBox2"runat="server"
  13. ﹤/asp:TextBox﹥﹤/td﹥
  14. ﹤tdstyle="width:100px"
  15. 出生日期:﹤asp:TextBoxID="TextBox3"runat="server"
  16. ﹤/asp:TextBox﹥﹤/td﹥
  17. ﹤/tr﹥ //C#读取TXT文件
  18. ﹤tr﹥
  19. ﹤tdstyle="width:100px"
  20. ﹤asp:FileUploadID="FileUpload2"runat="server"/﹥
  21. ﹤/td﹥
  22. ﹤tdstyle="width:100px"
  23. ﹤asp:ButtonID="Button1"runat="server"
  24. OnClick="Button1_Click"Text="导入"/﹥
  25. ﹤asp:ButtonID="Button2"runat="server"
  26. OnClick="Button2_Click"Text="查询"/﹥﹤/td﹥
  27. ﹤tdstyle="width:100px"
  28. ﹤/td﹥
  29. ﹤/tr﹥
  30. ﹤/table﹥
  31. ﹤/form﹥
  32. ﹤/body﹥

C#读取TXT文件的C#代码:

  1. usingSystem;
  2. usingSystem.Data;
  3. usingSystem.Configuration;
  4. usingSystem.Collections;
  5. usingSystem.Web;
  6. usingSystem.Web.Security;
  7. usingSystem.Web.UI;
  8. usingSystem.Web.UI.WebControls;
  9. usingSystem.Web.UI.WebControls.WebParts;
  10. usingSystem.Web.UI.HtmlControls;
  11. usingSystem.IO;
  12. usingSystem.Data.SqlClient;
  13. publicpartialclass_Default:System.Web.UI.Page
  14. {
  15. stringid1,name,birthday,str,sfz,sex;
  16. SqlConnectioncon=newSqlConnection();
  17. SqlDataReaderdr=null;
  18. //inti,count=1;
  19. protectedvoidPage_Load(objectsender,EventArgse)
  20. {
  21. } //C#读取TXT文件
  22. privatevoidLeadInsert()
  23. {
  24. try
  25. {
  26. stringpath=FileUpload2.PostedFile.FileName;//定义上传路径
  27. StreamReadersmRead=newStreamReader(path,
  28. System.Text.Encoding.Default);//设置路径
  29. stringline;
  30. while((line=smRead.ReadLine())!=null)
  31. {
  32. string[]arrStr=line.Split('|');//分割符“|”
  33. id1=arrStr[0].ToString();
  34. name=arrStr[1].ToString();
  35. sfz=arrStr[2].ToString();
  36. //birthday=arrStr[3].ToString();
  37. //sex=arrStr[4].ToString();
  38. if(Convert.ToInt32(sfz.Length.ToString())==18)
  39. {
  40. birthday=sfz.Substring(6,8);
  41. DateTimemydt=DateTime.ParseExact(birthday,"yyyyMMdd",null);
  42. birthday=mydt.ToString("yyyy-MM-dd");
  43. }
  44. if(Convert.ToInt32(sfz.Length.ToString())==15)
  45. {
  46. birthday="19"+sfz.Substring(6,6).ToString();
  47. DateTimemydt=DateTime.ParseExact(birthday,"yyyyMMdd",null);
  48. birthday=mydt.ToString("yyyy-MM-dd");
  49. }
  50. if(Convert.ToInt32(sfz.Length.ToString())==18)
  51. {
  52. if(((Convert.ToInt16(sfz.Substring(16,1).ToString()))%2==0))
  53. {
  54. sex="0";
  55. }
  56. else //C#读取TXT文件
  57. {
  58. sex="1";
  59. }
  60. }
  61. if(Convert.ToInt32(sfz.Length.ToString())==15)
  62. {
  63. if(((Convert.ToInt16(sfz.Substring(13,1).ToString()))%2==0))
  64. {
  65. sex="0";
  66. }
  67. else
  68. {
  69. sex="1";
  70. }
  71. }
  72. stringConnStr="server=localhost;uid=sa;pwd=sa;database=GAC";
  73. con.ConnectionString=ConnStr;
  74. con.Open();
  75. SqlCommandcmd=newSqlCommand();
  76. cmd.CommandText="insertintotxt(name,birthday,sex,sfz)
  77. VALUES(@name,@birthday,@sex,@sfz)";
  78. cmd.Connection=con;
  79. cmd.Parameters.Clear();
  80. //cmd.Parameters.Add("@id1",SqlDbType.Int);
  81. //cmd.Parameters["@id1"].Value=Convert.ToInt32(id1);
  82. cmd.Parameters.Add("@name",SqlDbType.VarChar,50);
  83. cmd.Parameters["@name"].Value=name.ToString();
  84. cmd.Parameters.Add("@sfz",SqlDbType.VarChar,20);
  85. cmd.Parameters["@sfz"].Value=sfz.ToString();
  86. cmd.Parameters.Add("@birthday",SqlDbType.VarChar,50);
  87. if(birthday.Length﹥0)
  88. {
  89. cmd.Parameters["@birthday"].Value=birthday.ToString();
  90. }
  91. else{
  92. cmd.Parameters["@birthday"].Value=DBNull.Value;
  93. }
  94. cmd.Parameters.Add("@sex",SqlDbType.Char,10);
  95. if(sex.Length﹥0)
  96. {
  97. cmd.Parameters["@sex"].Value=Convert.ToInt16(sex.ToString());
  98. }
  99. else
  100. { //C#读取TXT文件
  101. cmd.Parameters["@sex"].Value=DBNull.Value;
  102. }
  103. cmd.ExecuteNonQuery();
  104. con.Close();
  105. }
  106. }
  107. catch(Exceptionee){}
  108. finally{
  109. }
  110. }
  111. protectedvoidButton1_Click(objectsender,EventArgse)
  112. {
  113. LeadInsert();
  114. }
  115. protectedvoidButton2_Click(objectsender,EventArgse)
  116. {
  117. }
  118. }
  119. //C#读取TXT文件
  120. usingSystem;
  121. usingSystem.Data;
  122. usingSystem.Configuration;
  123. usingSystem.Collections;
  124. usingSystem.Web;
  125. usingSystem.Web.Security;
  126. usingSystem.Web.UI;
  127. usingSystem.Web.UI.WebControls;
  128. usingSystem.Web.UI.WebControls.WebParts;
  129. usingSystem.Web.UI.HtmlControls;
  130. usingSystem.IO;
  131. usingSystem.Data.SqlClient;
  132. publicpartialclass_Default:System.Web.UI.Page
  133. {
  134. stringid1,name,birthday,str,sfz,sex;
  135. SqlConnectioncon=newSqlConnection();
  136. SqlDataReaderdr=null;
  137. //inti,count=1;
  138. protectedvoidPage_Load(objectsender,EventArgse)
  139. {
  140. }
  141. privatevoidLeadInsert()
  142. {
  143. try
  144. { //C#读取TXT文件
  145. stringpath=FileUpload2.PostedFile.FileName;
  146. StreamReadersmRead=newStreamReader(path,
  147. System.Text.Encoding.Default);
  148. stringline;
  149. while((line=smRead.ReadLine())!=null)
  150. {
  151. string[]arrStr=line.Split('|');
  152. id1=arrStr[0].ToString();
  153. name=arrStr[1].ToString();
  154. sfz=arrStr[2].ToString();
  155. //birthday=arrStr[3].ToString();
  156. //sex=arrStr[4].ToString();
  157. if(Convert.ToInt32(sfz.Length.ToString())==18)
  158. {
  159. birthday=sfz.Substring(6,8);
  160. DateTimemydt=DateTime.ParseExact(birthday,"yyyyMMdd",null);
  161. birthday=mydt.ToString("yyyy-MM-dd");
  162. }
  163. if(Convert.ToInt32(sfz.Length.ToString())==15)
  164. {
  165. birthday="19"+sfz.Substring(6,6).ToString();
  166. DateTimemydt=DateTime.ParseExact(birthday,"yyyyMMdd",null);
  167. birthday=mydt.ToString("yyyy-MM-dd");
  168. }
  169. if(Convert.ToInt32(sfz.Length.ToString())==18)
  170. {
  171. if(((Convert.ToInt16(sfz.Substring(16,1).ToString()))%2==0))
  172. {
  173. sex="0";
  174. }
  175. else
  176. { //C#读取TXT文件
  177. sex="1";
  178. }
  179. }
  180. if(Convert.ToInt32(sfz.Length.ToString())==15)
  181. {
  182. if(((Convert.ToInt16(sfz.Substring(13,1).ToString()))%2==0))
  183. {
  184. sex="0";
  185. }
  186. else
  187. {
  188. sex="1";
  189. }
  190. }
  191. stringConnStr="server=localhost;uid=sa;pwd=sa;database=GAC";
  192. con.ConnectionString=ConnStr;
  193. con.Open();
  194. SqlCommandcmd=newSqlCommand();
  195. cmd.CommandText="insertintotxt(name,birthday,sex,sfz)VALUES(@name,@birthday,@sex,@sfz)";
  196. cmd.Connection=con;
  197. cmd.Parameters.Clear();
  198. //cmd.Parameters.Add("@id1",SqlDbType.Int);
  199. //cmd.Parameters["@id1"].Value=Convert.ToInt32(id1);
  200. cmd.Parameters.Add("@name",SqlDbType.VarChar,50);
  201. cmd.Parameters["@name"].Value=name.ToString();
  202. cmd.Parameters.Add("@sfz",SqlDbType.VarChar,20);
  203. cmd.Parameters["@sfz"].Value=sfz.ToString();
  204. cmd.Parameters.Add("@birthday",SqlDbType.VarChar,50);
  205. if(birthday.Length﹥0)
  206. {
  207. cmd.Parameters["@birthday"].Value=birthday.ToString();
  208. }
  209. else{
  210. cmd.Parameters["@birthday"].Value=DBNull.Value;
  211. }
  212. cmd.Parameters.Add("@sex",SqlDbType.Char,10);
  213. if(sex.Length﹥0)
  214. {
  215. cmd.Parameters["@sex"].Value=Convert.ToInt16(sex.ToString());
  216. }
  217. else
  218. { //C#读取TXT文件
  219. cmd.Parameters["@sex"].Value=DBNull.Value;
  220. }
  221. cmd.ExecuteNonQuery();
  222. con.Close();
  223. }
  224. }
  225. catch(Exceptionee){}
  226. finally{
  227. }
  228. }
  229. protectedvoidButton1_Click(objectsender,EventArgse)
  230. {
  231. LeadInsert();
  232. }
  233. protectedvoidButton2_Click(objectsender,EventArgse)
  234. {
  235. }
  236. }
分享到:
评论

相关推荐

Global site tag (gtag.js) - Google Analytics