[samforever1989]

I am using a combobox.. and I want to display two columns combobox using the diplay member property...for example I have a table sam and it has two columns A and B .


following are details of column A

A

---

1

2

3



following are the details of column B


B

---

4

5

6




Now I want to display them into combobox as following...


1

2

3

4

5

6

[Sergio Tapia]

So you want to fetch all records from a column and another column and display them together?

[samforever1989]

Sergio Tapia, on 17 December 2010 - 04:51 AM, said:

So you want to fetch all records from a column and another column and display them together?

ya...
in the order which I have previosly specified..

[Sergio Tapia]

foreach (var record in FetchFromColumnA() as string)
{
    comboBox1.Items.Add(record);
}

foreach (var record in FetchFromColumnB() as string)
{
    comboBox1.Items.Add(record);
}

You'll have to implement the Fetch methods but that's easy enough.

Can you tell us why you want to do something like this? Maybe we can suggest a better solution.

[samforever1989]

Sergio Tapia, on 17 December 2010 - 05:19 AM, said:

foreach (var record in FetchFromColumnA() as string)
{
    comboBox1.Items.Add(record);
}

foreach (var record in FetchFromColumnB() as string)
{
    comboBox1.Items.Add(record);
}

You'll have to implement the Fetch methods but that's easy enough.

Can you tell us why you want to do something like this? Maybe we can suggest a better solution.

The purpose of doing so is that ,,, I want the user to select any record from both of these fields that are being displayed in combobox using displayMember property but I will get its userID (this is column name that I kept in valueMember field)

Any way thanks for the code but could you please give it in C#...because I don not know vb...

[Sergio Tapia]

From a UX standpoint, it'd be better to have two separate comboBoxes and properly label them. You'd still be giving the user the options to get the UserID however they want, but not confuse them.

ComboBox1
---------
sergio
lucas
george
boston
roslindale
austin

That's very confusing to look at and will probably be counter productive.

[JackOfAllTrades]

Quote

foreach (var record in FetchFromColumnA() as string)
{
    comboBox1.Items.Add(record);
}

foreach (var record in FetchFromColumnB() as string)
{
    comboBox1.Items.Add(record);
}

Any way thanks for the code but could you please give it in C#...because I don not know vb..

That IS C#!

Copy, paste, repeat, eh?

[samforever1989]

Sergio Tapia, on 17 December 2010 - 05:33 AM, said:

From a UX standpoint, it'd be better to have two separate comboBoxes and properly label them. You'd still be giving the user the options to get the UserID however they want, but not confuse them.

ComboBox1
---------
sergio
lucas
george
boston
roslindale
austin

sergio what about code in c# ??
I told you that I don't understand vb...
plz give me it in c#..
That's very confusing to look at and will probably be counter productive.

[Sergio Tapia]

You forgot to post code or text. You just quoted me.

[samforever1989]

I am talking about the code you provided...
following code

foreach (var record in FetchFromColumnA() as string)
	{
	    comboBox1.Items.Add(record);
	}
	 
	foreach (var record in FetchFromColumnB() as string)
	{
	    comboBox1.Items.Add(record);
	}

[Sergio Tapia]

That's not visual basic code. That's C#, the code won't work because the Fetch methods aren't implemented. Are you just copy pasting the code?

[samforever1989]

Sergio Tapia, on 17 December 2010 - 06:18 AM, said:

That's not visual basic code. That's C#, the code won't work because the Fetch methods aren't implemented. Are you just copy pasting the code?

no it just seem to me...bcoz you used ...
"var" and "as" keywords....

[Sergio Tapia]

Read about the var keyword here:
http://stackoverflow...ar-keyword-in-c

[Curtis Rutland]

var
as