Dim conn As New System.Data.OleDb.OleDbConnection() conn.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\temp\Database1.accdb" If conn.State = ConnectionState.Open Then conn.Close() conn.Open() Dim sql As String = "SHOW * From tbl_info Where AdminNo = '" & ListBoxassign.Items & "'" listboxassign.items.show(AdminNo)
Jump to Post
There is no Show statement. You need to use the Select statement.
All 7 Replies
Be a part of the DaniWeb community
We're a friendly, industry-focused community of 1.20 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.