how to load data to dropdownlist?

[sacr83]

Hi all, I want to load a database column to a dropdownlist.So how to load data to dropdownlist? DB is MSSQL 2005 Language is C# thanks

CheeN

[Christian Graus]

select myCol from myTable and then bind the resultant datatable to the control. You can also set the display and data member if you want, you'll need to do this if you select more than one column.

Christian Graus Please read this if you don't understand the answer I've given you "also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )