Bound Controls and DataView, BindingContext

[nina98765]

Hi all

I have a data-bound Windows form bound to a strongly-typed dataset. Upon opening the form, I would like to Find a specific record based on a parameter I've passed to the form, and display the data in the appropriate textboxes, etc. I would also like to have the entire table opened (i.e., not just the one record I've found) as I would like to navigate through the records

My table is called "AP_TBL_Vendors .

The problem is that I would like to find the record based on the column "Vendor_ID" yet I want the entire table to still be sorted by "Vendor_LastNam e." (This because when scrolling through records I would like to see them in alpha-order.) The way I understand it, in order to find a row and pass the row to my BindingContext in order to display it's contents on my form, I have to use the Find method of a DataView (i.e. not the Find method of the DataTable, as that will return a DataRow and not an Integer with the position of a Row). In order to do that I have to set the Sort of the DataView to "Vendor_ID. " When I do that, my Find method returns the Row's position in THAT view, and then passes that value to my BindingContext which brings up the wrong Row because I have my DataTable sorted by "Vendor_LastNam e.

How can I keep my records sorted by "Vendor_LastNam e" and yet do a Find based on "Vendor_ID"

A secondary question -- why does the following code work
Me.BindingConte xt(DsVendors1, "AP_TBL_VENDORS ").Position = intRe
when the following code does not
Me.BindingConte xt(DsVendors1.A P_TBL_VENDORS). Position = intRe
if my dataset is strongly typed? What would the proper syntax be in order to take advantage of the strongly-typed dataset's built-in table

Thanks for your help