ADO.NET基础 查

cmd.CommandText = "select *from Users"; // 查询语句

            conn.Open(); //开启
            //创建数据读取对象
            SqlDataReader a = cmd.ExecuteReader();

            if(a.HasRows) //判断如果读到了行数据
            {
                while(a.Read()) //一行一行读取 以列的单位读取
                {
                    Console.Write(a["UserName"]); //获取每一行的没一个字段
                    Console.Write(" | "); //分割线
                    Console.Write(a["PassWord"]);
                    Console.Write(" | ");
                    Console.Write(a["NickName"]);
                    Console.Write(" | ");
                    Console.Write(a["Sex"]);
                    Console.Write(" | ");
                    Console.Write(a["Birthday"]);
                    Console.Write(" | ");
                    Console.Write(a["NationCode"]);
                    Console.Write(" | ");
                    Console.WriteLine();
                }
            }
            conn.Close();
            Console.ReadKey();