rendered paste bodypublic 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;
}
}