SQLDataSource連結非SQLServer資料庫
若有使用到SQLDataSource，連結的資料庫通常都是SQLServer 但若有一天客戶的需求是要連結到不同的資料庫(如:Oracle,Informix)怎麼辨呢? Don't Worry...只要在組態檔設定如下即可解決囉 <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:FormConnectionString %>" ProviderName="<%$ ConnectionStrings:FormConnectionString.ProviderName %>" SelectCommand='SELECT * FROM "PJSUBPJ"'> </asp:SqlDataSource> <connectionStrings> <add name="FormConnectionString" connectionString="Data Source=oracle9i.systemlead.com;Persist Security Info=True;User ID=caita;Password=caita;Unicode=True" providerName=" System.Data.OracleClient " /> </connectionStrings>