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

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

Niêm yết 18,35 InsertMovie.cs sử dụng sử dụng sử dụng sử dụng sử dụng hệ thống; System.Web; System.Data; System.Data.SqlClient; System.Web.Configuration; public class InsertMovie {tin tĩnh chỉ đọc chuỗi _conString; công tĩnh SqlDataReader GetMovies () {/ / Khởi tạo kết nối SqlConnection con = new SqlConnection (_conString) | 824 CHAPTER 18 Using the ObjectDataSource Control In Listing 18.34 the Inserted event handler checks for an exception. If an exception exists the exception is handled and an error message displays see Figure 18.10 . FIGURE 18.10 Handling method errors gracefully. The page in Listing 18.34 is bound to the component in Listing 18.35. LISTING 18.35 InsertMovie.cs using System using System.Web using System.Data using System.Data.SqlClient using System.Web.Configuration public class InsertMovie private static readonly string _conString public static SqlDataReader GetMovies Initialize connection SqlConnection con new SqlConnection _conString From the Library of Wow eBook Handling ObjectDataSource Control Events 825 Initialize command SqlCommand cmd new SqlCommand cmd.Connection con cmd.CommandText SELECT Id Title Director FROM Movies Execute command con.Open return cmd.ExecuteReader CommandBehavior.CloseConnection public static void Insert string title string director Initialize connection SqlConnection con new SqlConnection _conString Initialize command SqlCommand cmd new SqlCommand cmd.Connection con cmd.CommandText INSERT Movies Title Director VALUES @Title @Director Add ADO.NET parameters cmd.Parameters.AddWithValue @Title title cmd.Parameters.AddWithValue @Director director Execute command using con con.Open cmd.ExecuteNonQuery static InsertMovie _conString WebConfigurationManager.ConnectionStrings Movies .ConnectionString 18 You can create an exception by entering a new movie record and not supplying a value for one of the fields. For example the Title column in the Movies database table does not accept null values. From the Library of Wow eBook 826 CHAPTER 18 Using the ObjectDataSource Control NOTE Instead of handling errors at the level of the DataSource control you can handle errors at the level of the DataBound control. For example the DetailsView control supports an Itemlnserted event. Handling the Objectcreating Event By default the ObjectDataSource control .