Đang chuẩn bị liên kết để tải về tài liệu:
ASP.NET 4 Unleased - p 82

Không đóng trình duyệt đến khi xuất hiện nút TẢI XUỐNG Tải xuống

Using the ObjectDataSource Control public void UpdateMovie(int id, string title, string director, DateTime ➥dateReleased) { // Create Command SqlConnection con = new SqlConnection(_conString); SqlCommand cmd = new SqlCommand(); cmd.Connection = con; cmd.CommandText = “UPDATE Movies SET Title=@Title,Director=@Director,DateReleased= // Add parameters cmd.Parameters.AddWithValue(“@Title”, title); cmd.Parameters.AddWithValue(“@Director”, director); cmd.Parameters.AddWithValue(“@DateReleased”, dateReleased); cmd.Parameters.AddWithValue(“@Id”, id); // Execute command using (con) { con.Open(); cmd.ExecuteNonQuery(); } } public SqlDataReader GetMovies() { // Create Connection SqlConnection con = new SqlConnection(_conString); // Create Command SqlCommand cmd = new SqlCommand(); cmd.Connection = con; cmd.CommandText = “SELECT Id,Title,Director,DateReleased FROM Movies”; // Return DataReader con.Open(); return. | 784 CHAPTER 18 Using the ObjectDataSource Control public void UpdateMovie int id string title string director DateTime dateReleased Create Command SqlConnection con new SqlConnection _conString SqlCommand cmd new SqlCommand cmd.Connection con cmd.CommandText UPDATE Movies SET Title @Title Director @Director DateReleased Add parameters cmd.Parameters.AddWithValue @Title title cmd.Parameters.AddWithValue @Director director cmd.Parameters.AddWithValue @DateReleased dateReleased cmd.Parameters.AddWithValue @Id id Execute command using con con.Open cmd.ExecuteNonQuery public SqlDataReader GetMovies Create Connection SqlConnection con new SqlConnection _conString Create Command SqlCommand cmd new SqlCommand cmd.Connection con cmd.CommandText SELECT Id Title Director DateReleased FROM Movies Return DataReader con.Open return cmd.ExecuteReader CommandBehavior.CloseConnection public Movies _conString WebConfigurationManager.ConnectionStrings Movies .ConnectionString From the Library of Wow eBook Using Parameters with the ObjectDataSource Control 785 The page in Listing 18.12 contains a GridView and ObjectDataSource control. The ObjectDataSource control includes an UpdateMethod property that points to the UpdateMovie method. LISTING 18.12 ShowMovies.aspx @ Page Language C DOCTYPE html PUBLIC - W3C DTD XHTML 1.1 EN http www.w3.org TR xhtml11 DTD xhtml11.dtd html xmlns http www.w3.org 1999 xhtml head id Head1 runat server title Show Movies title head body form id form1 runat server div asp GridView id grdMovies DataSourceID srcMovies DataKeyNames Id AutoGenerateEditButton true Runat server asp ObjectDataSource id srcMovies TypeName Movies SelectMethod GetMovies UpdateMethod UpdateMovie Runat server div form body html 18 In Listing 18.12 the GridView automatically adds the update parameters to the ObjectDataSource control s UpdateParameters collection. As an alternative you can declare the parameters used by the ObjectDataSource control explicitly. For example the page in .