Notes

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

namespace ADOUsingStoredProcedure
{
class Program
{
static void Main(string[] args)
{
try
{
//Store the connection string in the ConnectionString variable
string ConnectionString = @"data source=LAPTOP-ICA2LCQLSQLEXPRESS; database=StudentDB; integrated security=SSPI";

//Create the SqlConnection object
using (SqlConnection connection = new SqlConnection(ConnectionString))
{
//Create the SqlCommand object by passing the stored procedure name and connection object as parameters
SqlCommand cmd = new SqlCommand("spGetStudents", connection)
{
//Specify the command type as Stored Procedure
CommandType = CommandType.StoredProcedure
};

//Open the Connection
connection.Open();

//Execute the command i.e. Executing the Stored Procedure using ExecuteReader method
//SqlDataReader requires an active and open connection
SqlDataReader sdr = cmd.ExecuteReader();

//Read the data from the SqlDataReader
//Read() method will returns true as long as data is there in the SqlDataReader
while (sdr.Read())
{
//Accessing the data using the string key as index
Console.WriteLine(sdr["Id"] + ", " + sdr["Name"] + ", " + sdr["Email"] + ", " + sdr["Mobile"]);

//Accessing the data using the integer index position as key
//Console.WriteLine(sdr[0] + ", " + sdr[1] + ", " + sdr[2] + ", " + sdr[3]);
}
}
}
catch (Exception ex)
{
Console.WriteLine($"Exception Occurred: {ex.Message}");
}
Console.ReadKey();
}
}
}