Use Dropdownlist in DetailsView using asp.net/2.0
Instead of textbox, i want to use a dropdownlist in one of the fields in my DetailsView. I am using DetailsView for data entry. And one of the fields shoud be in dropdownlist because the record shoud be come from another table.Please help me how to do this, or yet much better if you have some example..Links to other tutorial are also welcome.
To give you an insight this is what i want.
Location Table:
LocID LocName
1 1rst Floor
2 2nd Floor
3 3rd Loor
Item Table
ItemCode Description LocID
Item1 Chair 1
Item2 Table 2
Item3 Furniture 3
Now I will be using DetailsView to View this "Item Table" records. Also i will allow to edit, delete, and Insert new record.
Obiously what i want to happen is to limit entry for the locID of Item Table to have a referential integrity to Location Table. When i click for the "New" in DetailsView, all data input are in textbox. I want to have dropdownlist on LocID.
Thanks
|