DataReader has records using HasRows property : SqlDataReader « ADO.Net « C# / CSharp Tutorial

1. C# / CSharp Tutorial
2. ADO.Net
3. SqlDataReader

using System;
using System.Data;
using System.Data.SqlClient;

    class Program
    {
        static void Main(string[] args)
        {
            string sqlConnectString = "Data Source=(local);" +
                "Integrated security=SSPI;Initial Catalog=AdventureWorks;";

            string sqlSelect = "SELECT * FROM Person.Contact";
            string sqlSelectEmpty = "SELECT * FROM Person.Contact";

            SqlDataAdapter da = new SqlDataAdapter(sqlSelect, sqlConnectString);
            DataTable dt = new DataTable( );
            da.Fill(dt);
            Console.WriteLine("DataTable has records = {0}", dt.Rows.Count > 0);

            using (SqlConnection connection = new SqlConnection(sqlConnectString))
            {
                SqlCommand command = new SqlCommand(sqlSelect, connection);
                connection.Open( );
                SqlDataReader dr = command.ExecuteReader( );

                Console.WriteLine(dr.HasRows);
                Console.WriteLine(dr.Read( ));
                dr.Close( );
            }
            da = new SqlDataAdapter(sqlSelectEmpty, sqlConnectString);
            dt = new DataTable( );
            da.Fill(dt);
        }
    }