Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  General SQL Server Forums  New to SQL Server Programming  readonly table when retrieving single fields

Author  Topic  xinner Starting Member 1 Post Posted - 2009-03-25 : 21:48:06 Hi everybody, I hope you will help me solving a problem that is driving me crazy! I have a Grid1 bound to a table (Soggetti) via a bindingsource (bsClienti), and I need to edit its values in the its cells. Now: if a set 1) bsClienti.DataSource = From s In DsSoggetti.Soggetti Select s then everything works, but if I try to get single fields in this way: 2) bsClienti.DataSource = From s In DsSoggetti.Soggetti Select _ NID = s.NID, LastName = s.Cognome_RagioneSociale, FirstName = s.Nome then it doesn't work any longer. After a long inspection I found that in case 1) the ReadOnlyProperty is False for all the fields and I can freely edit, while in case 2) the ReadOnlyProperty is False for all the three fields and this prevents me from editing. Can someone explain this strange behavior? Provided that I need to retrieve just particular fields from different table how do I go over this problem? Thank you Francesco Belviso