Regarding the page 72 Try It Out. After completing this Try It Out and entering the primary key values suggested in step 10, I do get messages indicating the correct Person. However, the program is stuck on the Jefferson record and does not navigate to any other. What am I missing in the implementation?

I ran into the same problem.

Hard to believe the Rows.Find does not tell the binding source to change to the newly found record?

I couldn't find anything on the Find but I did manage to scrounge this method which works.

Add this line after the
MessageBox.Show(CType(Rowlocated(1), String)) line:

Me.PersonBindingSource.Position = _
   Me.PersonBindingSource.Find("PersonID", _
   CType(pkvalue, Integer))



Note: That's all in one line. I used the underscore line continuation to break it.

That line will position the Binding Source to the record that is found by matching the "PersonID" column name (or property) with the value in pkvalue.

Oddly enough, this will work for any Column Name too.

Me.PersonBindingSource.Position = _
  Me.PersonBindingSource.Find("City", "Chicago")

Insert this line and the Binding Source position will be changed to the first record with the City name of Chicago.

I still think the FIND method is supposed to position the binding source to the "FOUND" record though.

It may be another one of those "quirks" of VB 2005 like the "Copy If Newer" table adapter update problem.

I'm still looking to see what I can "Find"!

Hi FinFinatic,

Your posting was a big help. I spent several hours trying a variety of ways to position the record. I tried your solution and it worked.

My guess is that this doesn't have to be so difficult. I think what I need is a book that describes the methods from the following objects and how to use them together:

TableAdapter
DataSet
BindingSource
DataView
QueryBuilder

Your solution is a good example, using a DataSet method to get the record number and a BindingSource method to position the record.

If you find a good book, please post or you can send me e-mail at [email protected].

Thanks
Charles

Very nice fix, FinFanatic. Much appreciated!

Leon,

Here's a site that I have found to be a big help.

http://www.asp.net/QuickStart/howto/...ataFromDB.aspx

Don't forget the DataRow among the things you need to look at. Adding, Updating, and Deleting can be accomplished through the DataRow. See the examples in the site link above.

I've moved on from this book to some project(s) more relevant to my own programming needs, and I've found that just about any question you have can be answered by persistent searching on the web.

It's nice to have some good examples to fall back on occasionally, so I'm still in the market for a good SQL-VB-Database book myself.

Baseman: Thanx. Nothing more frustrating than an example that is supposed to work, but doesn't IMO.

Thanks FinFanatíc!

This was of great help.

Here is an interesting link for DataGridView:
http://forums.microsoft.com/MSDN/Sho...52467&SiteID=1

Sten-Gunnar