ADO.NET データベース接続方式



      ・SqlDataReaderを使用、データの読み出しをする

   public static void SqlconnectByDR()
        {
            string path = "server=XXX;database =Test;Integrated Security =true";
            SqlConnection cn = new SqlConnection(path);
            //SqlConnection cn = new SqlConnection();
            //sqlconn.ConnectionString = path;
            string sql = "select * from T_Student";
            try
            {
                cn.Open();
                SqlCommand cmd = new SqlCommand(sql, cn);
                SqlDataReader dr = cmd.ExecuteReader(); //SqlDataReader
                while (dr.Read())
                {
                    Console.WriteLine("{0}\t{1}", dr[0], dr[1]);
                }
                dr.Close();
                Console.