Simplest way to use a DatagridView with Linq to SQL

Question

Hi, I have never used datagrids and such, but today I came across a simple problem and decided to "databind" stuff to finish this faster, however I've found that it doesn't work as I was expecting.

I though that by doing something as simple as:

 var q = from cust in dc.Customers
         where cust.FirstName == someString
         select cust;

 var list = new BindingList<Customer>(q.ToList());
 return list;

Then using that list in a DataGridView1.DataSource was all that I needed, however, no matter how much I google, I can't find a decent example on how to populate (for add/edit/modify) the results of a single table query into a DataGridView1. Most samples talk about ASP.NET which I lack, this is WinForms.

Any ideas?

I've came across other posts and the GetNewBindingList, but that doesn't seem to change much.

What am I missing (must be obvious)?

Thanks in advance.

Martin.

Answer 1

You can just bind the IQueryable result to the DataGridView, not sure why you converting it to a BindingList, is there a specific reason for that?

Answer 2

You might have a look at the TableList<T> from this post - based on BindingList<T>, but with hooks into the data-context.

Answer 3

Just bind it.

    var q = from cust in dc.Customers
            where cust.FirstName == someString
            select cust;
    DataGridView1.DataSource = q

No need to convert it to list.

Answer 4

What I really was looking for was for the simplest way, I found it: here.

Thanks to all who replied and gave ideas.