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()
When I tried to run the application I got the following error it was resolved. You need to use the result of the query as datasource for your combobox.
In this example, I want to bind the list countries to a combobox using c# .net.
private void LoadCountries()
{
var countries = (from c in db.Orders
select new { c.ShipCountry }).Distinct().ToList();
cboCountry.DataSource = countries;
cboCountry.ValueMember = "shipcountry";
cboCountry.DisplayMember = "shipcountry"; }
Post your comments / questions
Recent Article
- How to fix HAXM is not installed |in Android Studio
- How to fix CMOS Checksum Error in Computer or Laptop | SOLVED
- Reactivating windows after a Hardware change on PC or Laptop
- FIXED: Windows reported that the hardware of your device has changed. Error code :0xc004F211
- "redirect" is not defined pylance("reportUndefinedVariable)
- This action cannot be completed because the file is open in SQL Server(SQLEXPRESS) - FIXED
- Unicode error 'unicodeescape' codec can't decode bytes in position 2-3: truncated UXXXXXXXX escape
- Could not find the 'angular-devkit/build-angular:dev-server' builder's node package | Angular Error
Related Article