NpgsqlConnection conn = new NpgsqlConnection(connection);
                        conn.Open();
                        string sql = db.GetDetFromDB(coords, percent);
                        NpgsqlDataAdapter da = new NpgsqlDataAdapter(sql, conn);
                        ds.Reset();
                        da.Fill(ds);
                       
                        dt = ds.Tables[0];
                       
                        
                        DataColumn Hcolumn = new DataColumn(); Hcolumn.DataType = System.Type.GetType("System.Decimal");
                        Hcolumn.ColumnName = "Scale H"; Hcolumn.Expression = String.Format(" {0} /height", coords[0]);
                        DataColumn Lcolumn = new DataColumn(); Lcolumn.DataType = System.Type.GetType("System.Decimal");
                        Lcolumn.ColumnName = "Scale L"; Lcolumn.Expression = String.Format( "{0} /length ", coords[1]);
                        DataColumn Wcolumn = new DataColumn(); Wcolumn.DataType = System.Type.GetType("System.Decimal");
                        Wcolumn.ColumnName = "Scale W"; Wcolumn.Expression = String.Format("Math.Round(Math.Abs({0} /width),3)", coords[2]);
                        DataColumn Pcolumn = new DataColumn(); Pcolumn.DataType = System.Type.GetType("System.Decimal");
                        Pcolumn.ColumnName = "Deviation";
                        Pcolumn.Expression = String.Format("( ( (height-{0})/{0}*{3} ) + ( (length-{1})/{1}*{3} ) + ( (width-{2})/{2}*{3} ) )/3",coords[0],coords[1],coords[2],percent);

                        dt.Columns.Add(Hcolumn); dt.Columns.Add(Lcolumn); dt.Columns.Add(Wcolumn); dt.Columns.Add(Pcolumn);
                        dataGridView1.DataSource = dt;
                       
                        conn.Close();