vb.net Specified Select query OLEDB database

Question

Please help, im trying to show the specified data on datagridview with SELECT,FROM,WHERE clause:

Private Sub showdata()
    Dim identity As String = frmmgrusers.hdtxtid.Text
    Dim dbcommand As String
    dbcommand = "SELECT First_Name, Second_Name, Dob, ID_Card_No, Email, Username, [Password] FROM UsersTB WHERE ID='" & identity & "'"
    adt = New OleDbDataAdapter(dbcommand, dbconn)
    datatable = New DataTable
    adt.Fill(datatable)
    dgvusersreporting.DataSource = datatable
End Sub

But it shows nothing, This showdata() sub is written on a form load when users click a button from other form it will show a form with datagridview showed the specified data with ID. I tried to remove the WHERE clause:

dbcommand = "SELECT First_Name, Second_Name, Dob, ID_Card_No, Email, Username, [Password] FROM UsersTB"

And it show the data (weird...?) but i need only the specified data with ID

Answer 1

I can't believe it actually works... by this query "SELECT First_Name, Second_Name, Dob, ID_Card_No, Email, Username, [Password] FROM UsersTB where ID=" & identity & " " though didn't understand whats the difference of ID='" & identity & "' to ID=" $ identity $ " "