从sqldatamart asp.net中选择下拉列表项

I have 6 dropdownlist that are populated from a sqldatasource. I also have another sqldatasource that returns some rows. What I want to do is to go through each row of the second datasource and select that value in my dropdowns. So if second datasource contains three rows it would select the appropriate value in the first three dropdownlist and set the others to "N/A" for example. I have 6 dropdownlist that are populated from a