- C#读取TXT文件是如何是实现的呢?本文就向你讲述C#读取TXT文件的实现方法和代码。
C#读取TXT文件之HTML的文件:
- ﹤body﹥
- ﹤formid="form1"runat="server"﹥
- ﹤div﹥
- ﹤/div﹥
- ﹤tableborder="0"cellpadding="0"
- cellspacing="0"style="width:603px;height:148px"﹥
- ﹤tr﹥
- ﹤tdstyle="width:100px"﹥
- 序号:﹤asp:TextBoxID="TextBox1"runat="server"﹥
- ﹤/asp:TextBox﹥﹤/td﹥
- ﹤tdstyle="width:100px"﹥
- 姓名:﹤asp:TextBoxID="TextBox2"runat="server"﹥
- ﹤/asp:TextBox﹥﹤/td﹥
- ﹤tdstyle="width:100px"﹥
- 出生日期:﹤asp:TextBoxID="TextBox3"runat="server"﹥
- ﹤/asp:TextBox﹥﹤/td﹥
- ﹤/tr﹥ //C#读取TXT文件
- ﹤tr﹥
- ﹤tdstyle="width:100px"﹥
- ﹤asp:FileUploadID="FileUpload2"runat="server"/﹥
- ﹤/td﹥
- ﹤tdstyle="width:100px"﹥
- ﹤asp:ButtonID="Button1"runat="server"
- OnClick="Button1_Click"Text="导入"/﹥
- ﹤asp:ButtonID="Button2"runat="server"
- OnClick="Button2_Click"Text="查询"/﹥﹤/td﹥
- ﹤tdstyle="width:100px"﹥
- ﹤/td﹥
- ﹤/tr﹥
- ﹤/table﹥
- ﹤/form﹥
- ﹤/body﹥
C#读取TXT文件的C#代码:
- usingSystem;
- usingSystem.Data;
- usingSystem.Configuration;
- usingSystem.Collections;
- usingSystem.Web;
- usingSystem.Web.Security;
- usingSystem.Web.UI;
- usingSystem.Web.UI.WebControls;
- usingSystem.Web.UI.WebControls.WebParts;
- usingSystem.Web.UI.HtmlControls;
- usingSystem.IO;
- usingSystem.Data.SqlClient;
- publicpartialclass_Default:System.Web.UI.Page
- {
- stringid1,name,birthday,str,sfz,sex;
- SqlConnectioncon=newSqlConnection();
- SqlDataReaderdr=null;
- //inti,count=1;
- protectedvoidPage_Load(objectsender,EventArgse)
- {
- } //C#读取TXT文件
- privatevoidLeadInsert()
- {
- try
- {
- stringpath=FileUpload2.PostedFile.FileName;//定义上传路径
- StreamReadersmRead=newStreamReader(path,
- System.Text.Encoding.Default);//设置路径
- stringline;
- while((line=smRead.ReadLine())!=null)
- {
- string[]arrStr=line.Split('|');//分割符“|”
- id1=arrStr[0].ToString();
- name=arrStr[1].ToString();
- sfz=arrStr[2].ToString();
- //birthday=arrStr[3].ToString();
- //sex=arrStr[4].ToString();
- if(Convert.ToInt32(sfz.Length.ToString())==18)
- {
- birthday=sfz.Substring(6,8);
- DateTimemydt=DateTime.ParseExact(birthday,"yyyyMMdd",null);
- birthday=mydt.ToString("yyyy-MM-dd");
- }
- if(Convert.ToInt32(sfz.Length.ToString())==15)
- {
- birthday="19"+sfz.Substring(6,6).ToString();
- DateTimemydt=DateTime.ParseExact(birthday,"yyyyMMdd",null);
- birthday=mydt.ToString("yyyy-MM-dd");
- }
- if(Convert.ToInt32(sfz.Length.ToString())==18)
- {
- if(((Convert.ToInt16(sfz.Substring(16,1).ToString()))%2==0))
- {
- sex="0";
- }
- else //C#读取TXT文件
- {
- sex="1";
- }
- }
- if(Convert.ToInt32(sfz.Length.ToString())==15)
- {
- if(((Convert.ToInt16(sfz.Substring(13,1).ToString()))%2==0))
- {
- sex="0";
- }
- else
- {
- sex="1";
- }
- }
- stringConnStr="server=localhost;uid=sa;pwd=sa;database=GAC";
- con.ConnectionString=ConnStr;
- con.Open();
- SqlCommandcmd=newSqlCommand();
- cmd.CommandText="insertintotxt(name,birthday,sex,sfz)
- VALUES(@name,@birthday,@sex,@sfz)";
- cmd.Connection=con;
- cmd.Parameters.Clear();
- //cmd.Parameters.Add("@id1",SqlDbType.Int);
- //cmd.Parameters["@id1"].Value=Convert.ToInt32(id1);
- cmd.Parameters.Add("@name",SqlDbType.VarChar,50);
- cmd.Parameters["@name"].Value=name.ToString();
- cmd.Parameters.Add("@sfz",SqlDbType.VarChar,20);
- cmd.Parameters["@sfz"].Value=sfz.ToString();
- cmd.Parameters.Add("@birthday",SqlDbType.VarChar,50);
- if(birthday.Length﹥0)
- {
- cmd.Parameters["@birthday"].Value=birthday.ToString();
- }
- else{
- cmd.Parameters["@birthday"].Value=DBNull.Value;
- }
- cmd.Parameters.Add("@sex",SqlDbType.Char,10);
- if(sex.Length﹥0)
- {
- cmd.Parameters["@sex"].Value=Convert.ToInt16(sex.ToString());
- }
- else
- { //C#读取TXT文件
- cmd.Parameters["@sex"].Value=DBNull.Value;
- }
- cmd.ExecuteNonQuery();
- con.Close();
- }
- }
- catch(Exceptionee){}
- finally{
- }
- }
- protectedvoidButton1_Click(objectsender,EventArgse)
- {
- LeadInsert();
- }
- protectedvoidButton2_Click(objectsender,EventArgse)
- {
- }
- }
- //C#读取TXT文件
- usingSystem;
- usingSystem.Data;
- usingSystem.Configuration;
- usingSystem.Collections;
- usingSystem.Web;
- usingSystem.Web.Security;
- usingSystem.Web.UI;
- usingSystem.Web.UI.WebControls;
- usingSystem.Web.UI.WebControls.WebParts;
- usingSystem.Web.UI.HtmlControls;
- usingSystem.IO;
- usingSystem.Data.SqlClient;
- publicpartialclass_Default:System.Web.UI.Page
- {
- stringid1,name,birthday,str,sfz,sex;
- SqlConnectioncon=newSqlConnection();
- SqlDataReaderdr=null;
- //inti,count=1;
- protectedvoidPage_Load(objectsender,EventArgse)
- {
- }
- privatevoidLeadInsert()
- {
- try
- { //C#读取TXT文件
- stringpath=FileUpload2.PostedFile.FileName;
- StreamReadersmRead=newStreamReader(path,
- System.Text.Encoding.Default);
- stringline;
- while((line=smRead.ReadLine())!=null)
- {
- string[]arrStr=line.Split('|');
- id1=arrStr[0].ToString();
- name=arrStr[1].ToString();
- sfz=arrStr[2].ToString();
- //birthday=arrStr[3].ToString();
- //sex=arrStr[4].ToString();
- if(Convert.ToInt32(sfz.Length.ToString())==18)
- {
- birthday=sfz.Substring(6,8);
- DateTimemydt=DateTime.ParseExact(birthday,"yyyyMMdd",null);
- birthday=mydt.ToString("yyyy-MM-dd");
- }
- if(Convert.ToInt32(sfz.Length.ToString())==15)
- {
- birthday="19"+sfz.Substring(6,6).ToString();
- DateTimemydt=DateTime.ParseExact(birthday,"yyyyMMdd",null);
- birthday=mydt.ToString("yyyy-MM-dd");
- }
- if(Convert.ToInt32(sfz.Length.ToString())==18)
- {
- if(((Convert.ToInt16(sfz.Substring(16,1).ToString()))%2==0))
- {
- sex="0";
- }
- else
- { //C#读取TXT文件
- sex="1";
- }
- }
- if(Convert.ToInt32(sfz.Length.ToString())==15)
- {
- if(((Convert.ToInt16(sfz.Substring(13,1).ToString()))%2==0))
- {
- sex="0";
- }
- else
- {
- sex="1";
- }
- }
- stringConnStr="server=localhost;uid=sa;pwd=sa;database=GAC";
- con.ConnectionString=ConnStr;
- con.Open();
- SqlCommandcmd=newSqlCommand();
- cmd.CommandText="insertintotxt(name,birthday,sex,sfz)VALUES(@name,@birthday,@sex,@sfz)";
- cmd.Connection=con;
- cmd.Parameters.Clear();
- //cmd.Parameters.Add("@id1",SqlDbType.Int);
- //cmd.Parameters["@id1"].Value=Convert.ToInt32(id1);
- cmd.Parameters.Add("@name",SqlDbType.VarChar,50);
- cmd.Parameters["@name"].Value=name.ToString();
- cmd.Parameters.Add("@sfz",SqlDbType.VarChar,20);
- cmd.Parameters["@sfz"].Value=sfz.ToString();
- cmd.Parameters.Add("@birthday",SqlDbType.VarChar,50);
- if(birthday.Length﹥0)
- {
- cmd.Parameters["@birthday"].Value=birthday.ToString();
- }
- else{
- cmd.Parameters["@birthday"].Value=DBNull.Value;
- }
- cmd.Parameters.Add("@sex",SqlDbType.Char,10);
- if(sex.Length﹥0)
- {
- cmd.Parameters["@sex"].Value=Convert.ToInt16(sex.ToString());
- }
- else
- { //C#读取TXT文件
- cmd.Parameters["@sex"].Value=DBNull.Value;
- }
- cmd.ExecuteNonQuery();
- con.Close();
- }
- }
- catch(Exceptionee){}
- finally{
- }
- }
- protectedvoidButton1_Click(objectsender,EventArgse)
- {
- LeadInsert();
- }
- protectedvoidButton2_Click(objectsender,EventArgse)
- {
- }
- }