Data binding directly to a store query (DbSet DbQuery DbSqlQuery) is not supported

saeed3164
 
on Feb 28, 2013 10:35 PM
11299 Views

how solve this problam

 Data binding directly to a store query (DbSet, DbQuery, DbSqlQuery) is not supported. Instead populate a DbSet with data, for example by calling Load on the DbSet, and then bind to local data. For WPF bind to DbSet.Local. For WinForms bind to DbSet.Local.ToBindingList().

 

 protected void Page_Load(object sender, EventArgs e)
    {
        testEntities MyDB = new testEntities();
       GridView1.DataSource = from P in MyDB.T2
       select new { P.age, P.id, P.number };
        GridView1.DataBind();

    
        
    }

 

Download FREE API for Word, Excel and PDF in ASP.Net: Download
saeed3164
 
on Mar 07, 2013 11:40 PM
 AccHomeEntities dbhome = new AccHomeEntities();
        BindingSource dbquery = new BindingSource();

dbquery.DataSource = (from P in dbhome.Stores
                          select new { P.FNameware }).ToList();
            dataGridView1.DataSource = dbhome.Stores.ToList();