C#

  private List<string> GetFolder(string Folder)
    {

        DirectoryInfo dir = new DirectoryInfo(Folder);
        FileInfo[] files = dir.GetFiles("*.mp3",SearchOption.AllDirectories);

        List<string> str = new List<string>();

        foreach (FileInfo file in files)
        {
            str.Add(file.FullName);


        }
        return  str;

    }

 private void Form1_Load(object sender, EventArgs e)
    {
GetFolder(@"D:\\Music\\")
}

<br />
try {<br />
IDbConnection oConn1 = new SqlConnection("Data Source=Server1;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;");<br />
<br />
<br />
IDbConnection oConn2 = new SqlConnection("Data Source=Server2;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;");<br />
<br />
IDbTransaction oTx1 = oConn1.BeginTransaction();<br />
IDbTransaction oTx2 = oConn2.BeginTransaction();<br />
<br />
<br />
... oConn1 db access ...<br />
... oConn2 db access ...<br />
<br />
oTx2.Commit();<br />
oTx1.Commit();<br />
} catch(Exception ex)<br />
{<br />
oTx2.Rollback();<br />
oTx1.Rollback();<br />
} finally {<br />
...<br />
}<br />

<br />
IDbTransaction oTx = oConn1.BeginTransaction();<br />
oConn2.EnlistTransaction(oTx);<br />
<br />
oTx.Commit(); // commit commands associated with both connections<br />