读写各种文件

最新推荐文章于 2022-05-28 02:10:17 发布

Neusoft06

最新推荐文章于 2022-05-28 02:10:17 发布

阅读量854

点赞数

分类专栏： C# 文章标签： c# csv dataset string textbox

本文链接：https://blog.csdn.net/neusoft06/article/details/7954637

版权

C# 专栏收录该内容

90 篇文章 2 订阅

订阅专栏

========一次性读入

using System;
using System.IO;
using System.Text;

class FileRead1 {
static void Main() {

    StreamReader sr = new StreamReader(
        "readme.txt", Encoding.GetEncoding("Shift_JIS"));

    string text = sr.ReadToEnd();

    sr.Close();

    Console.Write(text);
}
}

=======不用调用sr.Close();

using System;
using System.IO;
using System.Text;

class FileRead2 {
static void Main() {

    string text = "";

    using (StreamReader sr = new StreamReader(
        "readme.txt", Encoding.GetEncoding("Shift_JIS"))) {
      text = sr.ReadToEnd();
    }
    Console.Write(text);
}
}

======一行一行读入

using System;
using System.IO;
using System.Text;
using System.Collections;

class FileRead4 {
static void Main() {

    string line = "";
    ArrayList al = new ArrayList();

    using (StreamReader sr = new StreamReader(
        "readme.txt", Encoding.GetEncoding("Shift_JIS"))) {

      while ((line = sr.ReadLine()) != null) {
        al.Add(line);
      }
    }

    for (int i = 0; i < al.Count; i++) {
      Console.WriteLine(al[i]);
    }
}
}

======读CSV文件

            OpenFileDialog ofd = new OpenFileDialog();
            ofd.FileName = "";
            ofd.DefaultExt = "*.*";
            if (ofd.ShowDialog() == DialogResult.OK)
            {         textBox_FileName.Text = ofd.FileName;
                StreamReader sr = new StreamReader(ofd.FileName, Encoding.GetEncoding("Shift_JIS"));
                while (sr.EndOfStream == false)
                {
                    string line = sr.ReadLine();
                    string[] fields = line.Split(',');
                    //string[] fields = line.Split('\t');
                    //TSVファイルの場合
                    for (int i=0; i < fields.Length; i++) {
                        textBox_Doc.Text += fields[i] + "\r\n";
                    }
                }
            }
        }

=====读取Csv文件返回DataSet

public class CsvDAO

{

public static OleDbConnection OleCon = new OleDbConnection();

public static OleDbCommand OleCmd = new OleDbCommand();

public static OleDbDataAdapter OleDa = new OleDbDataAdapter();

#region 读取Csv文件返回DataSet

/// <summary>

/// 读取Csv文件返回DataSet

/// </summary>

/// <param name="sql">查询语句 </param>

/// <param name="FilePath">文件路径 </param>

/// <returns>Csv内容</returns>

public static DataSet CsvReader(string sql,string FilePath)

{

DataSet CsvData = new DataSet();

OleCon.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + FilePath + ";Extended Properties='Text;FMT=Delimited;HDR=YES;'";

OleCon.Open();

OleCmd.Connection = OleCon;

OleCmd.CommandText = sql;

OleDa.SelectCommand=OleCmd;

try

{

OleDa.Fill(CsvData,"Csv");

return CsvData;

}

catch

{

return CsvData;

}

finally

{

OleCon.Close();

OleCmd.Dispose();

OleDa.Dispose();

OleCon.Dispose();

}

#endregion

}

------------------------------------------------------------------------------------------------------------------------------

// DataGridViewをCSV出力するサンプル(C#.NET/VS2005)

------------------------------------------------------------------------------------------------------------------------------
public void SaveCsv(String fp)
{
    // CSVファイルオープン
    StreamWriter sw =
        new StreamWriter(fp, false,
        System.Text.Encoding.GetEncoding("SHIFT-JIS"));
    for (int r = 0; r <= this.Rows.Count - 1; r++)
    {
        for (int c = 0; c <= this.Columns.Count - 1; c++)
        {
            // DataGridViewのセルのデータ取得
            String dt = "";
            if (this.Rows[r].Cells[c].Value != null)
            {
                dt = this.Rows[r].Cells[c].Value.
                    ToString();
            }
            if (c < this.Columns.Count - 1)
            {
                dt = dt + ",";
            }
            // CSVファイル書込
            sw.Write(dt);
        }
        sw.Write("\n");
    }
    // CSVファイルクローズ
    sw.Close();
}
// ----------------------------------------------------------