ASP.NET oledb连接Access数据库的方法

using System;using System.Collections.Generic;using System.Linq;using System.Web;using System.Web.UI;using System.Web.UI.WebControls;using System.Data.OleDb;public partial class _Default : System.Web.UI.Page{  protected void Page_Load(object sender, EventArgs e)  {     //数据库连接，记录集的获取    //注意更改路径    String sqlconn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source = E:/pro/web/access_test/app_data/Northwind.mdb;Jet OLEDB:Database Password=111111";    OleDbConnection myConnection = new OleDbConnection(sqlconn);    myConnection.Open();    OleDbCommand myCommand = new OleDbCommand("select * from 运货商", myConnection);    OleDbDataReader myReader;    myReader = myCommand.ExecuteReader();       //读取记录集    Response.Write("<table border=1 cellspacing=0 cellpadding=2>");    Response.Write("<tr bgcolor=#DAB4B4>");    for (int i = 0; i < myReader.FieldCount; i++)      Response.Write("<td>" + myReader.GetName(i) + "</td>");    Response.Write("</tr>");        while (myReader.Read())    {      Response.Write("<tr>");      for (int i = 0; i < myReader.FieldCount; i++)        Response.Write("<td>" + myReader[i].ToString ()+ "</td>");      Response.Write("</tr>");    }    Response.Write("</table>");    //关闭记录集和连接    myReader.Close();    myConnection.Close();  }}