C#

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.IO;
using Microsoft.VisualBasic;
using System.Globalization;
using System.Drawing.Drawing2D;
using ZedGraph;
using System.Linq;
using System.Windows.Forms.Integration;
      public DataTable BuildDataTable(string fileFullPath, char  seperator)
        {
            
            const int EOF = -1;
            DataTable myTable = new DataTable("MyTable");
            DataRow myRow;
            StreamReader myReader = new StreamReader(fileFullPath);
            string Set_Data = myReader.ReadLine();

            int Set_len = Set_Data.Length;
            try
            {
                myReader = new StreamReader(fileFullPath);
            }
            catch (Exception ex)
            {
                MessageBox.Show("Fout bij openen bestand: " + ex.Message);
                return new DataTable("Empty");
            }
            try
            // Open file and read first line to determine how many fields there are.            
            {
                string[] fieldValues = new string[Set_len];//myReader.ReadLine().Split(new Char[] { seperator, '\t' }); 
                //skip title               
                // Title = fieldValues[2];               
                //string [] Get_val  = myReader.ReadLine().Split(new Char[] { seperator, '\t' });

                //fieldValues = myReader.ReadLine().Split(new Char[] { seperator, '\t' });
                fieldValues = myReader.ReadLine().Split(new Char[] { seperator, '\t',  });

                // Adding the first line of data to data table (columnnames)                
                // Create data columns accordingly                
                for (int i = 0; i < fieldValues.Length; i++)
                {
                    //if (i==0) myTable.Columns.Add(new DataColumn("Code"));                   

                    //if (i==1) myTable.Columns.Add(new DataColumn("Datum"));                  
                    myTable.Columns.Add(new DataColumn(fieldValues[i].ToString().Trim()));
                }
                //Now reading the rest of the data to data table               
                while (myReader.Peek() != EOF)
                {
                    fieldValues = myReader.ReadLine().Split(new Char[] { seperator, '\t' });
                   
                    myRow = myTable.NewRow();
                    for (int i = 0; i < fieldValues.Length; i++)
                    {

                        myRow[i] = fieldValues[i].ToString().Trim();



                    }
                    myTable.Rows.Add(myRow);
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show("Error building datatable: " + ex.Message);
                return new DataTable("Empty");
            }
            finally
            {
                if (myReader != null)
                {
                    myReader.Close();
                }
            }
            myTable.AcceptChanges();
            if (myReader != null)
            {
                myReader.Close();
            }
            dataGridView1.DataSource = myTable;           
              return myTable;
}
 public void Proces_File() 
        {
            char[] Separator = { ';', ':' };
            String Choose_File;
            DataTable DT;
            OpenFD.InitialDirectory = "Y:\\";
            OpenFD.Filter = "txt files(*.txt)|*.txt|All Files(*.*)|*.*";
            OpenFD.FilterIndex = 2;
            OpenFD.RestoreDirectory = true;
            if (OpenFD.ShowDialog() != DialogResult.Cancel) 
            {
                Choose_File = OpenFD.FileName;
                richTextBox1.LoadFile(Choose_File, RichTextBoxStreamType.PlainText);
                DT = BuildDataTable(OpenFD.FileName, ';');
                this.dataGridView1.DataSource = DT;
            
            
            }
  private void button3_Click(object sender, EventArgs e)
        {

            Proces_File();

        }

public bool SynchProductsCategoryToCBD(IList<EcashProductCatModel> model)
        {
            con = new SqlConnection(strCon);

            cmdinsert = new SqlCommand("sp_AddProductCategory"); //needs to be created
            cmdinsert.CommandType = CommandType.StoredProcedure;
            cmdinsert.Connection = con;


            bool Error = false;
            try
            {
                con.Open();

                foreach (EcashProductCatModel ecash in model)
                {
                        cmdinsert.Parameters.Add("@CATEGORY_ID", SqlDbType.Int).Value = ecash.CATEGORY_ID;
                        cmdinsert.Parameters.Add("@CATEGORY_DESCRIPTION", SqlDbType.VarChar).Value = ecash.CATEGORY_DESCRIPTION;
                        cmdinsert.Parameters.Add("@SCHOOLID", SqlDbType.Int).Value = ecash.SCHOOLID;
                        cmdinsert.ExecuteNonQuery();
           
                }  
                Error = true;
            }
            catch (Exception ex)
            {
                Logger.LoggerClient logger = new Logger.LoggerClient();
                //Collect Data
                Logger.LoggerModel models = new Logger.LoggerModel();
                models.iTYPEID = Convert.ToInt32(GenericEnum.Logging_Type.ECASH_SYCH);
                models.sLOGGER_CLASS = "eCashDatalayer";
                models.sLOGGER_DESCRIPTION = ex.Message;
                models.sLOGGER_FUNCTION = "SynchProductsCategoryToCBD";
                models.sLOGGER_LOGGEDINUSERID = "";
                models.sLOGGER_PAGE = "NA";
                models.sLOGGER_VALUE = "NA";
                logger.LogIncident(models);
            }
            finally
            {
                con.Close();
            }
            return Error;
        }