ASP.NETµÄACCESSÊý¾Ý¿â²Ù×÷Àà

//private string datapatch = ConfigurationSettings.AppSettings["acessconn"];//Êý¾Ý¿âµØÖ· 
private string datapatch = "db/global.asa";//Êý¾Ý¿âµØÖ· 
/// 
/// È¡µÃdataset 
// 
/// ²éѯÓï¾ä 
/// 
public DataSet GetDataSet(string Commandtext) 
{ 
string strConnection = "Provider=Microsoft.Jet.OLEDB.4.0; " + 
"Data Source=" + Server.MapPath(datapatch); 
string strCommandText = Commandtext; 
OleDbConnection myConnection = new OleDbConnection(strConnection); 
myConnection.Open(); 
OleDbDataAdapter myAdpater = new OleDbDataAdapter(strCommandText,myConnection); 
OleDbCommandBuilder myBuilder = new OleDbCommandBuilder(myAdpater); 
DataSet myDataset = new DataSet(); 
myAdpater.Fill(myDataset); 
myConnection.Close(); 
return myDataset; 
} 
/// 
/// È¡µÃ±í 
/// 
/// ²éѯÓï¾ä 
/// 
public DataTable GetDataTable(string Commandtext) 
{ 
string strConnection = "Provider=Microsoft.Jet.OLEDB.4.0; " + 
"Data Source=" + Server.MapPath(datapatch); 
string strCommandText =Commandtext; 
OleDbConnection myConnection = new OleDbConnection(strConnection); 
myConnection.Open(); 
OleDbDataAdapter myAdpater = new OleDbDataAdapter(strCommandText,myConnection); 
OleDbCommandBuilder myBuilder = new OleDbCommandBuilder(myAdpater); 
DataSet myDataset = new DataSet(); 
myAdpater.Fill(myDataset); 
DataTable mytable = myDataset.Tables[0]; 
myConnection.Close(); 
return mytable; 
} 
/// 
/// È¡µÃijÐеÄijÁеÄÖµ 
/// 
/// ÁеÄÃû³Æ 
/// ËùÊô±íÃû 
/// ±íµÄÖ÷¼ü 
/// ÁÐËùÊôµÄÖ÷¼üÖµ 
/// 
public string GetDataColum(string strColumnName,string strTableName,string strColumnkey,string strColumnValue) 
{ 
string strConnection = "Provider=Microsoft.Jet.OLEDB.4.0; " +