Get ID of item selected in ComboBox

c# entity-framework linq winforms

Question

I have a ComboBox that gets filled with items from my database. I'm trying to get the ID of the item that is selected in the ComboBox, but nothing I've tried seems to be working. 

int id = cbbilar.SelectedIndex + 1;

This is how I have it right now, it's very inefficient and stops working if the first items in the database are removed

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 the code for my Combobox. How do I make it fetch the ID of the SelectedItem?

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

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Accepted Answer

You need to use SelectedValue and int.TryParse method. Like this:

int id;
bool result = int.TryParse(cbbilar.SelectedValue.ToString(), out id);
2
10/28/2016 11:53:46 AM

Popular Answer

Here is what I got done:

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

and then you can get the Id value as shown below

  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 an entity set called ...Entities... which has a field ...Name... and a field ...Version.... I wish to return the object having the highest version for the selected ...Name.......SQL wise 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 can I sort a query from a DbSet and include child items which should also be sorted....Example:...I have a model for scheduling 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 clas...
asp.net asp.net-mvc entity-framework linq sql-order-by
asked by Benjamin

How to add items to Combobox from Entity Framework?

I have 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 the following (which I've used in CodeFirst):...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 collection of object Foo with an ICollection property containing a list of People objects....public class Foo { public int Id { get; set; } public string Name { get; set; } public ICollection<Person> People { get; set; } } ...I have another list of Person....ICollection<Person> OtherPeople ...I need to find all objects Foo where Peo...
entity-framework linq
asked by Andrew

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

I have this 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;} } ...Item Class Data:...Id 1 2 3 ...And Test Class Data:...Item State 1 1 1 2 1 3 2 1 2 ...
c# entity-framework linq
asked by Gypsy

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

I have an object which has a variable length list of items (incomingList in code example) and a list of people which each have a list of items. I want to return only those people that have all the items in the incomingList....So looking at the example, I only want person 1 and 3 returned....The people are in a database and I want to retrieve as li...
c# entity-framework-6 linq
asked by Lianne Crocker

How to select item with specific item in iCollection property?

I have the following class: ... public class Foo { [Key] public int ID { get; set; } public virtual ICollection<Cat> Cats { get; set; } } ...I am trying to select all the Foo objects which contains a specific Cat object. Currently I am doing this: ...Cat c = new Cat(10); var lPs = Bd.Foos.Include("Cats").Where(p ...
c# entity-framework entity-framework-6
asked by Ayorus

Getting error in Entity Framework when trying to add an item

I'm getting the below error when trying to add an item to the database context. I'm using Entity Framework in a Web API project. The sample code is shown below....Exception...System.Data.Entity.Infrastructure.DbUpdateException... HResult=0x80131501 Message=An error occurred while updating the entries. See the inner exception for details. So...
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 project using WPF. I have a ComboBox that gets filled with items from my database. I'm trying to get the ID of the item that is selected in the ComboBox, It's working the items showing but the text of Combobox showing property name too. That's my code I used to fill ComboBox....using (var Context = new ProfetusModel()) { var GetQ...
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