December 2007 - Posts

28

string sql = "some sql"
ArrayList al = new ArrayList();
using (SqlConnection cn = new SqlConnection(cs))
using (SqlCommand cmd = new SqlCommand(sql, cn)) {
    cn.Open();
    using (SqlDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection))
    while (dr.Read()) {
        object[] o = new object[dr.FieldCount];
        dr.GetValues(o);
        al.Add(o);
    }
}

foreach(object[] o in al)
    Console.WriteLine(a1(o[0].ToString());

DBCC FREESESSIONCACHE
DBCC FREEPROCCACHE
DBCC FREESYSTEMCACHE('ALL')
CHECKPOINT
DBCC DROPCLEANBUFFERS