TAILIEUCHUNG - ASP.NET 4 Unleased - p 53

Using the GridView Control ” SelectCommand=”SELECT LastName,FirstName FROM Employees” Runat=”server” / ” SelectCommand=”SELECT * FROM Employees WHERE FirstName=@FirstName AND LastName=@LastName” Runat=”server” In Listing , the SelectedDataKey() method retrieves the primary key of the selected employee. The SelectedDataKey() method is used in both of the ControlParameters contained in | 494 CHAPTER 11 Using the GridView Control br style clear both div asp SqlDataSource id srcEmployees ConnectionString ConnectionStrings Employees SelectCommand SELECT LastName FirstName FROM Employees Runat server asp SqlDataSource id srcEmployeeDetails ConnectionString ConnectionStrings Employees SelectCommand SELECT FROM Employees WHERE FirstName @FirstName AND LastName @LastName Runat server SelectParameters asp ControlParameter Name FirstName ControlID grdEmployees PropertyName SelectedDataKey FirstName asp ControlParameter Name LastName ControlID grdEmployees PropertyName SelectedDataKey LastName SelectParameters asp SqlDataSource form body html In Listing the SelectedDataKey method retrieves the primary key of the selected employee. The SelectedDataKey method is used in both of the ControlParameters contained in the second SqlDataSource control. If you use SelectedValue instead of SelectedDataKey you can return only the value of the first data key and not both values. A GridView stores data keys in a collection called the DataKeys collection. This collection is exposed by the GridView control s DataKeys property. You can retrieve the data key associated with any row by using a statement that looks like this Object key 6 .Value From the Library of Wow eBook Gridview Control Fundamentals 495 This statement returns the value of the data key associated with the seventh row in the GridView. Remember that the rows collection is zero-based. If you have assigned multiple data keys to each row you can use a statement that looks like this Object key 6 .Values LastName This statement retrieves the value of the LastName key for the seventh row in the GridView. 11 Sorting Data You can sort the rows rendered by a GridView control by enabling the AllowSorting property. For example the page in Listing illustrates how you can sort the contents of the Movies database table. LISTING @ Page Language C DOCTYPE html

• Kỹ thuật lập trình
• ASP
• NET
• tài liệu học ASP
• NET
• Microsoft
• NET Framework
• ASP
• NET Configuration
• ASP
• NET Features
• Advanced ASP
• NET
• tài liệu về ASP
• ứng dụng ASP
• cài đặt ASP
• bài giảng về ASP
• hướng dẫn học ASP
• lập trình website
• thực hành asp
• NET 2
• Kỹ thuật lập trình
• Pro ASP
• 0 in C# 2005
• Net websites
• Beginning ASP
• NET 3
• 5 in VB 2008
• Net MVC 3
• Giáo trình Asp
• Mô hình MVC trong Asp
• Thành phần Asp
• Net MVC
• Lợi ích Asp
• Bài giảng ASP 1
• Giới thiệu ASP
• Cơ bản về ASP
• Truy cập CSDL với ASP
• Quá trình xử lí một file
• Cấu hình IIS
• Lập trình web với ASP
• Bài giảng Lập trình web với ASP
• Ngôn ngữ kịch bản VBScript
• Lập trình web động với ASP
• Truy xuất CSDL trong ASP với ADO