Combo box value and text in vs 2008 for windows application

Question

hi, developing a windows application using visual basic 2008. in a form, i want to load customer ID and customer Name in a combo boX. customer ID will be invisible and customer name will be visible in column.user will select the name but customer id will be stored in the database.

Thanx

vijay · Answer

hi for loading data in combobox u may try this link for details.... http://vbdotnetaddict.blogspot.com/2011/05/add-and-remove-items-from-combobox-in.html

Bryian Tan · Answer

Hello, Yes, we can have more than 2 columns/entity/column store in the ComboBox. Here is a brief example. using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; namespace WindowsFormsSample { public partial class Form1 : Form { public Form1() { InitializeComponent(); PopulateComboBox(); } public void PopulateComboBox() { List books = new List { new Book(1, "Title 1", "Author 1", "Category 1", "9992158107"), new Book(2, "Title 2", "Author 2", "Category 2", "xyz5345508"), new Book(3, "Title 3", "Author 3", "Category 3", "8777158107"), new Book(4, "Title 4", "Author 4", "Category 4", "abc5555107"), new Book(5, "Title 5", "Author 5", "Category 5", "9323443507"), new Book(6, "Title 6", "Author 6", "Category 6", "9534553455"), new Book(7, "Title 7", "Author 7", "Category 7", "9434543107"), new Book(8, "Title 8", "Author 8", "Category 8", "998758107")}; comboBox1.DataSource = books; comboBox1.DisplayMember = "Title"; comboBox1.ValueMember = "ID"; } private void comboBox1_SelectedIndexChanged(object sender, EventArgs e) { Book b = (Book)comboBox1.SelectedItem; MessageBox.Show("Author " + b.Author + "
 Title: " + b.Title + "
 Category: " + b.Category + "
 ISBN: " + b.ISBN); } } public class Book { public int ID { get; set; } public string Title { get; set; } public string Author { get; set; } public string Category { get; set; } public string ISBN { get; set; } public Book(int id, string title, string author, string category, string isbn) { ID = id; Title = title; Author = author; Category = category; ISBN = isbn; } } }

Ankit Nandekar · Answer

i m not getting what u want to say ,u want to bind 3 columns in Combobox?

mazez sha · Answer

thank you so much. one more thing, is it possible to load more than two field. for example, CustomerID (col 1, ValueMember), CustomerName (Col 2,DisplayMember), CurrentBalance (col 3, DisplayMember)

Ankit Nandekar · Answer

try this using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Data.SqlClient; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; namespace WindowsFormsApplication8 { public partial class Form3 : Form { public Form3() { InitializeComponent(); } private void Form3_Load(object sender, EventArgs e) { SqlConnection con = new SqlConnection("Data Source=C3;Initial Catalog=Student;Persist Security Info=True;User ID=sa;Password=p@ssw0rd"); SqlDataAdapter da = new SqlDataAdapter("select EmpName, Empno from EmployeeInfo", con); DataSet ds = new DataSet(); da.Fill(ds); comboBox1.DataSource = ds.Tables[0].DefaultView; comboBox1.DisplayMember = "EmpName";//Employee name which u want to show in Combobox comboBox1.ValueMember = "Empno"; } private void button1_Click(object sender, EventArgs e) { MessageBox.Show(comboBox1.SelectedValue.ToString()); //u can get selected employee's id using this code } } } in above example it is reteriving Employee name and Employee id from table and with the use of comboBox1.SelectedValue u can get Employee Id for perticular Employee.

Vulpes · Answer

The ComboBox has two properties DisplayMember and ValueMember which are used in data-binding. The first of these contains the property which is actually displayed and the second contains the property which represents the actual value of what's dispayed. So you might be able to set DisplayMember to customer name and ValueMember to customer ID. See the example on MSDN ( http://msdn.microsoft.com/en-us/library/system.windows.forms.listcontrol.valuemember.aspx ).

Combo box value and text in vs 2008 for windows application

Answers (6)