Last post May 11, 2009 10:51 AM by ricka6
May 11, 2009 02:21 AM|nishant23|LINK
I created a simple Dynamic Website web application i am able to see my table data but i am not able to edit/update that. The column is not visible to me. Is there any property that i have to set to enable it?
Please reply me ASAP
May 11, 2009 04:55 AM|sjnaughton|LINK
are you saying you cannot edit the table or just onw column in the table? [:D]
May 11, 2009 05:02 AM|nishant23|LINK
Yes you are right i am not able to see that column. I debug the code and found on property "table.Isreadonly", i am getting true value.
can you help me out in this?
May 11, 2009 05:10 AM|sjnaughton|LINK
For a table to be read write it MUST have a primary key defined, also views are real only by default. What model are you using Linq to SQL or Entity Framework?
May 11, 2009 05:21 AM|nishant23|LINK
I am usnig Linq model. also i already defined a primary key in the table still i ma not able to Edit/Details column
May 11, 2009 05:58 AM|sjnaughton|LINK
The only thing I can suggest is try Northwind and see if that works in Edit/Insert mode if not you have an issue with your install or connection to the DB.
May 11, 2009 10:51 AM|ricka6|LINK
Steve is right, you need to have a PK. Try to reproduce the problem with NorthWind or AdventureWorksLT. The hidden column is probaly a FK and you just don't recognize it.