Fill a ComboBox

[Pepehammer]

Hi everybody!

I got a combobox to fill.
I want to display some information (Text), but when I select a item, I want
to return a number.

The info I want to fill in is something like this:

TEXT VALUE
Category1 10
Category2 15
Category3 35

How can I perform this task?

Thanks!

[Miha Markic [MVP C#]]

Hi,

Yes, one way would be to create a DataTable containing two columns for the
datasource and set DisplayMember and ValueMember accordingly:
DataTable table = new DataTable();

table.Columns.Add("Id", typeof(int));

table.Columns.Add("Description", typeof(string));

table.Rows.Add(new object[]{1, "One"});

table.Rows.Add(new object[]{2, "Two"});

comboBox1.ValueMember = "Id";

comboBox1.DisplayMember = "Description";

comboBox1.DataSource = table;
--
Miha Markic [MVP C#] - RightHand .NET consulting & development
miha at rthand com
www.rthand.com

"Pepehammer" <pe********@hotmail.com> wrote in message
news:OM**************@TK2MSFTNGP09.phx.gbl...

Hi everybody!

I got a combobox to fill.
I want to display some information (Text), but when I select a item, I want to return a number.

The info I want to fill in is something like this:

TEXT VALUE
Category1 10
Category2 15
Category3 35

How can I perform this task?

Thanks!

[Scott]

A simple way is to create a class to hold your data. The combobox uses the
System.Windows.Forms.ComboBox.ObjectCollection class to hold the items for
the combobox and uses the ToString() method to get the text to display.
Simply create a class that has a String and an Integer and add a ToString()
method to return the String value.

See this previous newsgroup post...

http://groups.google.com/groups?q=vb...phx.gbl&rnum=1
"Pepehammer" <pe********@hotmail.com> wrote in message
news:OM**************@TK2MSFTNGP09.phx.gbl...

Hi everybody!

I got a combobox to fill.
I want to display some information (Text), but when I select a item, I want to return a number.

The info I want to fill in is something like this:

TEXT VALUE
Category1 10
Category2 15
Category3 35

How can I perform this task?

Thanks!

[Pepehammer]

How i fill the combobox with info from a database (SQL)?

Thanks
"Miha Markic [MVP C#]" <miha at rthand com> wrote in message
news:e1**************@TK2MSFTNGP11.phx.gbl...

Hi,

Yes, one way would be to create a DataTable containing two columns for the
datasource and set DisplayMember and ValueMember accordingly:
DataTable table = new DataTable();

table.Columns.Add("Id", typeof(int));

table.Columns.Add("Description", typeof(string));

table.Rows.Add(new object[]{1, "One"});

table.Rows.Add(new object[]{2, "Two"});

comboBox1.ValueMember = "Id";

comboBox1.DisplayMember = "Description";

comboBox1.DataSource = table;
--
Miha Markic [MVP C#] - RightHand .NET consulting & development
miha at rthand com
www.rthand.com

"Pepehammer" <pe********@hotmail.com> wrote in message
news:OM**************@TK2MSFTNGP09.phx.gbl...

Hi everybody!

I got a combobox to fill.
I want to display some information (Text), but when I select a item, I

want

to return a number.

The info I want to fill in is something like this:

TEXT VALUE
Category1 10
Category2 15
Category3 35

How can I perform this task?

Thanks!

[Moogy]

This should give you what you need:

http://www.csharphelp.com/archives/archive151.html

MOOGY!

"Pepehammer" <pe********@hotmail.com> wrote in message
news:%2***************@TK2MSFTNGP11.phx.gbl...

How i fill the combobox with info from a database (SQL)?

Thanks
"Miha Markic [MVP C#]" <miha at rthand com> wrote in message
news:e1**************@TK2MSFTNGP11.phx.gbl...

Hi,

Yes, one way would be to create a DataTable containing two columns for the datasource and set DisplayMember and ValueMember accordingly:
DataTable table = new DataTable();

table.Columns.Add("Id", typeof(int));

table.Columns.Add("Description", typeof(string));

table.Rows.Add(new object[]{1, "One"});

table.Rows.Add(new object[]{2, "Two"});

comboBox1.ValueMember = "Id";

comboBox1.DisplayMember = "Description";

comboBox1.DataSource = table;
--
Miha Markic [MVP C#] - RightHand .NET consulting & development
miha at rthand com
www.rthand.com

"Pepehammer" <pe********@hotmail.com> wrote in message
news:OM**************@TK2MSFTNGP09.phx.gbl...

Hi everybody!

I got a combobox to fill.
I want to display some information (Text), but when I select a item, I

want

to return a number.

The info I want to fill in is something like this:

TEXT VALUE
Category1 10
Category2 15
Category3 35

How can I perform this task?

Thanks!

[Miha Markic [MVP C#]]

Hi,

You don't need database - you just use a class DataTable which is not linked
to database.

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
miha at rthand com
www.rthand.com

"Pepehammer" <pe********@hotmail.com> wrote in message
news:%2***************@TK2MSFTNGP11.phx.gbl...

How i fill the combobox with info from a database (SQL)?

Thanks
"Miha Markic [MVP C#]" <miha at rthand com> wrote in message
news:e1**************@TK2MSFTNGP11.phx.gbl...

Hi,

Yes, one way would be to create a DataTable containing two columns for the datasource and set DisplayMember and ValueMember accordingly:
DataTable table = new DataTable();

table.Columns.Add("Id", typeof(int));

table.Columns.Add("Description", typeof(string));

table.Rows.Add(new object[]{1, "One"});

table.Rows.Add(new object[]{2, "Two"});

comboBox1.ValueMember = "Id";

comboBox1.DisplayMember = "Description";

comboBox1.DataSource = table;
--
Miha Markic [MVP C#] - RightHand .NET consulting & development
miha at rthand com
www.rthand.com

"Pepehammer" <pe********@hotmail.com> wrote in message
news:OM**************@TK2MSFTNGP09.phx.gbl...

Hi everybody!

I got a combobox to fill.
I want to display some information (Text), but when I select a item, I

want

to return a number.

The info I want to fill in is something like this:

TEXT VALUE
Category1 10
Category2 15
Category3 35

How can I perform this task?

Thanks!

[Moogy]

Hey Miha, did you see my post about how to receive event changes from the
SQL server?

Nobody has really responded. Would be nice to get some help on that...

MOOGY!

[Miha Markic [MVP C#]]

Hi Moogy,

William gave you a good answer.
If you want learn more on notification services, read online docs:
http://msdn.microsoft.com/library/?u...asp?frame=true

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
miha at rthand com
www.rthand.com

"Moogy" <no****@nospam.com> wrote in message
news:10*************@corp.supernews.com...

Hey Miha, did you see my post about how to receive event changes from the
SQL server?

Nobody has really responded. Would be nice to get some help on that...

MOOGY!

[Moogy]

This seems a rather complex solution for enterprise-scale projects; my
client is a simple connection client for a small custom database, yet we may
have 3-4 people working on it at the same time.

Don't get me wrong, if this is the only way, I'll definitely have to pursue
it; I was just hoping that I could use triggers and an existing SQL
connection to communicate, or something along those lines.

I'm wondering if writing a RPC service may be the easier solution. I was
just hoping to use something internal to SQL...

There's no way to receive simple trigger messages through events that SQL
Server can raise through the connection?

MOOGY!

"Miha Markic [MVP C#]" <miha at rthand com> wrote in message
news:O4**************@TK2MSFTNGP09.phx.gbl...

Hi Moogy,

William gave you a good answer.
If you want learn more on notification services, read online docs:
http://msdn.microsoft.com/library/?u...asp?frame=true
--
Miha Markic [MVP C#] - RightHand .NET consulting & development
miha at rthand com
www.rthand.com

"Moogy" <no****@nospam.com> wrote in message
news:10*************@corp.supernews.com...

Hey Miha, did you see my post about how to receive event changes from the SQL server?

Nobody has really responded. Would be nice to get some help on that...

MOOGY!