asp.net 如何按行读取 word 或 txt 文件

wensoft80 2010-06-20 02:10:30

asp.net 如何按行读取 word 或 txt 文件
请给个相关的例子吧，谢谢了

...全文

228 4 打赏收藏转发到动态举报

写回复

用AI写文章

4 条回复

切换为时间正序

请发表友善的回复…

发表回复

wuyq11 2010-06-20

打赏
举报

List<string> lst=new List<sring>(File.ReadAllLines(""))
foreach(string s in lst)
{
string[] arr=s.Split（' ');

}

辰爸 2010-06-20

打赏
举报



  StreamReader sr=null;

            try

            {

                sr= new StreamReader(baseLocation, Encoding.GetEncoding("gb2312"));

                string strLine = sr.ReadLine();

                while (strLine != null)

                {

                    if (strLine.Contains("#HEAD") == true)

                    {

                        strLine = sr.ReadLine();



                    }

                    if (strLine.Length > 5)

                    {



                        string[] contents = strLine.Split('|');



                        string yhbh = contents[1].ToString();

                        string ghtm = contents[2].ToString();

                        string sjjbh = contents[3].ToString();

                        string sjrq1 = contents[4].ToString();



                        string fffs = contents[5].ToString();

                        string sjrxm = contents[6].ToString();

                        string sjrdz = contents[7].ToString();

                        string sjryb = contents[8].ToString();

                        string txhm = contents[9].ToString();

                        string ygh = contents[10].ToString();

                        string bwb = contents[11].ToString();



                        int count = GetSXX(dc, yhbh, sjrq1);



                        string in_sql = string.Format("insert into ZJGHX (UserID,GHTM,SJJBH,SJRQ,FFFS,SJRXM,SJRDZ,SJRYB,TXHM,YGH,PCID,SXX,BWB) values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}',{11},'{12}')", yhbh, ghtm, sjjbh, sjrq1, fffs, sjrxm, sjrdz, sjryb, txhm, ygh, guid, count,bwb);

                        string fin_sql = "select count(*) from zjghx where ghtm='"+ghtm+"'";

                        if (DA.ExecuteScalar(fin_sql).ToString() == "0")

                        {

                            dc.ExecuteNonQuery(in_sql);

                        }

                        else

                        {

                            string del_sql = "delete from zjghx where ghtm='"+ghtm+"'";

                            DA.ExecuteNonQuery(del_sql);

                           



                            in_sql = string.Format("sql语句);

                            DA.ExecuteNonQuery(in_sql);

                        }

                       

                        strLine = sr.ReadLine();

                    }

                    else

                    {

                        strLine = sr.ReadLine();

                    }

                    if (strLine.Contains("#END")==true)

                    {

                        break;

                    }

                }

            }

            catch (Exception ex)

            {

                this.tbmsg.Text = ex.Message;

            }

            finally

            {

                sr.Close();

            }

//实现了按行读取txt并存入到数据库中

xray2005 2010-06-20

打赏
举报

命名空间(System.IO)
示例下面的代码示例阐释了 TextReader 和 TextWriter 两种类型的多态行为。由于 aStringWriter 和 aStreamWriter 都属于 TextWriter 类型，因此 WriteVowel 方法会同时用这两个对象调用，并且会执行与每个特定类型关联的 Write 方法。同样，ReadText 方法会同时用 aStringReader 和 aStreamReader 调用，并且会执行适当的 ReadToEnd 方法。请注意，对于 aStringWriter 和 aStringReader，备份是字符串；而对于 aStreamWriter 和 aStreamReader，备份是文件。
using System;
using System.IO;

class TextRW
{
static void Main()
{
TextWriter stringWriter = new StringWriter();
using(TextWriter streamWriter =
new StreamWriter("InvalidPathChars.txt"))
{
WriteText(stringWriter);
WriteText(streamWriter);
}

TextReader stringReader =
new StringReader(stringWriter.ToString());
using(TextReader streamReader =
new StreamReader("InvalidPathChars.txt"))
{
ReadText(stringReader);
ReadText(streamReader);
}
}

static void WriteText(TextWriter textWriter)
{
textWriter.Write("Invalid file path characters are: ");
textWriter.Write(Path.InvalidPathChars);
textWriter.Write('.');
}

static void ReadText(TextReader textReader)
{
Console.WriteLine("From {0} - {1}",
textReader.GetType().Name, textReader.ReadToEnd());
}
}

import System.*;
import System.IO.*;

class TextRW
{
public static void main(String[] args)
{
TextWriter stringWriter = new StringWriter();
TextWriter streamWriter = new StreamWriter("InvalidPathChars.txt");
try {
WriteText(stringWriter);
WriteText(streamWriter);
}
finally {
streamWriter.Dispose();
}
TextReader stringReader = new StringReader(stringWriter.ToString());
TextReader streamReader = new StreamReader("InvalidPathChars.txt");
try {
ReadText(stringReader);
ReadText(streamReader);
}
finally {
streamReader.Dispose();
}
} //main

static void WriteText(TextWriter textWriter)
{
textWriter.Write("Invalid file path characters are: ");
textWriter.Write(Path.InvalidPathChars);
textWriter.Write('.');
} //WriteText

static void ReadText(TextReader textReader)
{
Console.WriteLine("From {0} - {1}",
textReader.GetType().get_Name(),textReader.ReadToEnd());
} //ReadText
} //TextRW

备注说明TextReader 为 StreamReader 和 StringReader 的抽象基类，它们分别从流和字符串读取字符。使用这些派生类可打开一个文本文件以读取指定范围的字符，或基于现有的流创建一个读取器。对继承者的说明：派生类必须至少实现 Peek 和 Read 方法以创建一个有用的 TextReader 实例。
语法

[SerializableAttribute]
[ComVisibleAttribute(true)]
public abstract class TextReader : MarshalByRefObject,
IDisposable

/** @attribute SerializableAttribute */
/** @attribute ComVisibleAttribute(true) */
public abstract class TextReader extends MarshalByRefObject implements IDisposable

版本.NET Framework受以下版本支持：3.5、3.0、2.0、1.1、1.0.NET Compact Framework受以下版本支持：3.5、2.0、1.0XNA Framework受以下版本支持：2.0、1.0