C#中csv文件與DataTable相互導入處置實例解析。本站提示廣大學習愛好者：（C#中csv文件與DataTable相互導入處置實例解析）文章只能為提供參考，不一定能成為您想要的結果。以下是C#中csv文件與DataTable相互導入處置實例解析正文
本文引見了C#中csv文件與DataTable相互導入處置實例解析，重要功效代碼封裝處置下，絕對比擬簡略。今後項目用到的話可以直接應用。詳細辦法以下：
1.封裝好的類以下：
using System;
using System.Data;
using System.IO;
using System.Text;
using CSharpUtilHelpV2;
using StringUtilHelp;
namespace DBUtilHelpV2Plus
{
public static class DBToolV2Plus
{
/// <summary>
/// 將DataTable導出到CSV.
/// </summary>
/// <param name="table">DataTable</param>
/// <param name="fullSavePath">保留途徑</param>
/// <param name="tableheader">題目信息</param>
/// <param name="columname">列稱號『eg:姓名,年紀』</param>
/// <returns>導出勝利true;導出掉敗false</returns>
public static bool ToCSV(this DataTable table, string fullSavePath, string tableheader, string columname)
{
ArgumentChecked(table, fullSavePath);
//------------------------------------------------------------------------------------
try
{
string _bufferLine = "";
using (StreamWriter _writerObj = new StreamWriter(fullSavePath, false, Encoding.UTF8))
{
if (!string.IsNullOrEmpty(tableheader))
_writerObj.WriteLine(tableheader);
if (!string.IsNullOrEmpty(columname))
_writerObj.WriteLine(columname);
for (int i = 0; i < table.Rows.Count; i++)
{
_bufferLine = "";
for (int j = 0; j < table.Columns.Count; j++)
{
if (j > 0)
_bufferLine += ",";
_bufferLine += table.Rows[i][j].ToString();
}
_writerObj.WriteLine(_bufferLine);
}
return true;
}
}
catch (Exception)
{
return false;
}
}
/// <summary>
/// 參數檢討
/// </summary>
/// <param name="table"></param>
/// <param name="fullSavePath"></param>
private static void ArgumentChecked(DataTable table, string fullSavePath)
{
if (table == null)
throw new ArgumentNullException("table");
if (string.IsNullOrEmpty(fullSavePath))
throw new ArgumentNullException("fullSavePath");
string _fileName = CSharpToolV2.GetFileNameOnly(fullSavePath);
if (string.IsNullOrEmpty(_fileName))
throw new ArgumentException(string.Format("參數fullSavePath的值{0},不是准確的文件途徑!", fullSavePath));
if (!_fileName.InvalidFileNameChars())
throw new ArgumentException(string.Format("參數fullSavePath的值{0},包括不法字符!", fullSavePath));
}
/// <summary>
/// 將CSV文件數據導入到Datable中
/// </summary>
/// <param name="table"></param>
/// <param name="filePath">DataTable</param>
/// <param name="rowIndex">保留途徑</param>
/// <returns>Datable</returns>
public static DataTable AppendCSVRecord(this DataTable table, string filePath, int rowIndex)
{
ArgumentChecked(table, filePath);
if (rowIndex < 0)
throw new ArgumentException("rowIndex");
using (StreamReader reader = new StreamReader(filePath, Encoding.UTF8, false))
{
int i = 0, j = 0;
reader.Peek();
while (reader.Peek() > 0)
{
j = j + 1;
string _line = reader.ReadLine();
if (j >= rowIndex + 1)
{
string[] _split = _line.Split(',');
DataRow _row = table.NewRow();
for (i = 0; i < _split.Length; i++)
{
_row[i] = _split[i];
}
table.Rows.Add(_row);
}
}
return table;
}
}
}
}
2.代碼應用測試以下：
using System;
using System.Data;
using DBUtilHelpV2;
using DBUtilHelpV2Plus;
namespace DBUtilHelpV2PlusTest
{
class Program
{
static DataTable testDb = null;
static string fullSavePath = string.Format(@"C:\{0}.csv", DateTime.Now.ToString("yyyyMMddHH"));
static void Main(string[] args)
{
try
{
CreateTestDb();
Console.WriteLine(string.Format("DataTable導出到CSV文件{0}.", testDb.ToCSV(fullSavePath, "姓名,年紀", "人員信息表") == true ? "勝利" : "掉敗"));
testDb.Rows.Clear();
Console.WriteLine(string.Format("清空數據,以後{0}條數據.", testDb.Rows.Count));
testDb = testDb.AppendCSVRecord(fullSavePath, 2);
Console.WriteLine(string.Format("CSV文件導入到Datable,導入{0}條數據.", testDb.Rows.Count));
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
finally
{
Console.ReadLine();
}
}
static void CreateTestDb()
{
if (testDb == null)
{
testDb = DBToolV2.CreateTable("Name,Age|int");
for (int i = 1; i <= 10; i++)
{
DataRow _row = testDb.NewRow();
_row["Name"] = string.Format("YanZhiwei_{0}", i);
_row["Age"] = i;
testDb.Rows.Add(_row);
}
}
}
}
}
運轉後果以下圖所示：
運轉後果圖：
一個Java簡略單純盤算器法式設計就這麼完成了，願望本文可以對年夜家編寫盤算器有所啟示，這只是一個簡略單純的盤算器，年夜家還可以持續施展，完美盤算器的功效。
