REPOST: Column [blah] Is Readonly on Datagrid UpdateCommand event

  • Thread starter Thread starter Learning SQL Server
  • Start date Start date
L

Learning SQL Server

Forgive the repost, but this is really troublesome and I hope SOMEONE can
shed some light on it.

I am trying to update a datarow via in-place editing from a dataset stored
in session.

When I try to write the new value into the selected row, I always get the
following error : Column [blah] is read-only.

in my UpdateCommand event I have:

' obtain the dataset saved in session on first page load.
dim objDS as DataSet = Ctype(Session("foo"), DataSet)

' then select the row I want to update from the first table in the
collection,
' using the text in the second cell as the criteria.
If IsNothing(objDS) = false then
dim objDT as DataTable = objDS.Tables(0)
dim objRow as DataRow = objDT.Select("Type=" +
e.Item.Cells(1).Text.ToString)

' TERMINATES ON THIS LINE:
objRow(0)("Column1") = CType(e.Item.Cells(2).Controls(0), TextBox).Text
...
End If

When I check the Immediate window to find out what the state of my dataset
is, all the columns have the following attribute set:
Readonly = true

And I have no idea why this is. Is it because the dataset is being pulled
from a session variable???

I am following the example provided in Dino Esposito's text Building Web
Solutions with ASP.NET and ADO.NET. This doesnt work though. Why?
 
Solved. Hooray for me. Maybe someone can clarify this:
I stumbled across a posting elsewhere that recommended looping through each
column and setting the ReadOnly attribute to "False". And this caused the
update to occur properly. The column is not a key, and its not a view (it is
a table), so why would these start as Readonly to begin with???
 
Back
Top