Listbox.multicolumn property whit SQL query

Question

0.00/5 (No votes)

See more:

Can anyone help me with the code below. I want to make a MultiColumn listbox.
I have adapt my standard code but this give me one Collom with data in my listbox with data (IDMateriaal).

How do I customize the code below to get the data in different collems.

ListBoxMateriaal
|| IDMateriaal | Omschrijving | Omschrijving2 ||

private void MateriaalBOX()
        {
            using (connection = new SqlConnection(connectionstring))

            using (SqlDataAdapter adapter = new SqlDataAdapter("select [IDMateriaal],Omschrijving, Omschrijving2 from Materiaal ORDER BY Omschrijving ASC", connection))
                try
                {
                    DataTable materiaallijst = new DataTable();
                    adapter.Fill(materiaallijst);
                    //
                    ListBoxMateriaal.HorizontalScrollbar = true;
                    ListBoxMateriaal.FormattingEnabled = true;
                    ListBoxMateriaal.MultiColumn = true;
                    ListBoxMateriaal.ScrollAlwaysVisible = true;
                   ListBoxMateriaal.TabIndex = 0;
                    //
                    //ListBoxMateriaal.DisplayMember = "Omschrijving";
                    ListBoxMateriaal.ValueMember = "IDMateriaal";
                    ListBoxMateriaal.Items.AddRange(new object[]
                    {
                      "IDMateriaal, IDMateriaal",
                      "Omschrijving, Omschrijving",
                      "Omschrijving2, Omschrijving2",

                        });

                    ListBoxMateriaal.DataSource = materiaallijst;
                }

What I have tried:

https://msdn.microsoft.com/en-us/library/system.windows.forms.listbox.multicolumn(v=vs.110).aspx

Posted 12-Apr-16 0:31am

MaikelO1

Updated 12-Apr-16 1:24am

Add a Solution

Comments

Suvabrata Roy 12-Apr-16 7:13am

Did you face any error?

MaikelO1 12-Apr-16 7:20am

No error, but there is only one collum

Suvabrata Roy 12-Apr-16 7:22am

How many rows you have as result?

1 solution

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)

CHill60 · Accepted Answer · 2016-04-12T01:24:00

For a ListBox Multicolumn = true just pushes the (single column of) data into another column instead of using a scrollbar.

Instead of using a ListBox use a ListView e.g.

C#

private void MateriaalBOX()
        {
            ListBoxMateriaal.TabIndex = 0;
            ListBoxMateriaal.Items.Clear();
            ListBoxMateriaal.View = View.Details;

            ListBoxMateriaal.Columns.Add("IDMateriaal");
            ListBoxMateriaal.Columns.Add("Omschrijving");
            ListBoxMateriaal.Columns.Add("Omschrijving2");

            using (var connection = new SqlConnection(connectionstring))
            {
                var query = "select [IDMateriaal],Omschrijving, Omschrijving2 from Materiaal ORDER BY Omschrijving ASC";
                using (var adapter = new SqlDataAdapter(query, connection))
                {
                    try
                    {
                        DataTable materiaallijst = new DataTable();
                        adapter.Fill(materiaallijst);

                        for (int i = 0; i < materiaallijst.Rows.Count; i++)
                        {
                            DataRow dr = materiaallijst.Rows[i];
                            ListViewItem listitem = new ListViewItem(dr["IDMateriaal"].ToString());
                            listitem.SubItems.Add(dr["Omschrijving"].ToString());
                            listitem.SubItems.Add(dr["Omschrijving2"].ToString());
                            ListBoxMateriaal.Items.Add(listitem);
                        } 
..etc

Alternatively you could use a DataGridView to display the data.
The only other alternative I can think of would be to write a custom control.

[EDIT - response to OP's comment is easier here than in comments]

Quote:
want to use the IDMateriaal field as SelectedValue, because in my final solution, I don't need the ID field be visualized.. Is this possible?

Yes. I suggest the following changes to the code I offered above:

C#

//ListBoxMateriaal.Columns.Add("IDMateriaal");   //Don't need a column for the ID
ListBoxMateriaal.Columns.Add("Omschrijving");
ListBoxMateriaal.Columns.Add("Omschrijving2");
ListBoxMateriaal.MultiSelect = false;           //Only select one row
ListBoxMateriaal.FullRowSelect = true;          //Select the whole row, not just column 1

using (var connection = new SqlConnection(connectionstring))
{
    var query = "select [IDMateriaal],Omschrijving, Omschrijving2 from Materiaal ORDER BY Omschrijving ASC";
    using (var adapter = new SqlDataAdapter(query, connection))
    {
        try
        {
            DataTable materiaallijst = new DataTable();
            adapter.Fill(materiaallijst);

            for (int i = 0; i < materiaallijst.Rows.Count; i++)
            {
                DataRow dr = materiaallijst.Rows[i];
                ListViewItem listitem = new ListViewItem(dr["Omschrijving"].ToString());    //Note item in now based on this column
                listitem.SubItems.Add(dr["Omschrijving2"].ToString());

                listitem.Tag = dr["IDMateriaal"];                   // Store the ID for later on
                ListBoxMateriaal.Items.Add(listitem);
            }

And you can get to the id of the selected row like this

C#

private void ListBoxMateriaal_SelectedIndexChanged(object sender, EventArgs e)
{
    lblSelected.Text = (ListBoxMateriaal.SelectedItems.Count > 0) ? ListBoxMateriaal.SelectedItems[0].Tag.ToString() : "Nothing Selected";
}

[EDIT - changes after OP comments]

C#

private void MateriaalBOX()
{
    ListBoxMateriaal.TabIndex = 0;
    ListBoxMateriaal.Items.Clear();
    ListBoxMateriaal.View = View.Details;

    ListBoxMateriaal.Columns.Add("Materiaalgroep");
    ListBoxMateriaal.Columns.Add("Omschrijving");
    ListBoxMateriaal.Columns.Add("Omschrijving2");
    ListBoxMateriaal.Columns.Add("Datum_wijziging");

    ListBoxMateriaal.MultiSelect = false;
    ListBoxMateriaal.FullRowSelect = true;

    using (var connection = new SqlConnection(connectionstring))
    {
        var query = "SELECT [IDMateriaal], Omschrijving, Omschrijving2, Datum_wijziging FROM Materiaal WHERE Omschrijving like (@Omschrijving) order by Omschrijving ASC";

        using (var adapter = new SqlDataAdapter(query, connection))
        {
            SqlParameter parm = adapter.SelectCommand.Parameters.AddWithValue("@Omschrijving", "%" + TX_Materiaalstuk_Zoeken.Text + "%");
            try
            {
                DataTable materiaallijst = new DataTable();
                adapter.Fill(materiaallijst);

                for (int i = 0; i < materiaallijst.Rows.Count; i++)
                {
                    DataRow dr = materiaallijst.Rows[i];
                    ListViewItem listitem = new ListViewItem(dr["IDMateriaal"].ToString());
                    listitem.SubItems.Add(dr["Omschrijving"].ToString());
                    listitem.SubItems.Add(dr["Omschrijving2"].ToString());
                    listitem.SubItems.Add(dr["Datum_wijziging"].ToString());


                    listitem.Tag = dr["IDMateriaal"]; // Store the ID for later on
                    ListBoxMateriaal.Items.Add(listitem);

                    ListBoxMateriaal.AutoResizeColumns(ColumnHeaderAutoResizeStyle.ColumnContent);
                    ListBoxMateriaal.AutoResizeColumns(ColumnHeaderAutoResizeStyle.HeaderSize);
                }
            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.StackTrace);
                Console.WriteLine(ex.Message);
            }

        }
    }
    ListBoxMateriaal.Columns[3].Width = 0;
}
        private void ListBoxMateriaal_SelectedIndexChanged(object sender, EventArgs e)
        {
            lblSelected.Text = (ListBoxMateriaal.SelectedItems.Count > 0) ? ListBoxMateriaal.SelectedItems[0].Tag.ToString() : "";
            LB_WijzigingingsDatum.Text = (ListBoxMateriaal.SelectedItems.Count > 0) ? ListBoxMateriaal.SelectedItems[0].SubItems[3].Text : "";
 
        }