Александр Тер

private void Window_Loaded(object sender, RoutedEventArgs e)
        {
            tables.ItemsSource = fillGrid();
        }

		public class Employee
        {
            public string EmployeePhone { get; set; }
            public string EmployeeId { get; set; }
            public string EmployeePib { get; set; }
            public string EmployeeEmail { get; set; }
            public string EmployeeMessage { get; set; }
            public string EmployeeIp { get; set; }
            public string EmployeeDate { get; set; }
        }
		
        public List<Employee> fillGrid() {
            MysqlConn Conn = new MysqlConn();
            MySqlDataReader reader = Conn.ConnectionDataBase(Con.RetSet("Host"), Con.RetSet("User"), Con.RetSet("DB"), Con.RetSet("Pass"), "SELECT * FROM s");

			var _list = new List<Employee>();
			
            while (reader.Read())
            {
				var tabl = new Employee()
				{
					EmployeeId = reader["id"].ToString(),
					EmployeePib = reader["pib"].ToString(),
					EmployeeEmail = reader["email"].ToString(),
					EmployeePhone = reader["phone"].ToString(),
					EmployeeMessage = reader["message"].ToString(),
					EmployeeIp = reader["ip"].ToString(),
					EmployeeDate = reader["send"].ToString()				
				};
              
                _list.Add(tabl);
            }

            Conn.Cls();
			
			return _list;
        }

private int GetNumOfLines(string multiPageString, int wrapWidth, Font fnt)
{
        var sfFmt = new StringFormat(StringFormatFlags.LineLimit);
        using(var g = Graphics.FromImage(New Bitmap(1, 1)))
       {
            var iHeight = g.MeasureString(multiPageString, fnt, wrapWidth, sfFmt).Height;
            var iOneLineHeight = g.MeasureString("Z", fnt, wrapWidth, sfFmt).Height;
            return (int)(iHeight / iOneLineHeight)
        }
}