C#

<br />
using System;<br />
using Microsoft.Data.Odbc;<br />
using Console = System.Console;<br />
<br />
namespace practice<br />
{<br />
        public class dbconnection<br />
	{<br />
		public void swdata()<br />
		{<br />
			string msg;<br />
			string native;<br />
			string src;<br />
			string sql;<br />
<br />
			try<br />
			{<br />
				string _db = "DRIVER={MySQL ODBC 3.51 Driver};" +<br />
								"SERVER=<server ip>;DATABASE=<db>;" +<br />
								"UID=<user>;PASSWORD=<pwd>;" +<br />
								"OPTION=512";<br />
				OdbcConnection dbconnect = new OdbcConnection(_db);<br />
				dbconnect.Open();<br />
<br />
				OdbcCommand my_cmd = new OdbcCommand("",dbconnect);<br />
<br />
				my_cmd.CommandText = "SELECT * FROM swdata_o";<br />
				OdbcDataReader my_dr;<br />
				my_dr = my_cmd.ExecuteReader();<br />
<br />
				// RETURN ALL FIELDS IN DATABASE - FOR LOOP<br />
				while(my_dr.Read())<br />
				{<br />
					Console.WriteLine(my_dr.GetInt32(0) + "," + my_dr.GetString(1)<br />
						+ "," + my_dr.GetString(2));<br />
				}<br />
				dbconnect.Close();<br />
			}<br />
<br />
			catch(OdbcException odbcCon)<br />
			{<br />
				for(int i=0;i<odbcCon.Errors.Count;i++)<br />
				{<br />
					msg=odbcCon.Errors[i].Message;<br />
					native=odbcCon.Errors[i].NativeError.ToString();<br />
					src=odbcCon.Errors[i].Source;<br />
					sql=odbcCon.Errors[i].SQLState;<br />
				}<br />
			}<br />
		}<br />
	}<br />
<br />
	public class open<br />
	{<br />
		public static void Main(String[] args)<br />
		{<br />
			dbconnection dbcon = new dbconnection();<br />
			dbcon.swdata();<br />
		}<br />
	}<br />
<br />
}<br />

<br />
DirectoryInfo di = new DirectoryInfo(path + "\\");<br />
FileInfo[] theFiles = di.GetFiles();   <br />
<br />
foreach(FileInfo theFile in theFiles)    // transfer to arraylist<br />
{<br />
  ArrayList FileArrayList = new ArrayList();<br />
    FileArrayList.Add(theFile.FullName); //<--------<br />
}