C#

int i = 0,duration, year;
                string artist, title, album, bandname, genre, path;
                string delSql = "DELETE * FROM Library";
                musLibConn.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Program Files\GeneSys\Library.mdb";
                OleDbCommand deleteLib = new OleDbCommand(delSql, musLibConn);
                musLibConn.Open(); 
                if (tbMusPath.Text != "")
                {
                    utility util = new utility();
                    filepaths = Directory.GetFiles(util.getLibPath(), "*.mp3", SearchOption.AllDirectories);
                    deleteLib.ExecuteNonQuery();
                    pBar.Visible = true;

                    foreach(string str in filepaths)
                    {
                        //pBar.Value = i % 100;
                        //path = filepaths[i].ToString();
                        //duration = Convert.ToInt32(CurrSong.ID3v2Info.GetTextFrame("TLEN"));
                        lblPath.Text = str;

                        ID3Info CurrSong = new ID3Info(filepaths[i], true);
                        artist = CurrSong.ID3v2Info.GetTextFrame("TPE1");
                        title = CurrSong.ID3v2Info.GetTextFrame("TIT2");
                        album = CurrSong.ID3v2Info.GetTextFrame("TALB");
                        
                        string insSql = "INSERT INTO Library(Artist,Title,Album,Path)" +
                                        "VALUES('" + artist.Replace("'", "''") + "','" + title.Replace("'", "''") + "','" +
                                        album.Replace("'", "''") + "','" + str.Replace("'", "''") + "')"; 
                        using (OleDbCommand insertLib = new OleDbCommand(insSql, musLibConn))
                        {                           
                            insertLib.ExecuteNonQuery();
                        }
                        i++;
                    }
                    
                    pBar.Visible = false;
                    lblNum.Text = Convert.ToString(filepaths.Length);
                    util.setNoFiles(filepaths.Length);

return GetEncoding(TEncoding).GetString(MStream.ToArray());

string result=GetEncoding(TEncoding).GetString(MStream.ToArray());
MStream.Dispose();
return result;

OleDbCommand command = new OleDbCommand();
command.Connection = connection;
command.CommandText = "INSERT INTO library(artist, title, album, path) VALUES (@artist, @title, @album, @path);"
command.Parameters.Add("@artist", OleDbType.VarChar);
command.Parameters.Add("@title", OleDbType.VarChar);
command.Parameters.Add("@album", OleDbType.VarChar);
command.Parameters.Add("@path", OleDbType.VarChar);
string sqlString = ";
foreach(string path in filePaths){
    currentSong = new ID3Info(path, true);  //Is this disposable? If so use using(currentSong = new ID3Info(path, true){
    command.Parameters["@artist"].Value = currentSong.ID3v2Info.GetTextFrame("TPE1");
    command.Parameters["@title"].Value = currentSong.ID3v2Info.GetTextFrame("TIT2");
    command.Parameters["@album"].Value = currentSong.ID3v2Info.GetTextFrame("TALB");
    command.Parameters["@path"].Value = path;
    command.ExecuteNonQuery();
}

Form2 form2 = new Form2();
form2.Show();

private void btnOpenForm2_Click_1(object sender, EventArgs e)
       {
           if (form2 == null || form2.IsDisposed)
           {
               form2 = new Form2();
               form2.Location = this.Location;    < ----- I just had to add this
               this.Visible = false;
               form2.Show();
           }
           else
           {
               MessageBox.Show("form2 already open,showing");
               form2.Focus();
           }

        }

this.StartPosition = System.Windows.Forms.FormStartPosition.Manual;

Paulo Toureiro wrote:

I also had to change form2's start position within the code

Paulo Toureiro wrote:

Thanks so much again

arrayData.All(item => item == 0);

arrayData.All((int item) => item == 0);