Updating a specific Row in a DataSet

[Justin]

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

--
MY ASP.Net tutorials
http://www.openmymind.net/ - New and Improved (yes, the popup is annoying)
http://www.openmymind.net/faq.aspx - unofficial newsgroup FAQ (more to
come!)
"Justin" <Ju****@discussions.microsoft.com> wrote in message
news:E3**********************************@microsof t.com...

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.