asp.netÁ¬½ÓaccessÊý¾Ý¿â½øÐÐÌí¼Ó¸üÐÂɾ³ý²éѯ²Ù×÷

Á¬½ÓaccessÊý¾Ý¿â´úÂ룬дÔÚÒ»¸öµ¥¶ÀµÄÀàÀï
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.OleDb;
namespace AppWebDLL
{
    public class ConnApp
    {
        public OleDbConnection getCon() {
          
            string strConnection = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+System.Web.HttpContext.Current.Server.MapPath("App_Data\\UserDB.mdb")+";Jet OLEDB:Database Password=admin";
            OleDbConnection objConnection = new OleDbConnection(strConnection);
            return objConnection;
        }
    }
}
ÎÒÕâÏ°¹ßÕâÑùдµÄ£¬ÔÚÕâÀïSystem.Web.HttpContext.Current.Server.MapPathÊÇÓÃÀ´È¡µÃaccessµÄÏà¶Ô·¾¶µÄ£¬ÔÚÕâ¸öÀàÀïÏëҪʹÓÃSystem.Web.HttpContext.Current.Server.MapPath£¬ÏÈÒªÒýÓÃsystem.webÕâ¸öÀà¡£
Ôöɾ¸Ä²é´úÂ룬ÒÔÎÒµÄÀàдµÄ£¬ÕâÀïҪעÒâÒ»¸ö£¬Èç¹ûÄãµÄ×ֶκÍaccessµÄ¹Ø¼ü×ÖÒ»Ñù£¬ÄÇôÄã¾ÍÒªÔÚÄãµÄ×Ö¶ÎÉÏ¼Ó [ ]£¬ÈçpasswordÊÇaccessµÄ¹Ø¼ü×Ö£¬Èç¹ûÄãµÄ×Ö¶ÎÓÐÕâ¸ö£¬ÄãÔÚ×ö²Ù×÷µÄʱºò¾ÍÒªÕâÑùд[password]
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using AppWebDLL;
using System.Data;
using System.Data.OleDb;
using System.Collections;
namespace AppBLL
{
public class Land
{
ConnApp capp = new ConnApp();
OleDbConnection db;
OleDbCommand olecom = null;
//²éѯËùÓÐÓû§
public ArrayList GetAllUser() {
ArrayList alluserlist = new ArrayList();
db = capp.getCon();
try
{
string sql = "select USERNAME from userinfo";
olecom = new OleDbComman