I have a table of schools, and a table of campuses. When someone edits or inserts a school, I have a DetailsView with a DropDownList for all of the campuses. The DropDownList is built as such: <asp:DropDownList ID="CampusDropDownList" runat="server" DataSourceID="CampusSqlDataSource" DataTextField="CampusName" DataValueField="CampusID" SelectedValue='<%# Bind("CampusID") %>' ...
Go to the complete details ...