Why do you use stored procedures for a simple selection?
If you use just a select statment it is even easier:
SqlConnection conect = new SqlConnection("Data Source=SHARP-ITECH-PC\\SQLEXPRESS;Initial Catalog=EmployeeRecord;Integrated Security=True");
SqlCommand comand = new SqlCommand("select * from EmpData", conect);
try
{
conect.Open();
using (SqlDataReader reader = comand.ExecuteReader())
{
while (reader.Read())
{
for (int i = 0; i < reader.FieldCount; i++)
{
Console.Write(reader.GetName(i) + ": ");
Console.WriteLine(reader.GetValue(i));
}
Console.WriteLine();
}
}
}
finally
{
conect.Close();
}
Console.ReadKey();