adding last row of dataset to datagridview

[don420]

i want to add the last row of the dataset but it is only displaying System.Data.DataRow in one of the colums
here is my code


con.Open()
cmd = New SqlClient.SqlCommand("select product,Quantity,MRP,Sale_Rate,Disc_Amt,Amt from sale_table ", con)
adapter.SelectCommand = cmd
adapter.Fill(ds)
Dim r As Integer = ds.Tables(0).Rows.Count
Dim NewRow As DataRow
NewRow = ds.Tables(0).Rows(r - 1)
Form1.DataGridView1.Rows.Add(NewRow)
adapter.Dispose()