Web.config <?xml version="1.0"?> <configuration> <configSections> ... </configSections> <appSettings/> <connectionStrings> <add name="TestConnectionString" connectionString="Data Source=...;Initial Catalog=..;User ID=.;Password=." providerName="System.Data.SqlClient"/> <add name="peixunConnectionString" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:/Internet/peixun.mdb;Persist Security Info=False" providerName="System.Data.Oledb"/> </connectionStrings> <system.web> <!-- 设置 compilation debug="true" 可将调试符号插入 已编译的页面中。但由于这会 影响性能,因此只在开发过程中将此值 设置为 true。 --> <compilation debug="true"> ... </compilation> </system.web> ... </configuration> db.cs using System; using System.Data; using System.Configuration; using System.Linq; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Xml.Linq; using System.Data.SqlClient; using System.Data.OleDb; namespace Web0531 { static public class db { static public SqlConnection createConnection() { string ConnectionString = ConfigurationManager.ConnectionStrings["TestConnectionString"].ToString(); return new SqlConnection(ConnectionString); } static public OleDbConnection AccessConnection() { string ConnectionString = ConfigurationManager.ConnectionStrings["peixunConnectionString"].ToString(); return new OleDbConnection(ConnectionString); } static public void dataBind(ListView rq, string sql) { OleDbConnection conn = db.AccessConnection(); conn.Open(); OleDbDataAdapter da = new OleDbDataAdapter(sql, conn); DataSet ds = new DataSet(); da.Fill(ds, "table"); rq.DataSource = ds; rq.DataBind(); conn.Close(); da.Dispose(); ds.Dispose(); } } }