Smart Arab

By using this simple class you will be able to Export or Import DataTable to or from a Plain Text file or CSV , with delimited option .

using System;
using System.Data;
using System.IO;

class DataTable_ExportImport
{
    /// <summary>
    /// Export DataTable Columns , Rows to file
    /// </summary>
    /// <param name="datatable">The datatable to exported from.</param>
    /// <param name="delimited">string for delimited exported row items</param>
    /// <param name="exportcolumnsheader">Including columns header with exporting</param>
    /// <param name="file">The file path to export to.</param>
    public static void ExportDataTabletoFile(DataTable datatable, string delimited, bool exportcolumnsheader, string file)
    {
        StreamWriter strFile = new StreamWriter(file, false, System.Text.Encoding.Default);
        if (exportcolumnsheader)
        {
            string Columns = string.Empty;
            foreach (DataColumn column in datatable.Columns)
            {
                Columns += column.ColumnName + delimited;
            }
            strFile.WriteLine(Columns.Remove(Columns.Length - 1, 1));
        }

        foreach (DataRow datarow in datatable.Rows)
        {
            string row = string.Empty;
            foreach (object items in datarow.ItemArray)
            {
                row += items.ToString() + delimited;
            }
            strFile.WriteLine(row.Remove(row.Length - 1, 1));
        }
        strFile.Flush();
        strFile.Close();
    }

    /// <summary>
    /// Import file with delimited rows, columns to datatable
    /// </summary>
    /// <param name="file">The file path to imported from.</param>
    /// <param name="delimited">string for delimited imported row items</param>
    /// <param name="exportcolumnsheader">Including columns header with importing , (if true, the first row will be added as DataColumns) , (if false, DataColumns will be numbers)</param>
    /// <param name="datatable">The datatable to imported to.</param>
    public static void ImportDataTableFromFile(string file, string delimited, bool importcolumnsheader, DataTable datatable)
    {
        StreamReader strFile = new StreamReader(file, System.Text.Encoding.Default);

        if (importcolumnsheader)
        {
            string[] ColumnsArray = strFile.ReadLine().Split(delimited.ToCharArray());
            foreach (string strCol in ColumnsArray)
            {
                datatable.Columns.Add(strCol);
            }
        }
        else
        {
            int ColumnsCount = strFile.ReadLine().Split(delimited.ToCharArray()).Length;
            for (int iCol = 1; iCol <= ColumnsCount; iCol++)
            {
                datatable.Columns.Add(iCol.ToString());
            }

            strFile = new StreamReader(file, System.Text.Encoding.Default);
        }

        while (strFile.Peek() > 0)
        {
            datatable.Rows.Add(strFile.ReadLine().Split(delimited.ToCharArray()));
        }
        strFile.Close();
    }
}

You can call this function to Current Directory for your running Application

public static string GetAppPath()
{
    string ExePath = System.Windows.Forms.Application.ExecutablePath;
    if (Path.GetDirectoryName(ExePath).EndsWith("\\"))
    {
        return Path.GetDirectoryName(ExePath);
    }
    else
    {
        return Path.GetDirectoryName(ExePath) + "\\";
    }
}

This class will help you to detect if the string contains non English characters ,

The System.Text.RegularExpressions namespace contains classes that provide access to the .NET Framework regular expression engine. ( Regex )

public bool IsEnglish(string inputstring)
{
    Regex regex = new Regex(@"[A-Za-z0-9 .,-=+(){}\[\]\\]");
    MatchCollection matches = regex.Matches(inputstring);

    if (matches.Count.Equals(inputstring.Length))
        return true;
    else
        return false;
}

Enjoy …