How to get Position of a Row ....

[Mischamel]

.... which col has a certain content, f.ex.

 

Table A -> col.: ID= 4

 

Dataset.Table.select("Select Id = 4 ") didn´t work, to get the row as active or actual showing row on application.

 

Any other ideas ?

[quwiltw]

Select will do the trick but just use:

Dataset.Table.select("id=4")

or you could use the Find method of the DataView. For some reason I usually find myself using that instead.

[Mischamel]

Sorry, but Select doesn´t work.

 

Dataset12.PAM.Select("TicketID=' " & TextBox20.Text & " ' ")

What am I doing wrong ??

[jfackler]

What you have called is the select method on the data table PAM.

The select method is used to filter and sort the rows of a Data Table at run time. It returns an array of data rows. In contrast, the DataView (although it provides much of the same functionality) has a number of advantages. Because data views are distinct objects, they can be created and configured at both design and run time, making them easier to implement in many situations. DataViews can be used as the data source for bound controls, unlike the array of DataRows returned from the Select method.

What are you trying to accomplish? If you are trying to iterate through the rows or are attempting to bind multiple controls to a row, the bindingcontext is what you are looking for.

 

Jon