A SqlDataSource control is supplying author's information from pubs database to a DataGridControl in the form. All the States for which at least one author exist are displayed in the DropdownList. This video shows linking the DropDownList control to the Where Clause of the SqlDataSource Control which supplies the data to the DataGridView Control.