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 you've 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 didn't 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.

It's worth a second and third glance.

[Robby]

true