Get ID of item selected in ComboBox

c# entity-framework linq winforms

Question

I possessComboBox It has entries from my database in it. I'm attempting to getID of the object that has been chosen in theComboBox nonetheless, nothing I have done seems to be working.

int id = cbbilar.SelectedIndex + 1;

This is how I now have it; however, it is very inefficient and becomes unusable if the database's initial contents are deleted.

var cars = (from z in db.Bilar 
            select new { Value = z.Id, Names = z.Marke.Namn + " "  + z.Namn }).ToList();
cbbilar.DataSource = cars;
cbbilar.DisplayMember = "Names";
cbbilar.ValueMember = "Value";
cbbilar.SelectedIndex = 0;

This is my security code.Combobox . How do I get it to get theID of theSelectedItem ?

1
3
10/28/2016 12:17:41 PM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Accepted Answer

ZZZ_tmp
2
10/28/2016 11:53:46 AM

Popular Answer

Here is what I accomplished:

comboBoxPickupLoc.DataSource = pickupLocationRepo.GetPickupLocations();
comboBoxPickupLoc.DisplayMember = "LocationName";
comboBoxPickupLoc.ValueMember = "Id";
comboBoxPickupLoc.SelectedIndex = -1;

then, as seen below, you may get the Id value.

  object value = comboBoxPickupLoc.SelectedValue;
  MessageBox.Show(value.ToString());

Thanks.

user2662006

Related Questions

Select * from Entities where Id = (select max(Id) from Entities) in Entity Framework

I have a collection of entities named...Entities... it includes a field...Name... with a field....Version... . I want to send back the item with the most recent version for the chosen...Name... ....For SQL, I'd go...Select * from table where name = 'name' and version = (select max(version) from table ...
entity-framework
asked by Ian

MVC view order of Entity Framework elements and child things

How do I sort a DbSet query and include child items that also need to be sorted?...Example:...I have a schedule for placing orders....public class Order { public virtual int Id { get; set; } public virtual int? SchedulingOrder { get; set; } public virtual int? WeekId { get; set; } public virtual Week Week { get; set; } } public class Week {...
asp.net asp.net-mvc entity-framework linq sql-order-by
asked by Benjamin

How to add items to Combobox from Entity Framework?

I've got this code:... private void FillCombobox() { using (InventoryEntities c = new InventoryEntities(Properties.Settings.Default.Connection)) { List<Customer> usepurposes = c.Customers.ToList(); DataTable dt = new DataTable(); dt.Columns.Add("id"); dt.Columns.Add("name"); ...
c# combobox entity-framework
asked by Saleh

LINQ Lambda: Getting Last item (where == ) of sub collection

I have (and have used in CodeFirst) the following:...public class MyForm { public int MyFormId { get; set; } //Many Form Properties public virtual ICollection<AuditItem> AuditItems { get; set; } } public class AuditItem { public int AuditItemId { get; set; } public int MyFormId { get; set; } ...
c# entity-framework linq linq-to-entities
asked by David C

Find all items whose collection property contains items in another list

I have an object collection called Foo that has an ICollection property with a list of People object entries in it....public class Foo { public int Id { get; set; } public string Name { get; set; } public ICollection<Person> People { get; set; } } ...I also have a list of people....ICollection<Person> OtherPeople ...I had to track down every ...
entity-framework linq
asked by Andrew

Linq - How to select items from a list that contains only items of another list?

I'm taking these two classes:...public class Item { public int Id{get;set;} public List<Test> TestList{get;set;} } public class Test { public int Id{get;set;} public Item Item{get;set;} public byte State{get;set;} } ...Data for Item Class:...Id 1 2 3 ...and test class information...Item State 1 1 1 2 1 3 ...
c# entity-framework linq
asked by Gypsy

Linq return parent objects that have child items matching ALL items in separate list

ZZZ_tmp
c# entity-framework-6 linq
asked by Lianne Crocker

How to select item with specific item in iCollection property?

The following class is mine:... public class Foo { [Key] public int ID { get; set; } public virtual ICollection<Cat> Cats { get; set; } } ...I'm attempting to choose all Foo objects that include a certain Cat object. I'm currently performing these things:...Cat c = new Cat(10); var lPs = Bd.Foos.Include("Cats").Wh...
c# entity-framework entity-framework-6
asked by Ayorus

Getting error in Entity Framework when trying to add an item

When I attempt to add a piece of information to the database context, I get the following error. In a Web API project, I'm working with Entity Framework. Here is an example of the code....Exception...System.Data.Entity.Infrastructure.DbUpdateException... HResult=0x80131501 Message=An error occurred while updating the entries. See the inner ex...
asp.net-web-api asp.net-web-api2 c# entity-framework entity-framework-6
asked by BipinR

Why the text of combobox show the items with property name?

I'm working on a WPF project. Items from my database are automatically inserted into a ComboBox that I have. I'm attempting to get the ID of the item that is now chosen in the combo box. The items are displaying, but the property name is also shown in the combo box's text. I used the code to populate the combo box....using (var Context = new Profet...
c# entity-framework-6 linq wpf
asked by Mahmoud Samy

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...

Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow