rman

navigation in DataSets Since I've seen that other programmers have similiar problems with trying to navigate through a DataSet, I want to quote something from the help of Visual Studio. In a chapter named something like "Introduction to DataSets": "...DataSets do not supply the concept of a current data row pointer..."

How can I navigate to a certain row in a DataSet? I have a DataSet with customer data, I want to reposition to the row where customerID = 4711 (the 'customerID' column is the primary key of the 'customer' table). Why do I want to do that? I think that's a standard problem: Having a list (DataGrid) of the "short version" of some data. Let's say: customer data. So you can see only the customer name. In this list you can only select a certain customer, but you can not modify the data. The DataSource for the list is DataSet1 (based on a database view). For modifying the data there are textboxes with DataSet2 (based on a database table) as their DataSource. So I want to reposition DataSet2 to that row where the customerID is the customerID of the current row of DataSet1. I'm relatively new into building data applications with .NET, but I have done years of programming with Progress 4GL (and with the 4GL the problem described here is not a problem...). However, so I'm not even sure, if my way of trying to solve the problem is a good way (with .NET). Better suggestions are welcome! Thanks, rman