Niêm yết 18,35 sử dụng sử dụng sử dụng sử dụng sử dụng hệ thống; ; ; ; ; 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 the Inserted event handler checks for an exception. If an exception exists the exception is handled and an error message displays see Figure . FIGURE Handling method errors gracefully. The page in Listing is bound to the component in Listing . LISTING using System using using using using 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 con SELECT Id Title Director FROM Movies Execute command return public static void Insert string title string director Initialize connection SqlConnection con new SqlConnection _conString Initialize command SqlCommand cmd new SqlCommand con INSERT Movies Title Director VALUES @Title @Director Add parameters @Title title @Director director Execute command using con static InsertMovie _conString 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 .
