ListBox Binding with multiple Column

Question

0.00/5 (No votes)

See more:

Hi.....I have Window form with ListBox.I want to Bind ListBox with multiple Column.Please Help Me.

query="Select Fname,Lname From Contact";

I want to see Fname,Lname In ListBox ,help me How can I do this..?

Posted 28-May-10 22:13pm

AhirRamesh

Add a Solution

4 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

radix3 · Answer 1 · 2010-05-29T01:02:00

Hers your answer with the baked code,
Explanation: Here on the page load i have added the data from the database into the listbox.

 private void Update_Existing_Load(object sender, EventArgs e)
        {
//i have cleared the listbox because if u wish to plan on calling the load event on any other event then the data in the list box appears twice hence u have to clear it first
            listBox1.Items.Clear();
            using (SqlConnection con = new SqlConnection())
            {
                con.ConnectionString = "Data Source=.;Initial Catalog=phonebook;Integrated Security=True";
                con.Open();
                string query = "select FirstName+' '+LastName from Details";
                SqlCommand cmd = new SqlCommand(query, con);
                SqlDataReader dr = cmd.ExecuteReader();
                while (dr.Read() == true)
                {
//adding data to listbox 
                    listBox1.Items.Add(dr[0].ToString());
                }
//close the connection
                con.Close();
//releasing the occupied resource
                con.Dispose();
            }

        }

Do rate my answer once you find it useful
Thanks & Regards
Radix :rose:

**PSK_** · Answer 2 · 2010-05-28T22:48:00

Solution 1

You can write your query like following

query = "Select Fname + ', ' + Lname as ContactName From Contact";

Load this to a dataset and bind like following.

yourListBox.DataSource = dataSet1.Tables[0];
yourListBox.DisplayMember = "ContactName";

Posted 28-May-10 22:48pm

PSK_

Comments

Member 11788122 12-Oct-15 1:36am

but there is no method like DisplayMember for listbox.

Abhinav S · Answer 3 · 2010-05-28T22:50:00

Solution 2

Please see the msdn sample here.

Posted 28-May-10 22:50pm

Abhinav S

Shubh Agrahari · Answer 4 · 2013-05-17T22:50:00

hello
may this will help you

C#

try
          {
              con = new MySqlConnection();
              con.ConnectionString = ConfigurationSettings.AppSettings["constr"];
              con.Open();
          }
          catch (Exception ex)
          {
              MessageBox.Show(ex.Message);
          }
          string str = "select CONCAT(SNAME, ' ' ,SCODE) AS mixcode from stationcode;";
          da = new MySqlDataAdapter(str, con);
          ds = new DataSet();
          //da.TableMappings.Add("table", "stationcode");
          da.Fill(ds, "stationcode");
          this.comboBox1.DataSource = this.ds;
          this.comboBox1.DisplayMember = "stationcode.mixcode";
          this.comboBox1.ValueMember = "stationcode.mixcode";

Happy to help

ListBox Binding with multiple Column

4 solutions

Solution 3

Solution 1

Solution 2

Solution 4

Add your solution here

Preview 0