How to navigate through DataSet, like Recordset ...

[Mischamel]

... while showing DataFields in BindingCollections of TextBoxes ??

 

[Robby]

Look into the using the CurencyManger with a DataTable.

 

[Nerseus]

The easiest way is through a Forms BindingContext property. If youve bound your textbox like so:

// Text is the property on the TextBox control
// FirstName is a column in the DataTable Table1
textBox1.DataBindings.Add("Text", myDataSet.Tables["Table1"], "FirstName");

Then you can navigate forward/backwards like so:

this.BindingContext[myDataSet.Tables["Table1"]].Position++;

You can also create your own CurrencyManager, as Robby suggested. Especially if you need multiple "pointers" into the same DataTable.

-Nerseus

 

[Robby]

Cool, I didnt know that method.

 

[Mischamel]

is the C# code identic to vb 7 ??

 

[Robby]

In this case they are the same, change this to Me and the [ ] for ( ).

 

[APaule]

plus you have to change "++" to "+=1" or "-=1" depending on the direction you want to navigate to.

And yes Robby the CurrencyManager is a great deal.
Its worth a second and third glance.

 

[Robby]

true