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());
posted @ Thursday, December 13, 2007 3:16 PM