Notes

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

namespace ConsoleApp4
{
class SpCalling
{
static void Main(string[] args)
{
try
{
//Store the connection string in the ConnectionString variable
string ConnectionString = @"Data Source=(localdb)\MSSQLLocalDB;Initial Catalog=University;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("spGetEmployeee", 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["Gender"] + ", " + sdr["Salary"]);

//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();
}
}
}