1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:
37:
38:
39:
40:
41:
42:
43:
44:
45:
46:
47:
48:
49:
50:
51:
52:
53:
54:
55:
56:
57:
58:
59:
60:
61:
62:
63:
64:
65:
66:
67:
68:
69:
70:
71:
72:
73:
74:
75:
76:
77:
78:
79:
80:
81:
82:
83:
84:
85:
86:
87:
88:
89:
90:
91:
92:
93:
94:
95:
96:
97:
98:
99:
100:
101:
102:
103:
104:
105:
106:
107:
108:
109:
110:
111:
112:
113:
114:
115:
116:
117:
118:
119:
120:
121:
122:
123:
124:
125:
126:
127:
128:
129:
130:
131:
132:
133:
134:
135:
136:
137:
138:
139:
140:
141:
142:
143:
144:
145:

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;

using ToolCollection.DAO;
using ToolCollection.Behaviour;

using Excel = Microsoft.Office.Interop.Excel;
using EETestmanagementIO.XLSHandler;
using EETestmanagementIO.CSVHandler;


namespace ToolCollection

{
    public partial class CompareFiles : Form
    {

        List<DataTable> File1 = new List<DataTable>();
        List <DataTable> File2 = new List <DataTable>();
        DataTable table = new DataTable("Difference");
        

        private static bool compareDataTable(DataTable a, DataTable b)
        {

            for (int i = 0; i < a.Rows.Count; ++i)
            {
                DataRow rowA = a.Rows[i];
                DataRow rowB = b.Rows[i];


                for (int k = 0; k < rowA.ItemArray.Length; ++k)
                {
                    if (!rowA[k].ToString().Equals(rowB[k].ToString()))
                    {
                        return false;
                    }
                }
            }
            return true;
        }

        private static List<DataTable> ReadFile(string file2read)
        {
            List<DataTable> file = new List<DataTable>();
            if (file2read.EndsWith(".csv"))
            {
                List<DataTable> result = new List<DataTable>();
                file.Add(CSVhandler.Read(file2read, ';', false));
     

                return result;
            }
            else if ((file2read.EndsWith(".xls")) || (file2read.EndsWith(".xlsx")))
            {

                XlsHandler handler = new XlsHandler(file2read);
                file = handler.ReadData();
                handler.CloseWithoutSaving();

                return file;
            }
            else
            {
                return null;
            }
        }


        public CompareFiles()
        {
            InitializeComponent();
        }

        private void btnChooseFile1_Click(object sender, EventArgs e)
        {
            OpenFileDialog choosefile1= new OpenFileDialog();
            choosefile1.InitialDirectory = "C:\\";
            choosefile1.CheckFileExists = true;
            
          

            if (choosefile1.ShowDialog() == DialogResult.OK)
            {
                lbxFiles.Items.Add(choosefile1.FileName);

                btnChooseFile1.Enabled = false;

            }


        }

        private void btnChooseFile2_Click(object sender, EventArgs e)
        {
            OpenFileDialog choosefile2= new OpenFileDialog();
            choosefile2.InitialDirectory = "C:\\";
            choosefile2.CheckFileExists = true;
            

            if (choosefile2.ShowDialog() == DialogResult.OK)
            {
                lbxFiles.Items.Add(choosefile2.FileName);
                btnChooseFile2.Enabled = false;
            }
        }

        private void lbxFiles_SelectedIndexChanged(object sender, EventArgs e)
        {
        }

        private void btnCompareFiles_Click(object sender, EventArgs e)

        {
                       
            int counter = 0;
            if (counter == 0 || compareDataTable(File1[1], File2[1]))
            {
                MessageBox.Show("Finish!");
            }
            else
            {
                MessageBox.Show("Files are different.");
            }

            ++counter;

        }

        private void tbFiles_TextChanged(object sender, EventArgs e)

        {
        }

        private void lbxFiles_SelectedIndexChanged_1(object sender, EventArgs e)
        {
        }
    }
}					

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:

private static List<DataTable> ReadFile(string file2read)
{
    List<DataTable> file = new List<DataTable>();
    if (file2read.EndsWith(".csv"))
    {
        List<DataTable> result = new List<DataTable>();
        file.Add(CSVhandler.Read(file2read, ';', false));
        return result;
    }
    else if ((file2read.EndsWith(".xls")) || (file2read.EndsWith(".xlsx")))
    {
        XlsHandler handler = new XlsHandler(file2read);
        file = handler.ReadData();
        handler.CloseWithoutSaving();
        return file;
    }           
    else
    {
        return null; 
    }
}