67.68.69.70.71.72.73.}}catch{success=false;returndt;}C#操作Access之按列读取mdb的基本内容就向你介绍到这里，希望对你了解和学习C#操作Access之按列读取mdb有所帮助。?C#操作Access实例解析C#操作Access实例是怎么实现的呢？让我们来看看具体的代码：1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18.19.20.21.22.23.24.}privatestaticvoidopenConnection(){//////DataAccess的摘要说明C#操作Access实例解析///publicclassDataAccess{protectedstaticOleDbConnectionconn=newOleDbConnection();protectedstaticOleDbCommandcomm=newOleDbCommand();publicDataAccess(){//initC#操作Access实例解析usingSystem;usingSystem.Data;usingSystem.Configuration;usingSystem.Web;usingSystem.Web.Security;usingSystem.Web.UI;usingSystem.Web.UI.WebControls;usingSystem.Web.UI.WebControls.WebParts;usingSystem.Web.UI.HtmlControls;usingSystem.Data.OleDb;25.26.27.28.29.30.31.32.33.34.35.36.37.38.39.40.41.42.43.44.45.46.47.48.49.50.51.52.53.54.55.56.57.58.59.60.61.62.if(conn.State==ConnectionState.Closed){conn.ConnectionString=@\DataSource=\myconn\//web.config文件里设定。comm.Connection=conn;try{conn.Open();}catch(Exceptione){thrownewException(e.Message);}}}//打开数据库C#操作Access实例解析privatestaticvoidcloseConnection(){if(conn.State==ConnectionState.Open){conn.Close();conn.Dispose();comm.Dispose();}}//关闭数据库C#操作Access实例解析publicstaticvoidexcuteSql(stringsqlstr){try{openConnection();comm.CommandType=CommandType.Text;comm.CommandText=sqlstr;comm.ExecuteNonQuery();}catch(Exceptione){63.64.65.66.67.68.69.70.71.72.73.74.75.76.77.78.79.80.81.82.83.84.85.86.87.88.89.90.91.92.93.94.95.96.97.98.99.thrownewException(e.Message);}finally{closeConnection();}}//执行sql语句C#操作Access实例解析publicstaticOleDbDataReaderdataReader(stringsqlstr){OleDbDataReaderdr=null;try{openConnection();comm.CommandText=sqlstr;comm.CommandType=CommandType.Text;dr=comm.ExecuteReader(CommandBehavior.CloseConnection);}catch{try{dr.Close();closeConnection();}catch{}}returndr;}//返回指定sql语句的OleDbDataReader对象，使用时请注意关闭这个对象。publicstaticvoiddataReader(stringsqlstr,refOleDbDataReaderdr){try{openConnection();comm.CommandText=sqlstr;comm.CommandType=CommandType.Text;100.dr=comm.ExecuteReader(CommandBehavior.CloseConnection);101.}102.catch103.{104.try105.{106.if(dr!=null&&!dr.IsClosed)107.108.}110.{111.}112.finally113.{114.closeConnection();115.}116.}117.119.120.121.publicstaticDataSetdataSet(stringsqlstr){}118.//返回指定sql语句的OleDbDataReader对象,使用时请注意关闭dr.Close();//C#操作Access实例解析109.catch122.DataSetds=newDataSet();123.OleDbDataAdapterda=newOleDbDataAdapter();124.try125.{126.openConnection();127.comm.CommandType=CommandType.Text;128.comm.CommandText=sqlstr;129.da.SelectCommand=comm;130.da.Fill(ds);131.132.}133.catch(Exceptione)134.{135.thrownewException(e.Message);136.}137.finally138.{139.closeConnection();140.}141.returnds;142.143.144.146.publicstaticvoiddataSet({145.stringsqlstr,refDataSetds)147.OleDbDataAdapterda=newOleDbDataAdapter();148.try149.{150.openConnection();151.comm.CommandType=CommandType.Text;152.comm.CommandText=sqlstr;153.da.SelectCommand=comm;154.da.Fill(ds);155.}156.catch(Exceptione)157.{158.thrownewException(e.Message);159.}160.finally161.{162.closeConnection();163.}164.165.166.167.publicstaticDataTabledataTable(stringsqlstr){}//返回指定sql语句的datasetC#操作Access实例解析}//返回指定sql语句的datasetC#操作Access实例解析168.DataTabledt=newDataTable();169.OleDbDataAdapterda=newOleDbDataAdapter();170.try171.{172.openConnection();173.comm.CommandType=CommandType.Text;174.comm.CommandText=sqlstr;175.da.SelectCommand=comm;176.da.Fill(dt);