Đang chuẩn bị nút TẢI XUỐNG, xin hãy chờ
Tải xuống
Kết nối với cơ sở dữ liệu khác Nếu bạn cần kết nối với bất kỳ máy chủ cơ sở dữ liệu khác với Microsoft SQL Server, bạn cần phải sửa đổi sở hữu ProviderName sự kiểm soát của SqlDataSource. . Các NET Framework bao gồm các nhà cung cấp sau đây:. System.Data.OracleClient-Sử dụng các nhà cung cấp ADO.NET cho Oracle khi kết nối với một Oracle | 384 CHAPTER 9 Using the SqlDataSource Control body form id form1 runat server div asp TextBox id txtConnectionString Columns 60 Runat Server asp Button id btnConvert Text Convert OnClick btnConvert_Click Runat Server hr asp Label id lblResult Runat server div form body html After opening the page in Listing 9.2 if you enter a connection string that looks like this Server localhost UID webuser pwd secret database Northwind the page converts the connection string to look like this Data Source localhost Initial Catalog Northwind User ID webuser Password secret Connecting to Other Databases If you need to connect to any database server other than Microsoft SQL Server you need to modify the SqlDataSource control s ProviderName property. The .NET Framework includes the following providers System.Data.OracleClient Use the ADO.NET provider for Oracle when connecting to an Oracle database. System.Data.OleDb Use the OLE DB provider when connecting to a data source that supports an OLE DB provider. System.Data.Odbc Use the ODBC provider when connecting to a data source with an ODBC driver. From the Library of Wow eBook Creating Database Connections 385 NOTE You can configure additional providers that you can use with the SqlDataSource control by adding new entries to the DbProviderFactories section of the Machine.config file. For performance reasons you should always use the native ADO.NET provider for a database. However if your database does not have an ADO.NET provider you need to use either OLE DB or ODBC to connect to the database. Almost every database under the sun has either an OLE DB provider or an ODBC driver. For example the page in Listing 9.3 uses the ADO.NET Oracle provider to connect to an Oracle database. LISTING 9.3 ConnectOracle.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 Connect Oracle title head body form id form1 runat .
