how to display 2 values from database to the combobox control e.g. 1-abc

Question

hi  i m new to c#; In my desktop application i want to show combobox as follows: 1-abc 2-def 3-ghi etc. my database table structure is : id description 1 abc 2 def 3 ghi In short i want something like combo1.displaymember=id-description; and combo1.valuemember=id; please suggest me possible workaround for this

Vulpes · Answer

I'd be inclined to create a custom class with an Id_Description property create a list of objects of that class from your DataTable and then bind the ComboBox to the list. Something like this: class MyTable { public int Id { get; private set; } public string Description { get; private set;} public string Id_Description { get { return Id +  -  + Description; } } public MyTable(int id string description) { Id = id; Description = description; } } // in practice would need to check for null values var list = new List (); foreach(DataRow dr in dt.Rows) { list.Add(new MyTable((int)dr[id] (string)dr[description])); } comboBox1.DataSource = list; comboBox1.DisplayMember = Id_Description; comboBox1.ValueMember = Id;

Sam Hobbs · Answer

It depends on how you are getting the data. It is possible to bind a control (ComboBox) to a data source. If you are doing that or you can do that then I am nearly certain that SQL supports calculated fields. So you can combine (concatenate) the two fields into a calculated field and use that field for the control (ComboBox).

Ankit Nandekar · Answer

Ninds problem solved or not?

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 id  id-description from description  con); DataSet ds = new DataSet(); da.Fill(ds); comboBox1.DataSource = ds.Tables[0].DefaultView; comboBox1.DisplayMember =  id-description;//id-description name which u want to show in Combobox comboBox1.ValueMember =  id ; } } }

how to display 2 values from database to the combobox control e.g. "1-abc"