hi there,

Dim queryString As String = "select avg(pumpnum) from petrol_table"

            Using adapter As New SqlDataAdapter(queryString, connectionString)

                Dim table As New DataTable
                adapter.Fill(table)

                Dim row As DataRow = table.Rows(0)
                TextBox5.Text = row.ToString

as the code stands now, all i get in the textbox is "system.data.datarow"
the column called "pumpnum" is a type "int" in sql.

could someone please, show me where i am going wrong.

Thanks :-)