Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: C# WebForms
Hi want to display station code and staion name both in the listbox or combobox
  private void getdatainsourcestation()
        {
            try
            {
                con = new MySqlConnection();
                con.ConnectionString = ConfigurationSettings.AppSettings["constr"];
                con.Open();
            }
            catch (Exception ex)
            {
                MessageBox.Show("Error"+ex.Message );
            }
            string str = "select scode,sname from stationcode;";
            da = new MySqlDataAdapter(str, con);
            ds = new DataSet();
            da.TableMappings.Add("table", "stationcode");
            da.Fill(ds, "stationcode");
            this.comboBox2.DataSource = this.ds;
            this.comboBox2.DisplayMember = "stationcode.sname ;
            this.comboBox2.ValueMember = "stationcode.sname";
 
 
        }
 
This is displaying station name but it also want station code please help
 
Thanks:
Posted 6-Aug-12 23:09pm
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

Refer this link

http://blog.dreamfactory.se/2011/01/20/multiple-columns-in-asp-net-listbox/[^]
 
or try this
 
private void button1_Click(object sender, System.EventArgs e)
{
// Create an instance of the ListBox.
ListBox listBox1 = new ListBox();
// Set the size and location of the ListBox.
listBox1.Size = new System.Drawing.Size(200, 100);
listBox1.Location = new System.Drawing.Point(10,10);
// Add the ListBox to the form.
this.Controls.Add(listBox1);
// Set the ListBox to display items in multiple columns.
listBox1.MultiColumn = true;
// Set the selection mode to multiple and extended.
listBox1.SelectionMode = SelectionMode.MultiExtended;
 
// Shutdown the painting of the ListBox as items are added.
listBox1.BeginUpdate();
// Loop through and add 50 items to the ListBox.
for (int x = 1; x <= 50; x++)
{
listBox1.Items.Add("Item " + x.ToString());
}
// Allow the ListBox to repaint and display the new items.
listBox1.EndUpdate();
 
// Select three items from the ListBox.
listBox1.SetSelected(1, true);
listBox1.SetSelected(3, true);
listBox1.SetSelected(5, true);
 
// Display the second selected item in the ListBox to the console.
System.Diagnostics.Debug.WriteLine(listBox1.SelectedItems[1].ToString());
// Display the index of the first selected item in the ListBox.
System.Diagnostics.Debug.WriteLine(listBox1.SelectedIndices[0].ToString());
}
  Permalink  
v2
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 2

You may even get the data from the database as single column like below:
string str = "select scode + ' ' + sname as Details from stationcode;";
  Permalink  
Comments
GuruOnu at 7-Aug-12 8:22am
   
i want multiple columns

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

  Print Answers RSS
0 ridoy 440
1 Maciej Los 414
2 DamithSL 150
3 Suvendu Shekhar Giri 150
4 Richard MacCutchan 144
0 OriginalGriff 8,033
1 DamithSL 6,179
2 Sergey Alexandrovich Kryukov 5,538
3 Maciej Los 5,508
4 Kornfeld Eliyahu Peter 4,539


Advertise | Privacy | Mobile
Web04 | 2.8.141223.1 | Last Updated 7 Aug 2012
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100