Last post Nov 08, 2010 12:29 AM by decker dong - msft
Nov 04, 2010 10:16 PM|Nsrawlings|LINK
I was wondering if anyone could shed some light on a problem. I have a text box that runs a search and produces the value based on an ID Number. When the user runs the search it produces the value correctly. Beside the value on the gridview table it says
'select' I want my users to be able to click the select button and open a form view that displays additional details about that person's membership. ANY help would be appreciated.
Grid Vieview Select
Nov 04, 2010 10:56 PM|codeasp|LINK
This link is exactly what you want
Nov 08, 2010 12:29 AM|Decker Dong - MSFT|LINK
It's very easy without writing any codes at all nearly! Now let's go ：)【For Details：http://www.exforsys.com/tutorials/asp.net-2.0/displaying-master-detail-data-on-separate-pages-in-asp.net-2.0/1.html】
1. Add a new page to the Web site and name it MasterCourses.aspx.
2. Switch to Design view.
3. Type Courses in the page and format the text as a heading.
4. From the Data folder of the Toolbox, drag a GridView control onto the page.
5. In the smart tag panel, from the Connect to Data Source list choose <
New Data Source > and then use the wizard to do the following:
a. Click Database.
b. Connect to the ExForSys database.
c. Retrieve the CourseId, CourseName and CourseDuration columns from the CourseDetails table.
6. Optionally, in the smart tag panel select the Enable
paging check box.
7. In the smart tag panel, choose Edit Columns.
8. The Fields dialog box is displayed.
9. Clear the Auto-Generate Fields check box.
10. Under Available Fields, choose HyperLink Field, click
Add, and then set the following properties:
This indicates that the hyperlink should get its value from the CourseId column
This creates a link that is hard-coded to navigate to the DetailsCourse.aspx page. The link also passes a query string variable named
CourseId whose value will be filled using the column referenced in the
Click OK to close the Fields dialog box.
1. Add a new page to the Web site and name it
3. Type Students in the page and format the text as a heading.
5. In the smart tag panel, from the Choose Data Source list choose <
New Data Source >.
6. In the Select a data source type list, click Database and then click
7. From the Choose a data connection list, select the connection you created and stored earlier.
8. Click Next.
9. The wizard displays a page where you can create a SQL statement.
10. From the Name list under Table or View Options, select CourseDetails.
11. In the Columns box, check StudentId, StudentName and
12. Click WHERE.
13. From the Columns list, select CourseId.
14. From the Operators list, select =.
15. From the Source list, select QueryString.
16. This specifies that the query will select records based on the value passed into the page with the query string.
17. Under Parameter Properties, in the QueryString field box, type
18. The query will get the CourseId value from the query string, which is created when you click a
Details link in the MasterCourses.aspx page.
19. Click Add.
20. Click OK to close the Add WHERE
Clause dialog box.
21. Click Next, and then click Finish to close the wizard.
22. From the Standard node of the Toolbox, drag a Hyperlink control onto the page. Set its
Text property to Return to Courses and its
NavigateUrl property to MasterCourses.aspx.
1. Switch to the MasterCourses.aspx page.
2. Press CTRL+F5 to run the page.
3. Click the Details link for a coursedetails.
4. The browser displays the DetailsCourse.aspx page with course for the selected courseid. Note that the URL in the browser's Address box is: DetailsCourses.aspx?CourseId=xxx. Where xxx is the ID of the course selected.
5. Click the Return to courses link, select a different course, and click the
Details link again to test that you can view courses for any student.