RadGrid - Linq editing with select new { }

[mSchmidt]

Hi

I have a Grid bound as below, i am able to enter edit state on the TextBoxes however upon end edit the value entered is not persisted in the grid (meaning the datasource)

Why is this ?
If it is not possible to have a "select new { }" in the linq query and still edit, how should i then do this ?

            rounds.MasterGridViewTemplate.Columns.Clear();
            rounds.MasterGridViewTemplate.Columns.Add(new GridViewDataColumn("Hjemme", "tName") { Width = 120,ReadOnly=true });
            rounds.MasterGridViewTemplate.Columns.Add(new GridViewTextBoxColumn("Bane", "lane_HomeNum") { Width = 55, HeaderText = "Bane" });
            rounds.MasterGridViewTemplate.Columns.Add(new GridViewDataColumn("Ude", "tName2") { Width = 120, ReadOnly = true });
            rounds.MasterGridViewTemplate.Columns.Add(new GridViewTextBoxColumn("Bane Ude", "lane_awayNum") {  Width = 55, HeaderText = "Bane", DataType = typeof(int) });
            rounds.MasterGridViewTemplate.Columns.Add(new GridViewDataColumn("Anden dato", "round_id") { Width = 50, ReadOnly = true });
            rounds.MasterGridViewTemplate.AutoGenerateColumns = false;
            var q = from v in db.match_dbs
                    where v.round_id == roundID
                    select new { v.match_id,  tName =  v.team_db.team_name,v.lane_HomeNum,  v.lane_awayNum , tName2 = v.team_db1.team_name };

            rounds.DataSource = q;

[Jordan]

Hello mSchmidt,

What you see is normal behavior (except of the grid that allows to enter edit mode) because as stated in the MSDN documentation "Anonymous types provide a convenient way to encapsulate a set of read-only properties into a single object". The important part here is read-only, meaning that you have bound RadGridView to a read-only view of your data and that is why the changes are not persisted.

If you want the changes to be persisted you will not have to use the select new { v.match_id,  tName =  v.team_db.team_name,v.lane_HomeNum,  v.lane_awayNum , tName2 = v.team_db1.team_name }
statement.

For example you could just try "select v", in which case you should have no problems.

Hope this helps. Do not hesitate to write if you have more questions.

Greetings,
Jordan
the Telerik team

Check out Telerik Trainer, the state of the art learning tool for Telerik products.