Hello all I have a Registration page that lists students in a gridView. I select the student I want which loads the registration details page (or gridViewDetails whatever you want to call it) This page should now show me the courses that the student has signed up for along with student info based on the QueryStringParameter studentID. It works fine when using one table but the data I need requires a join from multiple tables. The following code works when using just one table
[code]
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:myConnection %>" SelectCommand=" SELECT [StudentID], [firstName] FROM [Student] WHERE ([StudentID] = @StudentID)"><SelectParameters><asp:QueryStringParameter Name="StudentID" QueryStringField="StudentID" Type="Int32" /></Select Parameters></asp:SqlDataSource>
[/code]
Code works fine and displays the selected student from the previous page but I ...
Go to the complete details ...