I am using access 2007 and created data view while using query below my grid is showing only expr1000
Try
Dim con As New System.Data.OleDb.OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Caller.accdb")
con.Open()
Dim cmd1 As New OleDbCommand("SELECT DISTINCT no FROM x ", con)
Dim da1 As New OleDbDataAdapter(cmd1)
Dim dt As New DataTable()
da1.Fill(dt)
DataGridView2.DataSource = dt
Catch ex As Exception
End Try
Go to the complete details ...