SqlDataReader使用

using System.Data.SqlClient;namespace TestDB{    class Program    {        static void Main(string[] args)        {            string strConn = @"  server = (local);                                    integrated security = true;                                   database = Northwind ";                      string strSQL = "select UnitPrice, UnitsInStock from Products";            SqlConnection cn = new SqlConnection(strConn);            SqlDataReader sqlRder = null;            try            {                cn.Open();                SqlCommand cmd = new SqlCommand(strSQL, cn);                sqlRder = cmd.ExecuteReader();                //把结果域放到aData数组中                object[] aData = new object[sqlRder.FieldCount];                while (sqlRder.Read())                {                    //一次读出一行数据，并保存在aData中                    sqlRder.GetValues(aData);                    for (int i = 0; i < aData.Length; ++i)                    {                        ////逐个读出每列值.                        System.Console.Write("{0}, ", aData[i].ToString());                    }                                            System.Console.WriteLine("\n----------------------------------");                }            }            catch (System.Exception exp)            {                System.Console.WriteLine(exp.ToString());            }            finally            {                if (!sqlRder.IsClosed)                    sqlRder.Close();                cn.Close();            }        }    }}