What's wrong with my code inner join in linq to sql?

Question

What's wrong with my code? For the Employee table and the table Project are underlined in red ...

Thanks in advance!

 DataContext db = new projfuncionarioDataContext();


        var query = from p in db.Funcionario
                    join c in db.Projeto on p.Cdfunc equals c.Cdfunc
                    select new
                    {
                        ID = p.Cdfunc,
                        Produto = p.Nome,
                    };

        GridView1.DataSource = query;
        GridView1.DataBind();

Answer 1

Try:

GridView1.DataSource = query.ToList();

Answer 2

Does your GridView have the AutoGeneratedColumns property set?

Answer 3

DataContext db = new projfuncionarioDataContext(); 

Should be:

projfuncionarioDataContext db = new projfuncionarioDataContext();