Convert datatab to csv

来源：互联网发布：亿图数控系统磨床编程编辑：程序博客网时间：2024/04/29 21:23

///
/// This method is used to Convert DataTable to CSV ( comma seperated ) file.
///
///
///
///

publicstaticvoid DataTable2CSV(DataTable table, string filename,string seperateChar)
{

StreamWriter sr =null;

try
{
sr = newStreamWriter(filename);
string seperator ="";
StringBuilder builder =newStringBuilder();
foreach (DataColumn col in table.Columns)
{
builder.Append(seperator).Append(col.ColumnName);
seperator = seperateChar;
}
sr.WriteLine(builder.ToString());
foreach (DataRow row in table.Rows)
{
seperator = "";
builder = newStringBuilder();
foreach (DataColumn col in table.Columns)
{
builder.Append(seperator).Append(row[col.ColumnName]);
seperator = seperateChar;
}
sr.WriteLine(builder.ToString());
}
}
finally
{
if (sr !=null)
{
sr.Close();
}
}

}

private DataTable GetDataTableFromCSV(string path)
        {
            string pathOnly = Path.GetDirectoryName(path);
            string fileName = Path.GetFileName(path);
            string sql = @"SELECT * FROM [" + fileName + "]";
            using (OleDbConnection connection = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + pathOnly + ";Extended Properties=\"Text;HDR=" + "Yes" + "\""))
            using (OleDbCommand command = new OleDbCommand(sql, connection))
            using (OleDbDataAdapter adapter = new OleDbDataAdapter(command))
            {
                DataTable dataTable = new DataTable() { Locale = CultureInfo.CurrentCulture };
                adapter.Fill(dataTable);
                return dataTable;
            }
        }