Problem in DataGridView binding with LINQ?

Question

When i bind my linq query to the datasource of the datagridview, i cannot change any of the cells values in the gridview. The columns readonly property is automatically set to true and when i tried to set it false it gives following exception:-

DataGridView column bound to a read-only field must have ReadOnly set to True. LINQ

This is my code for it

 DataClasses1DataContext db = new DataClasses1DataContext();
 var selectquery = from s in db.Sarees where s.Bill.BillNo == billno select new { s.BillID,s.Price };

I found 1 solution to this problem which is not filthy if there are many columns in the table and i want to select only two... The 1 solution is :-

 var selectquery = db.Sarees.Where(s => s.Bill.BillNo == billno);

When i gave this query it works fine.. But i want a solution in which i can select only some columns by LINQ and can change its value when binded through a datagridview...

hunter · Accepted Answer · 2011-04-07 13:17:50Z

2

The problem is that this query does not return a collection of Sarees so it cannot be edited like you want. It is a returning a collection of new objects with a BillID and a Price property.

DataClasses1DataContext db = new DataClasses1DataContext();
var selectquery = from s in db.Sarees
                  where s.Bill.BillNo == billno 
                  select new { s.BillID, s.Price };

Can you use a version of the 2nd query and bind only the columns you want to edit to the DataGridView?

You may also need to explore using the DataGridView.CellFormatting Event.

edited Apr 7, 2011 at 13:17

answered Apr 7, 2011 at 13:09

hunter

63.7k19 gold badges115 silver badges115 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Marshal Over a year ago

How to use the second version and bind only some columns (eg. ID and Price) ?

hunter Over a year ago

That's where the CellFormatting Event comes into play. Even then, I don't know if the field changes will automatically be updated. I don't think it was intended to save objects with depth like the OP is asking.

Collectives™ on Stack Overflow

Problem in DataGridView binding with LINQ?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related