Hello all
I have a drop down list bounded to a sqldatasource. 
After a user selected an item in drop down list, i want to use other fields of the selected row to display or using for filtering another sqldata source, how i can access the selected row of the sqlDatasource.
I appreciate for help
here is the code example.
The sqldatasource return 9 fields, filtered on Email, then the drop down list return value MusicSerial which i use to work latter, 
but i need to access "StudentSerial" or even other fields to work latter.
For example how i can display FN in a label inside form?
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:dtcProjects %>" SelectCommand="SELECT [StudentSerial], [MusicSerial], [FN], [LN], [Email], [TitleEN], [TitleFA], [DetailEN], [DetailFA] FROM [viewStudent ...

Go to the complete details ...