Posts

Showing posts from December 3, 2018

Athens (village), New York

Image
This article is about the village in New York. For other uses, see Athens (disambiguation). Village in New York, United States Athens, New York Village Village of Athens, Sept. 2007 Athens Show map of New York Athens Show map of the US Coordinates: 42°16′2″N 73°48′45″W  /  42.26722°N 73.81250°W  / 42.26722; -73.81250 Coordinates: 42°16′2″N 73°48′45″W  /  42.26722°N 73.81250°W  / 42.26722; -73.81250 Country United States State New York County Greene Town Athens Area  • Total 4.6 sq mi (11.9 km 2 )  • Land 3.4 sq mi (8.9 km 2 )  • Water 1.2 sq mi (3.1 km 2 ) Elevation 26 ft (8 m) Population (2010)  • Total 1,668  • Estimate  (2016) [1] 1,609  • Density 360/sq mi (140/km 2 ) Time zone UTC-5 (Eastern (EST))  • Summer (DST) UTC-4 (EDT) ZIP Code 12015 Area code(s) 518 FIPS code 36-02902 GNIS feature ID 0942663 Website www.visithistoricathens.com Athens is a village

Round cell values of a datatable (VB.NET)

Image
up vote 0 down vote favorite I have trouble rounding some cells from my datatable. I want this round to 2 decimal places, as you can imagine. I will explain quickly how I charge data to the DataTable : I have this function stored in a class: Protected Friend Function cargarPref(ByVal id_Pref As String) As DataTable Dim cmd As String = "Select Material,Cubicaje,SubTotal,ITBM,Total from Preferencia WHERE Id_Preferencia=@id_Pref" Dim t As New DataTable Try con.Open() comando = New OleDbCommand(cmd, con) comando.Parameters.AddWithValue("@id_Pref", id_Pref) adapter = New OleDbDataAdapter(comando) adapter.Fill(t) comando.Dispose() adapter.Dispose() con.Close() Catch ex As Exception MsgBox("Error en la consulta