By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,939 Members | 1,638 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,939 IT Pros & Developers. It's quick & easy.

REPOST: Column [blah] is readonly on Datagrid UpdateCommand event

P: n/a
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?


Nov 17 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Almost every field in the dataset model that would actually be useful is
Read Only. Thats my biggest complaint with the stupid thing.
"Learning SQL Server" <no.mail.com> wrote in message
news:OO**************@TK2MSFTNGP10.phx.gbl...
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???

"Learning SQL Server" <no.mail.com> wrote in message
news:Om**************@TK2MSFTNGP10.phx.gbl...
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?




Nov 17 '05 #2

P: n/a
Bob:

Thanks for the reply.

That IS silly. Additionally, I see very little in (at least my)
books/documentation that discusses the Readonly attribute being the default
state for the DataColumn object in a DataTable (it is NOT discussed in the
example of this book I am reading).

"Bob Johnson" <bo**********@ncmail.net> wrote in message
news:eJ*************@TK2MSFTNGP12.phx.gbl...
Almost every field in the dataset model that would actually be useful is
Read Only. Thats my biggest complaint with the stupid thing.
"Learning SQL Server" <no.mail.com> wrote in message
news:OO**************@TK2MSFTNGP10.phx.gbl...
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???

"Learning SQL Server" <no.mail.com> wrote in message
news:Om**************@TK2MSFTNGP10.phx.gbl...
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?





Nov 17 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.