获取sqlDataReader对象Read()方法读取流的字段值的四种方法

//获取sqlDataReader对象Read()方法读取流的字段值的三种方法。

            using(SqlConnection conn =newSqlConnection("data source=Fan-VAIO;initialcatalog=sales;integrated security=true"))

            {

                conn.Open();

                using(SqlCommand cmd =newSqlCommand("select* from t_user",conn))

                {

 

                    SqlDataReaderdr = cmd.ExecuteReader();

                    //SqlDataReaderdr = cmd.ExecuteReader(CommandBehavior.CloseConnection);

                   while(dr.Read())

                   {

                       //方法<1>

                       for (int i = 0; i< dr.FieldCount; i++)

                       {

                           Console.Write(dr.GetName(i) + dr.GetValue(i));

                       }

                       Console.WriteLine();

                      //方法<2>

                       Console.WriteLine(dr[0]+ dr[1].ToString() + dr[2] + dr[3]);

                       //方法<3>

                       Console.WriteLine(dr.GetValue(0)+dr.GetValue (1).ToString ()+dr .GetValue (2)+dr .GetValue (3));

                       //方法<4> 最后一个字段password里面包含Null,所以不能用dr.GetInt32(),报错提示：数据为空。不能对 Null 值调用此方法或属性。

                       //Console.Write(dr.GetInt32(0)+ dr.GetString(1) + dr.GetInt32(2) + dr.GetInt32(3));

                   }

                }

            }

            Console.Read();