.

.

19. Be sure the Yes, save this connection as check box is selected, and then click Next.

20. The wizard displays a page where you can specify what data you want to fetch from the database:

21. From the Name list under Table or View Options, select CourseDetails.

22. In the Columns box, check CourseId and CourseName.

23. Click Next.

24. Click Test Query to be sure that you are getting the data you want.

25. Click Finish.

26. The Choose Data Source dialog box is displayed, with the name of the data source control you have configured displayed.

27. From the Select a data field to display in the DropDownList list, select CourseName.

28. This specifies that the value of the CourseName field will be displayed as the text of the items in the drop-down list.

29. From the Select a data field for the value of the DropDownList list, select CourseId.

30. This specifies that when an item is selected, the CourseId field will be returned as the value of the item.

31. Click OK.

32. Before proceeding, test the drop-down list.

To test the drop-down list

1. Press CTRL+F5 to run the page.

2. When the page is displayed, examine the drop-down list.

3. Select a category to be sure that the list performs a post-back.

First Page: ASP.NET DataBound Controls - Details View