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

on Feb 28, 2013 10:35 PM

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.number };



Download FREE API for Word, Excel and PDF in ASP.Net: Download
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();