Newbie - need to round field to 2 decimal places

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Linq;

namespace EE_Q28744239
{
	class Program
	{
		static readonly List<Order> orders = new List<Order>();

		static void Main(string[] args)
		{
			orders.AddRange((from i in Enumerable.Range(0, 10) select new Order() { ID = i, Name = string.Format("Order{0}", i), Quantity = ((i + 5) * 2) }));
			DataTable table = orders.ConvertToDataTable();

			for (int i = 0; i < table.Rows.Count; i++)
				Console.WriteLine("Quantity for {0} is: {1}", table.Rows[i]["Name"], Convert.ToDecimal(table.Rows[i]["Quantity"]).ToString("N2"));
			Console.ReadLine();
		}
	}

	class Order
	{
		public int ID { get; set; }
		public string Name { get; set; }
		public int Quantity { get; set; }
	}

	static class Extensions
	{
		public static DataTable ConvertToDataTable<T>(this IEnumerable<T> source)
		{
			var properties = TypeDescriptor.GetProperties(typeof(T));
			var table = new DataTable();
			foreach (PropertyDescriptor property in properties)
				table.Columns.Add(property.Name, Nullable.GetUnderlyingType(property.PropertyType) ?? property.PropertyType);

			foreach (T item in source)
			{
				DataRow row = table.NewRow();
				foreach (PropertyDescriptor property in properties)
					row[property.Name] = property.GetValue(item) ?? DBNull.Value;
				table.Rows.Add(row);
			}
			return table;
		}
	}
}

Select all Open in new window

// Provides the same output as using N2
Convert.ToDecimal(table.Rows[i]["Quantity"]).ToString("0.00")

Select all Open in new window