SqlDataReader Class ADO.Net | Read() | NextResult() | Read Database Data | Part-2

 using System;

using System.Collections.Generic;

using System.Configuration;

using System.Data.SqlClient;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

namespace SqlDataReaderDemo

{

    internal class Program

    {

        static void Main(string[] args)

        {

            string cs = ConfigurationManager.ConnectionStrings["dbcs"].ConnectionString;

            SqlConnection con = new SqlConnection(cs);

            string query = "select * from employee_tbl; select * from students";

            SqlCommand cmd = new SqlCommand(query,con);

            con.Open();

            using (SqlDataReader dr = cmd.ExecuteReader())

            {

                //Console.WriteLine(dr.GetName(0));

                //Console.WriteLine(dr.GetName(1));

                //Console.WriteLine(dr.FieldCount);

                //Console.WriteLine(dr.HasRows);

                //Console.WriteLine(dr.IsClosed);

                while (dr.Read())

                {

                    //Console.WriteLine("ID : " + dr["id"] + ", Name : " + dr["name"] + ", Gender : " + dr["gender"] + ", Age : " + dr["age"] + ", Salary : " + dr["salary"] + ", City : " + dr["city"]);

                    //Console.WriteLine("ID : " + dr[0] + ", Name : " + dr[1] + ", Gender : " + dr[2] + ", Age : " + dr[3] + ", Salary : " + dr[4] + ", City : " + dr[5]);//Concatenation Syntax

                    Console.WriteLine("ID: {0}, Name: {1}, Gender: {2}, Age: {3}, Salary: {4}, City: {5}", dr["id"], dr["name"], dr["gender"], dr["age"], dr["salary"], dr["city"]);//Placeholder Syntax

                }

                Console.WriteLine("-----------------------------------------------------------------------------------");

                if (dr.NextResult())

                {

                    while (dr.Read())

                    {

                        Console.WriteLine("{0} {1} {2} {3} {4} {5}", dr[0], dr[1], dr[2], dr[3], dr[4], dr[5]);

                    }

                }

            }

            con.Close();

            Console.ReadLine();

        }

    }

}

Above File is SqlDataReaderDemo\Program.cs

<?xml version="1.0" encoding="utf-8" ?>

<configuration>

    <startup> 

        <supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.7.2" />

    </startup>

<connectionStrings>

<add name="dbcs" connectionString="Data Source=.\SQLEXPRESS;initial Catalog=practice;Integrated Security=true;" providerName="System.Data.SqlClient"/>

</connectionStrings>

</configuration>

Above File is SqlDataReaderDemo\App.config