Try:
using (SqlConnection con = new SqlConnection(strConnect))
{
con.Open();
using (SqlCommand cmd = new SqlCommand("SELECT employeeName FROM myTable WHERE Id=@ID", con))
{
cmd.Parameters.AddWithValue("@ID", employeeID);
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
string name = (string) reader["employeeName"];
Console.WriteLine("ID: {0}\n {1}", employeeId, name);
}
}
}
}