How to bundle gridview using linq / Entity Framework?

Question

I need to bind a GridView , I use this code:

  ProductDBEntities db = new ProductPDBEntities(); var pro = from u in db.Products where u.PID == 1 select u; if (pro != null) { GridView1.DataSource = pro; GridView1.DataBind(); } 

and get this error.

System.InvalidOperationException: Sequence contains more than one Element

Can someone please tell me what I am doing wrong?

Answer 1

Check Duplication , and then try linking it.

I edited my last answer to display the full code:

 ProductDBEntities db = new ProductPDBEntities(); GridView1.DataSource = (from u in db.Products where u.PID == 1 select u).First(); GridView1.DataBind(); 

Answer 2

This code might be useful:

  gv.DataSource = (from u in db.Products .First(u=> u.PID==1)).ToList(); 

If you have a table and a table in detail can use this:

  gv.DataSource = (from a in context.tblorder.First(p => p.id == 19).tblorderdetail where a.ID == 19 select a).ToList(); 

Answer 3

You can check your details first to see if there is more than one product with PID = 1.

Secondly, you can use the .First () method to make sure that you get only one result for binding:

 var pro = (from u in db.Products where u.PID == 1 select u).First(); 

Answer 4

I think you need to do ToList() when added to a DataSource :

 ProductDBEntities db = new ProductPDBEntities(); var pro = from u in db.Products where u.PID == 1 select u; if (pro != null) { GridView1.DataSource = pro.ToList(); GridView1.DataBind(); } 

Note. Since this is a GridView , you need to take n number of rows. No row limit .

Answer 5

Save the object type variable and assign the object type as the data source for the grid