Hi

The listed code in the book (Beginning ASP.NET.1.0 using VB.NET, Chp 13, Manipulating Data Sources, pp 446-447)

        Dim objRows() As DataRow

        objRows = objTable.Select("FirstName='Margaret' AND LastName='Peacock'")
        objRows(0).Item("FirstName") = "John"
        objRows(0).Item("LastName") = "Hatford"

        dgNameList3.DataSource = objTable.DefaultView
        dgNameList3.DataBind()

produces

Exception Details: System.IndexOutOfRangeException: Index was outside the bounds of the array.

Source Error:


Line 49:
Line 50: objRows = objTable.Select("FirstName='John' AND LastName='Hatford'")
Line 51: objRows(0).Item("FirstName") = "Margaret"
Line 52: objRows(0).Item("LastName") = "Peacock"
Line 53:

I cannot see anything in the erratum list regarding this but it does seem to of been an issue (the archive post had no solution listed).

Any ideas?

Thanks

I managed to resolve this by examining the database itself and seeing that the error was caused by the fact that

a) the record selected for amendment didn't exist
b) the suggested change for the record already existed as a current
   record

Once I changed the physical table record to mirror the search criteria i.e.

 objRows = objTable.Select("FirstName='Margaret' AND LastName='Peacock'")

the ASP.NET page performed as required.

Not the most helpful of error messages.