C
christing
Guest
Yesterday my program run smooth and all function can be run. But today when i run my program my program get a error message (Syntax error in FROM clause.)
How i can solve this issue.
Private Sub RefreshData()
If Not app.State = ConnectionState.Open Then
app.Open()
End If
Dim da As New OleDb.OleDbDataAdapter("SELECT ID, UserID as [ItemName], " & _
"Name as [Name]" & _
"FROM USER ORDER BY ID", app)
Dim dt As New DataTable
da.Fill(dt)
Me.dgv.DataSource = dt
app.Close()
End Sub
Continue reading...
How i can solve this issue.
Private Sub RefreshData()
If Not app.State = ConnectionState.Open Then
app.Open()
End If
Dim da As New OleDb.OleDbDataAdapter("SELECT ID, UserID as [ItemName], " & _
"Name as [Name]" & _
"FROM USER ORDER BY ID", app)
Dim dt As New DataTable
da.Fill(dt)
Me.dgv.DataSource = dt
app.Close()
End Sub
Continue reading...