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

Ninds

15y2.8kAzure

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

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vulpes15y ago
Accepted 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 Hobbs15y ago
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 Nandekar15y ago
Ninds problem solved or not?
Ankit Nandekar15y ago
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 ";

        }


    }
}