Community Learn Tools Library Leisure
search
English
Home > Database > Mysql Tutorial > C#操作Access实例解析

C#操作Access实例解析

WBOY
Release： 2016-06-07 15:44:13
Original
1134 people have browsed it

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实例是怎么实现的呢？让我们来看看具体的代码：

<ol>
<li><span><span>using</span><span> System;  </span></span></li>
<li>
<span>using</span><span> System.Data;  </span>
</li>
<li>
<span>using</span><span> System.Configuration;  </span>
</li>
<li>
<span>using</span><span> System.Web;  </span>
</li>
<li>
<span>using</span><span> System.Web.Security;  </span>
</li>
<li>
<span>using</span><span> System.Web.UI;  </span>
</li>
<li>
<span>using</span><span> System.Web.UI.WebControls;  </span>
</li>
<li>
<span>using</span><span> System.Web.UI.WebControls.WebParts;  </span>
</li>
<li>
<span>using</span><span> System.Web.UI.HtmlControls;  </span>
</li>
<li>
<span>using</span><span> System.Data.OleDb;   </span>
</li>
<li><span> </span></li>
<li>
<span>/// <summary> </summary></span><span> </span>
</li>
<li>
<span>/// DataAccess 的摘要说明 C#操作Access实例解析</span><span> </span>
</li>
<li>
<span>///  </span><span> </span>
</li>
<li>
<span>public</span><span> </span><span>class</span><span> DataAccess  </span>
</li>
<li><span>{  </span></li>
<li>
<span> </span><span>protected</span><span> </span><span>static</span><span> OleDbConnection conn = </span><span>new</span><span> OleDbConnection();  </span>
</li>
<li>
<span> </span><span>protected</span><span> </span><span>static</span><span> OleDbCommand comm = </span><span>new</span><span> OleDbCommand();  </span>
</li>
<li>
<span>public</span><span> DataAccess()  </span>
</li>
<li><span>{  </span></li>
<li>
<span>   </span><span>//init C#操作Access实例解析</span><span> </span>
</li>
<li><span>}  </span></li>
<li>
<span> </span><span>private</span><span> </span><span>static</span><span> </span><span>void</span><span> openConnection()  </span>
</li>
<li><span> {  </span></li>
<li>
<span>if</span><span> (conn.State == ConnectionState.Closed)  </span>
</li>
<li><span>{  </span></li>
<li><span>conn.ConnectionString = @"Provider=Microsoft.Jet.OleDb.4.0;  </span></li>
<li>
<span>Data Source=</span><span>"+ConfigurationManager.AppSettings["</span><span>myconn"];  </span>
</li>
<li>
<span>//web.config文件里设定。 </span><span> </span>
</li>
<li><span>comm.Connection = conn;  </span></li>
<li>
<span>try</span><span> </span>
</li>
<li><span>{  </span></li>
<li><span>conn.Open();  </span></li>
<li><span>}  </span></li>
<li>
<span>catch</span><span> (Exception e)  </span>
</li>
<li>
<span>{ </span><span>throw</span><span> </span><span>new</span><span> Exception(e.Message); }  </span>
</li>
<li><span> </span></li>
<li><span>}  </span></li>
<li><span>     </span></li>
<li>
<span> }</span><span>//打开数据库 C#操作Access实例解析</span>
</li>
<li><span>    </span></li>
<li>
<span> </span><span>private</span><span> </span><span>static</span><span> </span><span>void</span><span> closeConnection()  </span>
</li>
<li><span> {  </span></li>
<li>
<span>if</span><span> (conn.State == ConnectionState.Open)  </span>
</li>
<li><span>{   </span></li>
<li><span>conn.Close();  </span></li>
<li><span>conn.Dispose();  </span></li>
<li><span>comm.Dispose();  </span></li>
<li><span>}  </span></li>
<li>
<span> }</span><span>//关闭数据库 C#操作Access实例解析</span><span> </span>
</li>
<li><span> </span></li>
<li>
<span> </span><span>public</span><span> </span><span>static</span><span> </span><span>void</span><span> excuteSql(</span><span>string</span><span> sqlstr)  </span>
</li>
<li><span> {  </span></li>
<li>
<span>try</span><span> </span>
</li>
<li><span>{  </span></li>
<li><span>openConnection();  </span></li>
<li><span>comm.CommandType = CommandType.Text;  </span></li>
<li><span>comm.CommandText = sqlstr;  </span></li>
<li><span>comm.ExecuteNonQuery();  </span></li>
<li><span>}  </span></li>
<li>
<span>catch</span><span> (Exception e)  </span>
</li>
<li><span>{  </span></li>
<li>
<span>throw</span><span> </span><span>new</span><span> Exception(e.Message);  </span>
</li>
<li><span>}  </span></li>
<li>
<span>finally</span><span> </span>
</li>
<li><span>{ closeConnection(); }  </span></li>
<li>
<span> }</span><span>//执行sql语句 C#操作Access实例解析</span><span> </span>
</li>
<li><span> </span></li>
<li>
<span> </span><span>public</span><span> </span><span>static</span><span> OleDbDataReader dataReader(</span><span>string</span><span> sqlstr)  </span>
</li>
<li><span> {  </span></li>
<li>
<span>OleDbDataReader dr = </span><span>null</span><span>;  </span>
</li>
<li>
<span>try</span><span> </span>
</li>
<li><span>{  </span></li>
<li><span>openConnection();  </span></li>
<li><span>comm.CommandText = sqlstr;  </span></li>
<li><span>comm.CommandType = CommandType.Text;  </span></li>
<li><span> </span></li>
<li><span>dr = comm.ExecuteReader(CommandBehavior.CloseConnection);  </span></li>
<li><span>}  </span></li>
<li>
<span>catch</span><span> </span>
</li>
<li><span>{  </span></li>
<li>
<span>try</span><span> </span>
</li>
<li><span>{  </span></li>
<li><span>dr.Close();  </span></li>
<li><span>closeConnection();  </span></li>
<li><span>}  </span></li>
<li>
<span>catch</span><span> { }  </span>
</li>
<li><span>}  </span></li>
<li>
<span>return</span><span> dr;  </span>
</li>
<li><span>}  </span></li>
<li>
<span>//返回指定sql语句的OleDbDataReader对象，使用时请注意关闭这个对象。 </span><span> </span>
</li>
<li>
<span> </span><span>public</span><span> </span><span>static</span><span> </span><span>void</span><span> dataReader(</span><span>string</span><span> sqlstr,  </span>
</li>
<li>
<span> </span><span>ref</span><span> OleDbDataReader dr)  </span>
</li>
<li><span> {  </span></li>
<li>
<span>try</span><span> </span>
</li>
<li><span>{  </span></li>
<li><span>openConnection();  </span></li>
<li><span>comm.CommandText = sqlstr;  </span></li>
<li><span>comm.CommandType = CommandType.Text;  </span></li>
<li><span>dr=comm.ExecuteReader(CommandBehavior.CloseConnection);  </span></li>
<li><span>}  </span></li>
<li>
<span>catch</span><span> </span>
</li>
<li><span>{  </span></li>
<li>
<span>try</span><span> </span>
</li>
<li><span>{  </span></li>
<li>
<span>if</span><span> (dr != </span><span>null</span><span> && !dr.IsClosed)  </span>
</li>
<li><span>   dr.Close();  </span></li>
<li><span>}  //C#操作Access实例解析</span></li>
<li>
<span>catch</span><span> </span>
</li>
<li><span>{  </span></li>
<li><span>}  </span></li>
<li>
<span>finally</span><span> </span>
</li>
<li><span>{  </span></li>
<li><span>closeConnection();  </span></li>
<li><span>}  </span></li>
<li><span>}  </span></li>
<li><span> }  </span></li>
<li>
<span>//返回指定sql语句的OleDbDataReader对象,使用时请注意关闭 </span><span> </span>
</li>
<li><span> </span></li>
<li>
<span> </span><span>public</span><span> </span><span>static</span><span> DataSet dataSet(</span><span>string</span><span> sqlstr)  </span>
</li>
<li><span> {  </span></li>
<li>
<span>DataSet ds = </span><span>new</span><span> DataSet();  </span>
</li>
<li>
<span>OleDbDataAdapter da = </span><span>new</span><span> OleDbDataAdapter();  </span>
</li>
<li>
<span>try</span><span> </span>
</li>
<li><span>{  </span></li>
<li><span>openConnection();  </span></li>
<li><span>comm.CommandType = CommandType.Text;  </span></li>
<li><span>comm.CommandText = sqlstr;  </span></li>
<li><span>da.SelectCommand = comm;  </span></li>
<li><span>da.Fill(ds);  </span></li>
<li><span> </span></li>
<li><span>}  </span></li>
<li>
<span>catch</span><span> (Exception e)  </span>
</li>
<li><span>{  </span></li>
<li>
<span>throw</span><span> </span><span>new</span><span> Exception(e.Message);  </span>
</li>
<li><span>}  </span></li>
<li>
<span>finally</span><span> </span>
</li>
<li><span>{  </span></li>
<li><span>closeConnection();  </span></li>
<li><span>}  </span></li>
<li>
<span>return</span><span> ds;  </span>
</li>
<li>
<span> }</span><span>//返回指定sql语句的dataset C#操作Access实例解析</span><span> </span>
</li>
<li><span> </span></li>
<li>
<span> </span><span>public</span><span> </span><span>static</span><span> </span><span>void</span><span> dataSet(  </span>
</li>
<li>
<span>string</span><span> sqlstr, </span><span>ref</span><span> DataSet ds)  </span>
</li>
<li><span> {  </span></li>
<li>
<span>OleDbDataAdapter da = </span><span>new</span><span> OleDbDataAdapter();  </span>
</li>
<li>
<span>try</span><span> </span>
</li>
<li><span>{  </span></li>
<li><span>openConnection();  </span></li>
<li><span>comm.CommandType = CommandType.Text;  </span></li>
<li><span>comm.CommandText = sqlstr;  </span></li>
<li><span>da.SelectCommand = comm;  </span></li>
<li><span>da.Fill(ds);  </span></li>
<li><span>}  </span></li>
<li>
<span>catch</span><span> (Exception e)  </span>
</li>
<li><span>{  </span></li>
<li>
<span>throw</span><span> </span><span>new</span><span> Exception(e.Message);  </span>
</li>
<li><span>}  </span></li>
<li>
<span>finally</span><span> </span>
</li>
<li><span>{  </span></li>
<li><span>closeConnection();  </span></li>
<li><span>}  </span></li>
<li>
<span> }</span><span>//返回指定sql语句的dataset C#操作Access实例解析</span>
</li>
<li><span> </span></li>
<li>
<span> </span><span>public</span><span> </span><span>static</span><span> DataTable dataTable(</span><span>string</span><span> sqlstr)  </span>
</li>
<li><span> {  </span></li>
<li>
<span>DataTable dt = </span><span>new</span><span> DataTable();  </span>
</li>
<li>
<span>OleDbDataAdapter da = </span><span>new</span><span> OleDbDataAdapter();  </span>
</li>
<li>
<span>try</span><span> </span>
</li>
<li><span>{  </span></li>
<li><span>openConnection();  </span></li>
<li><span>comm.CommandType = CommandType.Text;  </span></li>
<li><span>comm.CommandText = sqlstr;  </span></li>
<li><span>da.SelectCommand = comm;  </span></li>
<li><span>da.Fill(dt);  </span></li>
<li><span>}  </span></li>
<li>
<span>catch</span><span> (Exception e)  </span>
</li>
<li><span>{  </span></li>
<li>
<span>throw</span><span> </span><span>new</span><span> Exception(e.Message);  </span>
</li>
<li><span>}  </span></li>
<li>
<span>finally</span><span> </span>
</li>
<li><span>{  </span></li>
<li><span>closeConnection();  </span></li>
<li><span>}  </span></li>
<li>
<span>return</span><span> dt;  </span>
</li>
<li>
<span> }</span><span>//返回指定sql语句的datatable </span><span> </span>
</li>
<li>
<span> </span><span>public</span><span> </span><span>static</span><span> </span><span>void</span><span> dataTable(  </span>
</li>
<li>
<span>string</span><span> sqlstr, </span><span>ref</span><span> DataTable dt)  </span>
</li>
<li><span> {  </span></li>
<li>
<span>OleDbDataAdapter da = </span><span>new</span><span> OleDbDataAdapter();  </span>
</li>
<li>
<span>try</span><span> </span>
</li>
<li><span>{  </span></li>
<li><span>openConnection();  </span></li>
<li><span>comm.CommandType = CommandType.Text;  </span></li>
<li><span>comm.CommandText = sqlstr;  </span></li>
<li><span>da.SelectCommand = comm;  </span></li>
<li><span>da.Fill(dt);  </span></li>
<li><span>}  </span></li>
<li>
<span>catch</span><span> (Exception e)  </span>
</li>
<li><span>{  </span></li>
<li>
<span>throw</span><span> </span><span>new</span><span> Exception(e.Message);  </span>
</li>
<li><span>}  </span></li>
<li>
<span>finally</span><span> </span>
</li>
<li><span>{  </span></li>
<li><span>closeConnection();  </span></li>
<li><span>}  </span></li>
<li>
<span> }</span><span>//返回指定sql语句的datatable C#操作Access实例解析</span><span> </span>
</li>
<li><span> </span></li>
<li>
<span> </span><span>public</span><span> </span><span>static</span><span> DataView dataView(</span><span>string</span><span> sqlstr)  </span>
</li>
<li><span> {  </span></li>
<li>
<span>OleDbDataAdapter da = </span><span>new</span><span> OleDbDataAdapter();  </span>
</li>
<li>
<span>DataView dv = </span><span>new</span><span> DataView();  </span>
</li>
<li>
<span>DataSet ds = </span><span>new</span><span> DataSet();  </span>
</li>
<li>
<span>try</span><span> </span>
</li>
<li><span>{  </span></li>
<li><span>openConnection();  </span></li>
<li><span>comm.CommandType = CommandType.Text;  </span></li>
<li><span>comm.CommandText = sqlstr;  </span></li>
<li><span>da.SelectCommand = comm;  </span></li>
<li><span>da.Fill(ds);  </span></li>
<li><span>dv = ds.Tables[0].DefaultView;  </span></li>
<li><span>}  </span></li>
<li>
<span>catch</span><span> (Exception e)  </span>
</li>
<li><span>{  </span></li>
<li>
<span>throw</span><span> </span><span>new</span><span> Exception(e.Message);  </span>
</li>
<li><span>}  </span></li>
<li>
<span>finally</span><span> </span>
</li>
<li><span>{  </span></li>
<li><span>closeConnection();  </span></li>
<li><span>}  </span></li>
<li>
<span>return</span><span> dv;  </span>
</li>
<li><span> }  </span></li>
<li>
<span>//返回指定sql语句的dataview C#操作Access实例解析</span><span> </span>
</li>
<li><span> </span></li>
<li><span>} </span></li>
</ol>
Copy after login

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

Related labels：
access Example operate parse
source：php.cn
Previous article：WCF 4 Step By Step Chapter 1,2 Note Next article：控制访问列表（ACCESS LIST）
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
The child window operates the parent window, but the output does not respond. The first two sentences are executable, but the last sentence cannot be implemented.
From 2024-04-19 15:37:47
0
1
1361
What is the format of the variables in the return value? I am a new learner of php. I found a piece of code: if($x<time()){return[false,'error']...
From 2024-04-06 21:55:20
0
1
778
The page suddenly cannot pull css or bootstrap So I'm developing a page, I did part of it yesterday and it worked great, and today I cont...
From 2024-04-06 21:58:04
0
1
800
Sudoku checker not working? Can anyone help me identify the error? I tried everything on the online editor but still get the error. But when I do this on VSC...
From 2024-04-06 21:21:07
0
1
474
How to make floated elements stack vertically instead of horizontally in CSS? I'm trying to make a webpage with two columns, with main content on one side and additiona...
From 2024-04-06 20:45:26
0
2
386
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template