Load a DataGridView using Linq to SQL

How can I use Linq-To-SQL to load a DataGri开发者_运维百科dView?

Would the following work?

DCDataContext db = new DCDataContext();
dataGridViewJobs.DataSource = db.jobs.Select(p => p.closeDate <= DateTime.Now);

---

Winforms :

Alternately You can use BindingSource and DataGridView. You can give your Linq to SQL entity as DataSource to BindingSOurce. BindingSource will work as Datasource to DataGridView.

bindingSource1.DataSource = items;
dataGridView1.DataSource  = bindingSource1;

You can find how To here.

ASP.Net :

Yes it will work. Please check this CodeProject article for step by step How to.

---

Yes. But you should change your query, since select is not used for querying like in sql but for projecting the elements of a sequence into a new form.

The following example should work:

   DCDataContext db = new DCDataContext();
    dataGridViewJobs.DataSource = (from jobs in db.jobs
                                    where p.closeDate <= DateTime.Now
                                    select jobs);