Updating a specific Row in a DataSet

[Guest]

I am trying to update a specific row in a dataset without knowing it's Key
Identity all I have is the value of the "Email" collumn.

I have tried: DataSet5.Tables("Customers").Rows.Find(Email) but that
generates an error.

What is the best way to do this?

Thanks, Justin.

 

[Karl Seguin]

You can use SELECT instead of find...

dim foundRows as DataRow() = DataSet5.Tables("Customers").Select("Email = '"
& email & "'")

if foundRows.Length = 1 then 'the row was found
dim row as DataRow = foundRows(0)
....
else 'row wasn't found
...
end if