เพิ่มข้อมูลทีละมากๆ ใน database mdb โดยดึงข้อมูลจากไฟล์ lyr แต่ละไฟล์

//สร้าง list file .lyr
public static System.Collections.Generic.List<string> GetFilesRecursive(string initial)
        {
            System.Collections.Generic.List<string> result = new System.Collections.Generic.List<string>();
            System.Collections.Generic.Stack<string> stack = new System.Collections.Generic.Stack<string>();
            stack.Push(initial);
            while ((stack.Count > 0))
            {
                string dir = stack.Pop();
                result.AddRange(System.IO.Directory.GetFiles(dir, "*.lyr"));
                string directoryName = null;
                foreach (string directoryName_loopVariable in System.IO.Directory.GetDirectories(dir))
                {
                    directoryName = directoryName_loopVariable;
                    stack.Push(directoryName);
                }
            }
            return result;
        }

//ส่งกลับชื่อคนร้อง กะชื่อเพลง
public static string _ArtisSong (string pathFileName)
        {
            Random rnd = new Random();
         //เมื่อเกิดข้อผิดพลาดให้ส่งกลับชื่อ แบบ random ออกไปเพื่อจะไม่ถือว่าเป็นเพลงซ้ำ
            string result = "" + rnd.Next(1, 99999) + rnd.Next(1, 99999) + rnd.Next(1, 99999) + rnd.Next(1, 99999) + rnd.Next(1, 99999) + rnd.Next(1, 99999) + rnd.Next(1, 99999) + rnd.Next(1, 99999);

            try
            {
                 result = (string)System.IO.File.ReadLines(pathFileName, System.Text.Encoding.GetEncoding(874)).Skip(1).Take(1).First() + " ; " + (string)System.IO.File.ReadLines(pathFileName, System.Text.Encoding.GetEncoding(874)).Skip(0).Take(1).First(); ;
                
            }
            catch { }

        return result;
        }
//เพิ่มข้อมูลเข้า database mdb
private void timer1_Tick(object sender, EventArgs e)
        {
            if (i >= _file.Count) 
                { 
                timer1.Enabled = false; 
                songTableAdapter.Fill(dataDataSet.Song); 
                label1.Text = "";
                c = songDataGridView.RowCount - 1;
                i = 0;
                idel = 0;
                timer2.Enabled = true; 
                t = 0; timer3.Enabled = true; 
                Cursor = Cursors.Default; 
                return; 
                }
            label1.Text = i + "/" + _file.Count +  "File;" + _file[i] + " Song;" + Program._ArtisSong(_file[i]) ;
            
            songTableAdapter.Insert(_file[i], Program._ArtisSong(_file[i]));
            i++;
        }
//ลบไฟล์ซ้ำโดยอ้างอิง Datagrid แต่ละแถว
private void timer2_Tick(object sender, EventArgs e)
        {
            if (i >= songDataGridView.RowCount - 1) { timer3.Enabled = false; timer2.Enabled = false; Cursor = Cursors.Default; if (checkBox1.Checked == true) { Process.Start("shutdown", "/s /t 0"); } return; }
            if (songDataGridView[0, i].Value.ToString().Replace(" ","").ToUpper() == cri)
            {
                idel++;
                DelFile(songDataGridView[1, i].Value.ToString());
                DelFile(songDataGridView[1, i].Value.ToString().ToUpper().Replace("\\NCN\\LYRICS\\", "\\NCN\\CURSOR\\").Replace(".LYR", ".CUR"));
                DelFile(songDataGridView[1, i].Value.ToString().ToUpper().Replace("\\NCN\\LYRICS\\", "\\NCN\\SONG\\").Replace(".LYR", ".MID"));
            }
            else
            { cri = songDataGridView[0, i].Value.ToString().Replace(" ", "").ToUpper(); }
            Text = "Files;" +  i + "/" +  (songDataGridView.RowCount - 1) + " Delete Files:" + idel +   " Check:" + cri ;
            label1.Text = "Check:" + cri + " file:" + songDataGridView[1, i].Value.ToString();
            i++;
        }