listbox values

[eyeseetee]

Hi I have a listbox which binds data from a database, I can see the datatextfield values but how would i see the datavaluefield values as well, i.e. show two columns in a listbox Is this possible? Is it better to use another control? thanks :)

[N a v a n e e t h]

I don't think that ListBox can display data like this.

All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia How to use google | Ask smart questions

[eyeseetee]

Would a dropdownlist be better? Badically ive got some values in a listbox but I also need to get their IDs ive got them in the datavaluefield but im not sure how to view this?

[N a v a n e e t h]

.netman wrote:

dropdownlist be better?

Nope. You won't be able to view the value. If you need just to display data, use Repeater.

All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia How to use google | Ask smart questions

[eyeseetee]

ok thanks for the reply I have another question then which is related to the listbox basically i have the loop that was discussed yday but with a stored procedure in Now what I would like to do is for each row in the database it gets updated with one of the items from the listitem i.e. i have 1,2,3,4,5 in listbox then in the table it would do the following id1 = 1 id2 = 2 id3 = 3 id4 = 4 id5 = 5 However all it does at the mo is add the same number to all the ids instead of one item applied to each id Why is this? any help would be great!! thanks :) foreach (ListItem item in listbox1.Items) { SqlCommand cmd = new SqlCommand("stored_procedure", con); cmd .CommandType = CommandType.StoredProcedure; }

[N a v a n e e t h]

.netman wrote:

However all it does at the mo is add the same number to all the ids instead of one item applied to each id

This doesn't make any sense to me. Can you explain more ?

All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia How to use google | Ask smart questions

[Darsh_3]

u can take another listbox and bind it with previous listbox's datavaluefield. but u cant display both DataTextField & DataValueField in same ListBox