December 2007 Entries

five year old swarm!

28

.Net DataReader to ArrayList

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());

clear buffers in sql

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