.

.

.

6. This configures the control so that it causes the page to post back to the server whenever a selection is made from the list, rather than waiting until the user clicks a button.

7. In the smart tag panel, select Choose Data Source.

8. The Choose Data Source wizard starts.

9. In the Select a data source list, click < New Data Source >.

10. The Data Source Configuration dialog box is displayed:

11. Select Database.

12. This specifies that data is to be fetched from a database that supports SQL statements. (This includes SQL Server and other OLE-DB-compatible databases.)

13. In the Specify an ID for the data source box, a default data source control name is displayed (SqlDataSource1).

14. Click OK.

15. The wizard displays a page where a connection has to be selected:

16. From the Choose a data connection list, select the connection created earlier.

17. Click Next.

18. The wizard displays a page where you can choose to store the connection string in the configuration file.