C#操作Access实例解析

C#操作Access实例是怎么实现的呢？让我们来看看具体的代码： using System; using System.Data; using System.Configuration; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.We

C#操作Access实例是怎么实现的呢？让我们来看看具体的代码：

using System;  

using System.Data;  


using System.Configuration;  


using System.Web;  


using System.Web.Security;  


using System.Web.UI;  


using System.Web.UI.WebControls;  


using System.Web.UI.WebControls.WebParts;  


using System.Web.UI.HtmlControls;  


using System.Data.OleDb;   

 

/// 
 


/// DataAccess 的摘要说明 C#操作Access实例解析 


///   


public class DataAccess  

{  

 protected static OleDbConnection conn = new OleDbConnection();  


 protected static OleDbCommand comm = new OleDbCommand();  


public DataAccess()  

{  

   //init C#操作Access实例解析 

}  

 private static void openConnection()  

 {  

if (conn.State == ConnectionState.Closed)  

{  
conn.ConnectionString = @"Provider=Microsoft.Jet.OleDb.4.0;  

Data Source="+ConfigurationManager.AppSettings["myconn"];  


//web.config文件里设定。  

comm.Connection = conn;  

try 

{  
conn.Open();  
}  

catch (Exception e)  


{ throw new Exception(e.Message); }  

 
}  
     

 }//打开数据库 C#操作Access实例解析

    

 private static void closeConnection()  

 {  

if (conn.State == ConnectionState.Open)  

{   
conn.Close();  
conn.Dispose();  
comm.Dispose();  
}  

 }//关闭数据库 C#操作Access实例解析 

 

 public static void excuteSql(string sqlstr)  

 {  

try 

{  
openConnection();  
comm.CommandType = CommandType.Text;  
comm.CommandText = sqlstr;  
comm.ExecuteNonQuery();  
}  

catch (Exception e)  

{  

throw new Exception(e.Message);  

}  

finally 

{ closeConnection(); }  

 }//执行sql语句 C#操作Access实例解析 

 

 public static OleDbDataReader dataReader(string sqlstr)  

 {  

OleDbDataReader dr = null;  


try 

{  
openConnection();  
comm.CommandText = sqlstr;  
comm.CommandType = CommandType.Text;  
 
dr = comm.ExecuteReader(CommandBehavior.CloseConnection);  
}  

catch 

{  

try 

{  
dr.Close();  
closeConnection();  
}  

catch { }  

}  

return dr;  

}  

//返回指定sql语句的OleDbDataReader对象，使用时请注意关闭这个对象。  


 public static void dataReader(string sqlstr,  


 ref OleDbDataReader dr)  

 {  

try 

{  
openConnection();  
comm.CommandText = sqlstr;  
comm.CommandType = CommandType.Text;  
dr=comm.ExecuteReader(CommandBehavior.CloseConnection);  
}  

catch 

{  

try 

{  

if (dr != null && !dr.IsClosed)  

   dr.Close();  
}  //C#操作Access实例解析

catch 

{  
}  

finally 

{  
closeConnection();  
}  
}  
 }  

//返回指定sql语句的OleDbDataReader对象,使用时请注意关闭  

 

 public static DataSet dataSet(string sqlstr)  

 {  

DataSet ds = new DataSet();  


OleDbDataAdapter da = new OleDbDataAdapter();  


try 

{  
openConnection();  
comm.CommandType = CommandType.Text;  
comm.CommandText = sqlstr;  
da.SelectCommand = comm;  
da.Fill(ds);  
 
}  

catch (Exception e)  

{  

throw new Exception(e.Message);  

}  

finally 

{  
closeConnection();  
}  

return ds;  


 }//返回指定sql语句的dataset C#操作Access实例解析 

 

 public static void dataSet(  


string sqlstr, ref DataSet ds)  

 {  

OleDbDataAdapter da = new OleDbDataAdapter();  


try 

{  
openConnection();  
comm.CommandType = CommandType.Text;  
comm.CommandText = sqlstr;  
da.SelectCommand = comm;  
da.Fill(ds);  
}  

catch (Exception e)  

{  

throw new Exception(e.Message);  

}  

finally 

{  
closeConnection();  
}  

 }//返回指定sql语句的dataset C#操作Access实例解析

 

 public static DataTable dataTable(string sqlstr)  

 {  

DataTable dt = new DataTable();  


OleDbDataAdapter da = new OleDbDataAdapter();  


try 

{  
openConnection();  
comm.CommandType = CommandType.Text;  
comm.CommandText = sqlstr;  
da.SelectCommand = comm;  
da.Fill(dt);  
}  

catch (Exception e)  

{  

throw new Exception(e.Message);  

}  

finally 

{  
closeConnection();  
}  

return dt;  


 }//返回指定sql语句的datatable  


 public static void dataTable(  


string sqlstr, ref DataTable dt)  

 {  

OleDbDataAdapter da = new OleDbDataAdapter();  


try 

{  
openConnection();  
comm.CommandType = CommandType.Text;  
comm.CommandText = sqlstr;  
da.SelectCommand = comm;  
da.Fill(dt);  
}  

catch (Exception e)  

{  

throw new Exception(e.Message);  

}  

finally 

{  
closeConnection();  
}  

 }//返回指定sql语句的datatable C#操作Access实例解析 

 

 public static DataView dataView(string sqlstr)  

 {  

OleDbDataAdapter da = new OleDbDataAdapter();  


DataView dv = new DataView();  


DataSet ds = new DataSet();  


try 

{  
openConnection();  
comm.CommandType = CommandType.Text;  
comm.CommandText = sqlstr;  
da.SelectCommand = comm;  
da.Fill(ds);  
dv = ds.Tables[0].DefaultView;  
}  

catch (Exception e)  

{  

throw new Exception(e.Message);  

}  

finally 

{  
closeConnection();  
}  

return dv;  

 }  

//返回指定sql语句的dataview C#操作Access实例解析 

 
} 

C#操作Access实例解析的基本内容就向你介绍到这里，希望对你了解和学习C#操作Access有所帮助。