Beginning ASP.NET 2.0 and Databases学习笔记（3）

 

Chapter 4 ：连接到其它数据提供者

 

 

使用 SQL Server 数据提供者：

<asp:SqlDataSource ID="NorthwindProductsSqlDataSource" Runat="server"

ConnectionString=

          "Data Source=./SQLEXPRESS;

        AttachDbFilename=|DataDirectory|/Northwind.mdf;

        Integrated Security=True;

        User Instance=True"

ProviderName=System.Data.SqlClient

SelectCommand="SELECT * FROM MyTable" />

 

使用Oracle数据提供者：

<asp:SqlDataSource ID="MyOracleSqlDataSource" Runat="server"

 ProviderName=System.Data.OracleClient

      ConnectionString=

        "Data Source=MyOracleServer;

        User ID=MyID;

        Password=MyPassword;

        Integrated Security=SSPI"

 SelectCommand=" ... />

 

使用 OLEDB or ODBC 数据提供者：

<asp:SqlDataSource ID="MyAcmeSqlDataSource" Runat="server"

 ProviderName=System.Data.OleDb

 ConnectionString=

         "Provider=AcmeDev.MsSqlServerProvider.OLEDB.1.2.3;

         Server=MySqlServer;

         User ID=MyUSer;

         Password=MyPass;"

 SelectCommand="SELECT * FROM MyTable"/>

 

使用ODBC 连接Excel：

<asp:SqlDataSource ID="MyBonzoExcelDataSource" Runat="server"

 ProviderName="System.Data.ODBC"

 ConnectionString=

         "Driver=AcmeDev.ExcelDriver.ODBC.4.5.6;

         FieldName=MySheet.xls;"

 SelectCommand="JanuaryRange "/>

 

连接到带密码的Access数据库：

在web.config中设置连接串：

<add name="NorthwindConnectionString"

ConnectionString="Provider=Microsoft.Jet.OLEDB.4.0;

Data Source=|DataDirectory|/MyFileWithPassword.mdb;"

Persist Security Info=True;

Database Password=MyPasswordForTheDatabase;

providerName="System.Data.OleDb" />

或者：

<add name="NorthwindConnectionString"

ConnectionString="Provider=Microsoft.Jet.OLEDB.4.0;

 Data Source=|DataDirectory|/MyFileWithPassword.mdb;

Persist Security Info=True;

User ID=MyUserId;

Password=MyPassword;

Jet OLEDB:System Database='|DataDirectory|/Security.mdw' "

providerName="System.Data.OleDb" />

 

 

连接到 Oracle 数据库：

<asp:SqlDataSource ID="SqlDataSource1"

ProviderName="System.Data.OracleClient"

ConnectionString="

 Data Source=Oracle8i;

 User ID=MyID;

 Password=MyPassword;

 Integrated Security=SSPI"

SelectCommand=" ... "

Runat="server" />

 

 

连接到 MySQL 数据库：

<asp:SqlDataSource ID="SqlDataSource1" Runat="server"

         ProviderName="System.Data.Odbc"

         ConnectionString= "DRIVER={MySQL ODBC 3.51 Driver};

                          SERVER=localhost;

                          DATABASE=mysql;

                          UID=root;

                          PASSWORD=MyRootPassword;

                          OPTION=3"

      SelectCommand="SELECT host, user, create_priv, password FROM user"

> 

</asp:SqlDataSource>

 

连接到Excel 数据库：

<asp:SqlDataSource ID="SqlDataSource1" runat="server"

            ConnectionString="Provider=Microsoft.Jet.OLEDB.4.0;

                Data Source=C:/MyPath/MyExcelFile.xls;

                Extended Properties='Excel 8.0' "

            ProviderName="System.Data.OleDb"

            SelectCommand="SELECT * FROM [sheet1$]">

</asp:SqlDataSource>

 

如果需显示列标题（第一行为标题），反之不显示：

Extended Properties='Excel 8.0';HDR=Yes"

Extended Properties='Excel 8.0';HDR=No"

 

<asp:SqlDataSource ID="SqlDataSource1" runat="server"

            ConnectionString="Provider=Microsoft.Jet.OLEDB.4.0;

                Data Source=|DataDirectory|Fruits.xls;

                Extended Properties='Excel 8.0';HDR=yes"

            ProviderName="System.Data.OleDb"

            SelectCommand="SELECT Name, Color FROM [sheet1$]">

</asp:SqlDataSource>