All pastes #9427 Raw Edit

MatchBox Find

public text v1 · immutable
#9427 ·published 2005-04-12 18:06 UTC
rendered paste body
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;
   }
}