Modifying rows [still problems :-( ]

[nacho2]

Hi folks! Going crazy here. I got a dataset filled and now I need to modify a row of one of its tables. I know I can do it like this:

Dataset.Table1.Rows(x).("Name")="John"

Being x the row index. Now, I DON'T KNOW THE ROW INDEX of the row I want to modify, I know which row I want to change but HOW DO I FIND OUT ITS ROW INDEX SO THAT I CAN RUN THE COMMAND ABOVE?

Thanks for your help!

[Pirate]

Use SQL UPDATE statement , using WHERE clause you can find the row by it's value .I'm sorry I can't give you an example now but try to search to save you some time.

[nacho2]

Nope! Won't help!

I'm not storing my data in a SQL DB. I'm storing my data in an xml document. But still that shouldn't make a diference, because what I'm trying to do now is to modify the dataset and once I've done that I'll update the DB (in my case an xml document). But even if I was working with an SQL DB I wouldn't know how to modify the row in the dataset.

What I am implementing is a button_click that makes the field 'erased' of a row of a table to go from false to true.

Thanks

[nacho2]

There is a bunch of command for selecting, updating and deleting rows of a dataset all of them used the row index... (like the command above) SO THERE HAS TO BE A WAY OF GETTING THE ROW INDEX, something like Dataset.Table.Rows.GetRowIndex("IdCustomer=2")...

Any ideas? I appreciatte.

[CaraCarogna]

icurrentpos=me.bindingcontext(dataset,"table").position '+1 if you need an offset

[jmcilhinney]

So you're saying you know the primary key of the row? If so:

Dataset.Table1.Rows.Find(pkValue)("Name")="John"

[maged]

icurrentpos=me.bindingcontext(dataset,"table").position '+1 if you need an offset

and how does this relates to us