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;        
}        
///         
/// 取得某行的某列的值        
///         
/// 列的名称        
/// 所属表名        
/// 表的主键        
/// 列所属的主键值        
///         
public  string GetDataColum(string strColumnName,string strTableName,
string strColumnkey,string strColumnValue)        
{                    
string strConnection = "Provider=Microsoft.Jet.OLEDB.4.0; " +                 
"Data Source=" + Server.MapPath(datapatch);            
string strCommandText = "select "+strColumnName+","+strColumnkey+" from "+strTableName;                        
OleDbConnection myConnection = new OleDbConnection(strConnection);            
myConnection.Open();            
OleDbDataAdapter myAdpater = new OleDbDataAdapter(strCommandText,myConnection);            
OleDbCommandBuilder myBuilder = new OleDbCommandBuilder(myAdpater);            
DataSet myDataset = new DataSet();