Hi

I'm trying to link my DropDownList control to my database which contains 2 fields, "Name" and "Email". However, the DropDownList control can only display either name or email. I would like it to be combined to display the name on the left half of the DropDownList, and the email on the right half.
Can this be done?

Thank you

I think up to today there is no any way to link two column with single dropdown list. and just tell why it is required so we other member can understand nad give a beeter solution to you. Ya if you don't mind then there one trick. Do it with datareader first take one field to string then take second field and make single string then add it into drop down list

like

whule(datareader.read()
{
   string s = datareader["field1"].tostring() + datareader["field2"].tostring();
dropdownlistname.items.add(s);
}

I hope it will solved your problem.

TarDuk - A Memory Beyond The Life.

hi there...

a better way will be to do it when you do the query and then pass the table, reader or whatever to the datasource of the combo...

that way you avoid an iteration...

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========
I know that CVS was evil, and now i got the proof:
http://worsethanfailure.com/Articles...-Hate-You.aspx
================================================== =========

To illustrate what Gonzalo is saying, what ever query you are using to populate your datasource change it so it looks something like this:

SELECT
   field1 + ' ' + field2 as DataTextField,
   field3 as DataValueField
From table

hth

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
================================================== =========
Technical Editor for:
Professional Search Engine Optimization with ASP.NET

Professional IIS 7 and ASP.NET Integrated Programming

================================================== =========

Hi

Thank you for all your replies.
I'll be trying the combined method although I'm trying to avoid because I still need to use them, which I have to substring it.
Thank you so much!

I am totally new to ASP.Net but do a lot of windows VB.Net, so I will throw out my idea and see the reactions...

First of all I would use a global datatable and then the selected index of the drop down would be the row index into the datatable to retrieve the original data...

Or I would create an array for the values I want to recover and, again, the selected index from the drop down would be the array index to the actual value I need.

Is this possible in ASP.Net? Not sure since there could be many users at one time and would does ASP.Net keep a datatable or array for each?

If this is a stupid idea, I apologize, but it is how I learn.

John

Hello John.

Normally, when I need to do something similar to the Original Posters question my SQL Table looks something like this:

PK TextField TextField

So, in the context of this example my query would be something like:

SELECT
   PK,
   TextField + ' ' + TextField
FROM Table

I would bind pk as the DataValue and the TextField colum as the DataText for the dropdown. This situaion is more akin to your idea about an array list, although I wouldnt create an arraylist and then bind that to the dropdownlist, i would just bind directly to my dataset from SQL.

I would not use a global datatable for this. I would probably bind to an instance of a datatable/set or a data reader to accomplish this.

Cheers.

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
================================================== =========
Technical Editor for:
Professional Search Engine Optimization with ASP.NET

Professional IIS 7 and ASP.NET Integrated Programming

================================================== =========

Hi

Thank you so much for all of your replies!
Think I cannot escape this portion.
I understand how to combine them already, but I had been trying on how to separate them. Below are my codes:

Dim try as string = "Remy|[email protected]"
dim found as integer = try.indexof("|")
dim result as string = try.substring((found + 1),try.length)

The error returned to me was arguement our of range. How can I rectify this problem?

Thank you

You actually don't need to separate them in code, you can do it (too) with SQL.

Just select the fields as you would normally do and then combine them:

SELECT PK, Name, Email, (Name || ' ' || Email) as Combined FROM MyTable (in PostgreSQL, not sure about the syntax SQL Server uses for string concatenation)

Hi! Thanks for replying, however, I don't really get what you mean from here, "(Name || ' ' || Email) as Combined FROM MyTable".
Sorry, I'm new to SQL statements.
Thank you!