Problem using MultiCombobox

Question

0.00/5 (No votes)

See more:

Hello friends,

I have using a Multicombobox but i have one problem.

first I load two columns into my multicombobox from a data set

but when i go to another module of my aplication and when
i return to the multicombobox and clicked.

it display the data with erros.

I give you a picture that show you the error:

The code i have using is the following:

string sqlqwery = "select vehiculos.cod as codigo,nombre as Nombre from vehiculos,socio where vehiculos.cod_so=socio.cod order by vehiculos.cod asc;";
conexion con = new conexion();
DataSet myDs = new DataSet();
myDs = con.consulta(sqlqwery);
multiColumnComboBox1.DataSource = myDs.Tables[0];
multiColumnComboBox1.DisplayMember = "codigo";
multiColumnComboBox1.ValueMember = "codigo";
multiColumnComboBox1.Refresh();

Please give me any advice for this case.

Note:

the ListBox and ComboBox didn't have multi-column support, For that reasona using the Muliticombobox
you can see about that here: http://www.codeproject.com/KB/combobox/multicolumnlistbox.aspx (error)
the correct link is it: A data-bound multi-column combobox[^]
But I using this new control, but I found the mentioned problem behind.
Grettings I waiting for your helps

Thanks,

Posted 26-Jan-11 7:32am

leocode7

Updated 26-Jan-11 9:09am

v3

Add a Solution

Comments

Nish Nishant 26-Jan-11 14:01pm

There is no control in Winforms called MultiCombobox. So you must be using a 3rd party control. Can you give more details on what you are using? That may help folks in giving you a more suitable answer.

leocode7 26-Jan-11 14:35pm

Hello,
the ListBox and ComboBox didn't have multi-column support, For that reason I'm using the Muliticombobox
you can see about that here: http://www.codeproject.com/KB/combobox/multicolumnlistbox.aspx
But I using this new control, but I found the mentioned problem behind.
Grettings I waiting for your helps

Nish Nishant 26-Jan-11 14:38pm

The control you are using was written in June 2002 and used .NET 1.0. It may need to be modified/updated to work with newer versions of the framework. Are you open to using other similar controls? Or do you want to use this specific class?

leocode7 26-Jan-11 14:50pm

Of course!! I open to use new controls in .NET 2.0 and others one...
Please give me the link for that access it! also i need the "MultiListbox" too
because i am using both controls (MultiCombobox and MultiListBox) and they are working bad in my aplication.
Thanks in advance.

Nish Nishant 26-Jan-11 14:52pm

Ok, try this one then :

http://www.codeproject.com/KB/combobox/DotNetMultiColumnComboBox.aspx

I wrote it and it's a multi column combobox. It should work with the latest Winforms version (even though it originally targeted .NET 2.0).

I don't know of a listbox equivalent to my class.

leocode7 26-Jan-11 15:06pm

my friend..
I just relaized that i dowload the control of yours.
If you create the control please helpme to relsove the problem.
Note: The first link that i give you in .NET 1.0 is of the MutliListobox NO of the MultiCombobox.
The MultiCombobox that i using if yours.
Help me!

Thanks my friend.

Nish Nishant 26-Jan-11 15:12pm

Interesting. If you look at the forum comments in my article, there is a thread by alias47 saying the drop down only displays 1 character. See kiennt's reply to that where has suggested a modification to the code that may fix it. Try that out.

I have never verified that myself, so I can't be sure it will work for you, but it is worth a shot.

leocode7 26-Jan-11 15:27pm

Thanks it work fine now!!!

Please would you give me any help for the MultiLisbox too??.
There are any link that i can see about that??

I hope, God give you a present :)

Sincerely,

Nish Nishant 26-Jan-11 18:07pm

Sorry I don't know much about that listbox class you are using, and I see you've started a separate thread for that. So hopefully someone will answer you there.

leocode7 7-Feb-11 1:18am

the solution for the multilistbox that im using is:

1) Call begin update method
2) fill the multilistbox with datasource
3) call end update method

like this:

<pre lang="sql">this.multiColumnListBox1.BeginUpdate();
this.multiColumnListBox1.DataSource = myDs.Tables["dt"];
this.multiColumnListBox1.EndUpdate();</pre>

3 solutions

Solution 2

These link the one of best for MultiColumn listbox
http://msdn.microsoft.com/en-us/library/system.windows.forms.listbox.multicolumn.aspx[^]

Posted 26-Jan-11 16:13pm

Theingi Win

Comments

leocode7 27-Jan-11 12:16pm

Hello friend but the problem of your link is that any element in two columns
is a different, but I want to have one element with two columns
For example:

CODE0052 |ALEX WOOL
CODE0015 |MARY ANDERSON

This two elements represents one registry per line (This is I want).
But in your link there are four elements (registries) in MultiListbox

Also I want to assign elements using DatSets.

Please give me one solution,

Thanks in advance,

leocode7 7-Feb-11 1:18am

the solution is

1) Call begin update method
2) fill the multilistbox with datasource
3) call end update method

like this:

<pre lang="sql">this.multiColumnListBox1.BeginUpdate();
this.multiColumnListBox1.DataSource = myDs.Tables["dt"];
this.multiColumnListBox1.EndUpdate();</pre>

Solution 3

XML

the solution is
1) Call begin update method
2) fill the multilistbox with datasource
3) call end update method
like this:
<pre lang="sql">this.multiColumnListBox1.BeginUpdate();
                this.multiColumnListBox1.DataSource = myDs.Tables[&quot;dt&quot;];
                this.multiColumnListBox1.EndUpdate();</pre>

Posted 6-Feb-11 19:18pm

leocode7

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)

Nish Nishant · Accepted Answer · 2011-01-26T12:06:00

I'll add this as an answer so anyone else visiting this thread knows what happened without going through all the comments.

The OP was using my multi-column combobox class as well as someone else's multi-column listbox class. He's started a separate thread for the listbox problem. But the fix to my class was to do this:

Replace:

C#

protected override void OnDataSourceChanged(EventArgs e)
{
  base.OnDataSourceChanged(e); 
  InitializeColumns(); 
}

with:

C#

protected override void OnDataSourceChanged(EventArgs e)
{
  InitializeColumns();
  base.OnDataSourceChanged(e); 
}

I am not sure why that's needed now. I wrote the original code 4 years ago, and at the moment I don't have time to dig into why this might make a difference. But anyway that fixed the OP's problem with the combobox.