I've got a text box search that is responding to a _TextChanged event.

I've connected to the database and written a SQL statement.

Then I have:

Dim Matches as New OleDbDataAdapter(SQLStmt, OleDbConnection1)
Dim Matches As New OleDBDataAdapter(SQLStmt, OleDbConnection1)
MatchesDataSet = New DataSet
Matches.Fill (MatchesDataSet, "MatchingRecord")
lbMatches.DataSource = MatchesDataSet.Tables("MatchingRecord")


When I search in txtSearch, lbMatches displays one name for a brief moment, then displays "System.Data.DataRowView" for each instance of name that should appear in the box.

I'm using an Access Database and MatchingRecord is a class.

I see no DataTextField or DataValueField parameters. Are these set? I think that may be your problem. I remember having that error before, and I think it is in relationto that.

Also, I should say it this way, there is no databinding set up is what it seems like the problem is, so you can set it up through the databindings property also.

This might be helpful to you, but I'm not sure what it means.

I programed an Try Catch for an error message. The message tells me: "Got this exception: 'System.InvalidOperationException: ExecuteNonQuery: Connection property has not been intialized at ......

What does this mean?

The ExecuteNonQuery method is a Command object method that executes the SQL with no results returned. However, Connection property has not been initialized would suggest no connection string was passed into the OLEDBConnection object. How do you set up your connection?

To set up my connection, I used the DataAdapter wizard. My code states OleDbConnection1.open.

For a brief second, I can see one of the names in the database, then it goes away and the System.Data.DataRowView displays in the list box. I think I am connecting to the database because I put in:

If OleDbConnection1.state <> ConnectionState.open Then
    MsgBox("...")
    End
End If

I'm not getting my message box.

I tried setting the DataBinding Property in the Properties box to the DataSet, but I got the same result.

I'm still reading up on data binding, so I'm not sure how to hard code it yet.

I've got the .displaymember and .valuemember set in the form_load event. Still the same thing.

I've had this problem in the past, but now can't remember what was the problem. If I remember, I'll let you know. The only thing that is strange to me is that it is a System.Data.DataRowView, but the data source is a DataTable. Maybe that's correct, I don't know.

Sorry I couldn't be more help.