DataReader使用

1.用Getvalues

static void Main(string[] args)
        {
            string strCon = "data source=test;user id=sa;password=123456;initial catalog=ppt1";
            //data source是主机,user id 是用户名,password是用户名密码,initial catalog是数据库名
            SqlConnection con = new SqlConnection(strCon);
            con.Open();
            if (con.State == System.Data.ConnectionState.Open)//连接成功
            {
                Console.WriteLine("ok");
                SqlCommand command = new SqlCommand("select * from people", con);
                SqlDataReader dr=command.ExecuteReader();
                //用getvalues读
				while (dr.Read())
                {
                    object[] values = new object[dr.FieldCount];
                    dr.GetValues(values);//把GetValues出来的一行的值放到values数组中
                    for (int i = 0; i < values.Length; i++)
                    {
                        Console.WriteLine(values[i]);
                    }
                }
            }
            else
            {
                Console.WriteLine("connection flase");
            }

        }

2.用Getvalue

static void Main(string[] args)
        {
            string strCon = "data source=test;user id=sa;password=123456;initial catalog=ppt1";
            //data source是主机,user id 是用户名,password是用户名密码,initial catalog是数据库名
            SqlConnection con = new SqlConnection(strCon);
            con.Open();
            if (con.State == System.Data.ConnectionState.Open)//连接成功
            {
                Console.WriteLine("ok");
                SqlCommand command = new SqlCommand("select * from people", con);
                SqlDataReader dr=command.ExecuteReader();
			//用getvalue
                while (dr.Read())//读，每次只能读一行，所以用while来读下一行
                {
                    for (int i = 0; i < dr.FieldCount; i++)//fieldCount是列
                    {
                        Console.Write(dr.GetValue(i));
                    }
                }
            }
            else
            {
                Console.WriteLine("connection flase");
            }

        }