How to bind gridview using linq/Entity Framework?

Question

I need to bind GridView, I am using 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 getting this error.

System.InvalidOperationException: Sequence contains more than one element

Can somebody please tell me what am I doin wrong?

I think you will need to convert it to ToList() for it to work as DataSource for a gridview — V4Vendetta
– V4Vendetta, Commented May 3, 2011 at 11:59
i tried ToList function its give me this error .. Data source is an invalid type. It must be either an IListSource, IEnumerable, or IDataSource ELAPDBEntities db = new ELAPDBEntities(); var assetFinan = from u in db.AssetFinancings where u.AppID == AppID select u; if (assetFinan != null) { gvAssetFinance.DataSource = assetFinan.ToList(); gvAssetFinance.DataBind(); } — Kay
– Kay, Commented May 3, 2011 at 12:15
You don't need ToList(). You can bind an IEnumerable to a GridView. And pro in your code is an IQueryable which is an IEnumerable. The exception makes no sense in the context of the code you have shown above. On which line do you get exactly this exception when you debug? — Slauma
– Slauma, Commented May 3, 2011 at 12:31

AwkwardCoder · Accepted Answer · 2015-12-24 17:06:50Z

3

Check Duplication and then try to bind it.

I have edited my last answer in order to display the complete code :

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

edited Dec 24, 2015 at 17:06

AwkwardCoder

25.8k29 gold badges86 silver badges160 bronze badges

answered May 3, 2011 at 12:11

Nasser Hadjloo

12.7k15 gold badges71 silver badges102 bronze badges

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

2 Comments

Kay Over a year ago

thanks for that .. but i m having problem displaying. getting error .. can you post your code how do you bind the gridview ?

Slauma Over a year ago

First() returns a Product object. I don't think that this object has a ToList() method, has it?

jonsca · Accepted Answer · 2012-09-30 10:31:37Z

1

This code may be helpful:

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

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

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

edited Sep 30, 2012 at 10:31

jonsca

10.5k26 gold badges56 silver badges63 bronze badges

answered Aug 1, 2012 at 5:37

atefeNaeni

111 bronze badge

Comments

Cylon Cat · Accepted Answer · 2011-05-03 12:01:52Z

0

First, you might check your data to see if there's more than one product with PID = 1.

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

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

answered May 3, 2011 at 12:01

Cylon Cat

7,2192 gold badges27 silver badges34 bronze badges

Comments

Austin Henley · Accepted Answer · 2012-10-20 20:08:21Z

0

Store the variable to object type and assign the object type as datasource to grid

edited Oct 20, 2012 at 20:08

Austin Henley

4,63313 gold badges49 silver badges80 bronze badges

answered Jun 18, 2012 at 9:56

Azeem

1

Comments

Ali · Accepted Answer · 2017-07-15 18:56:35Z

0

I think you have to do ToList() when to add to 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: As it is a GridView, has to take n number of rows. No row limit.

edited Jul 15, 2017 at 18:56

Ali

3,4676 gold badges45 silver badges56 bronze badges

answered May 3, 2011 at 12:49

anishMarokey

11.4k2 gold badges36 silver badges47 bronze badges

Comments

Hüseyin Biçen · Accepted Answer · 2018-12-31 11:45:11Z

0

I solve like this:

ProductDBEntities ctx = new ProductDBEntities ();
var q1 = ctx.Products.Where(x => x.PID == 1).ToList();
GridView1.DataSource = q1;
GridView1.DataBind();

I try it. It's work.

answered Dec 31, 2018 at 11:45

Hüseyin Biçen

214 bronze badges

Collectives™ on Stack Overflow

How to bind gridview using linq/Entity Framework?

6 Answers 6

2 Comments

Comments

Comments

Comments

Comments

I solve like this:

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

6 Answers 6

2 Comments

Comments

Comments

Comments

Comments

I solve like this:

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related