Đang chuẩn bị nút TẢI XUỐNG, xin hãy chờ
Tải xuống
Chương 23 Quick tham khảo để làm này Tạo một kết nối đến một Sử dụng các nguồn dữ liệu cấu hình Wizard. Wizard sẽ nhắc bạn cho các chi tiết của kết nối để tạo và cơ sở dữ liệu đồ họa trong các đối tượng cơ sở dữ liệu để sử dụng. Visual Studio 2005. | Chapter 23 Quick Reference To Create a connection to a database graphically in Visual Studio 2005. Browse data in Visual Studio 2005. Change the way in which a DataTable will be presented on a form. Modify the way in which fields in a data source will be displayed on a form. Add a DataTable to a form. Programmatically connect to a database. Create and execute a database query in code. Fetch data by using a SqlData-Reader object. Do this Use the Data Source Configuration Wizard. The wizard prompts you for the details of the connection to create and the database objects to use. In the Data menu click Preview Data. The Preview Data dialog box allows you to select a DataSet and DataTable object. Click the Preview button to view the data. In the Data Sources window click Show Data Sources on the Data menu if this window is not displayed click the DataTable. Select the style DataGridView Details or None from the drop-down menu that appears. In the Data Sources window expand the DataTable containing the fields to be modified. Click the field and select the presentation style from the drop-down menu that appears. Click and drag a DataTable object from the Data Sources window onto the form. Either a collection of fields or a DataGridView is added to the form. Visual Studio 2005 also generates a DataSet a BindingSource a TableAdapter and a BindingNavigator object for connecting the form fields or DataGridView to the database and moving through the data. Create an SqlConnection object set its ConnectionString property with details specifying the database to use and call the Open method. Create an SqlCommand object. Set its Connection property to a valid SqlConnection object. Set its CommandText property to a valid SQL SELECT statement. Call the ExecuteReader method to run the query and create an SqlDataReader object. Ensure the data is not null by using the IsDBNull method. If the data is not null use the appropriate GetXXX method such as GetString or GetInt32 to retrieve the
