public static ICollection Find(string sql) { IDbConnection conn = null; try { ArrayList array = new ArrayList(); conn = Matchbox.DbConnection; IDbCommand dbcmd = conn.CreateCommand(); dbcmd.CommandText = sql; IDataReader dataReader = dbcmd.ExecuteReader(); while (dataReader.Read()) { ArrayList data = new ArrayList(); for (int i =0; i < dataReader.FieldCount; i++) { data.Add(dataReader.GetString(i)); } array.Add(data); } dataReader.Close(); return array; } catch (Exception e) { Console.WriteLine("Error executing: " + sql); throw e; } finally { if( conn != null ) { conn.Close(); } conn = null; } }