Tile is a common choice for kitchens and dining rooms alike. A benefit of working with tile is that you can use some of the tile used in your kitchen for your dining room; kitchens are typically larger than the average family dining room, and a few leftover tiles can accommodate a dining room. Tile also cleans easily, a major plus if your dining room is used frequently, and it comes in an assortment of colors; depending on your budget, you can also buy low or high quality tile.
Wooden floors are elegant, and higher end wood, such as bamboo and teak, work in a formal dining room. The price point can be higher, but in a dream house or an investment property, expensive wood is a definite option for a dining room. Other wood flooring options, such as oak and maple, may be less costly yet still more expensive than tile, and may also meet your style and budgetary needs. You can refinish existing wood for a fraction of the price of laying down fresh wood.
Carpet isn't always an option for a dining room, but if you have a formal dining room that is only used a few times each year, carpet is a definite option. Opt for a stylish, high quality carpet (as much as your budget can afford) and ensure that your carpet choice reflects the overall style of your home. You can also deviate from the style factor if you want more function over style and opt for an industrial-style carpet in an easily cleaned fabric.
If you have a lower budget, consider laminate (looks like wood; has a lower price but is obviously less durable) or vinyl for your dining room. You can find stylish laminate that has a greater thickness, making it slightly more durable, and you can also find vinyl that is quite stylish and available in a wide range of colors and patterns. These options are especially suitable for high traffic areas.