简体中文(ZH-CN) English(EN) 繁体中文(ZH-TW) 日本語(JA) 한국어(KO) Melayu(MS) Français(FR) Deutsch(DE)
Home > Database > Mysql Tutorial > body text

C#操作Access实例解析

WBOY
Release： 2016-06-07 15:44:13
Original
1075 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
Best way to preload route data before accessing the route. Before rendering the page for a given route, I want to first get the necessary data synchr...
From 2023-11-17 14:54:42
0
2
379
Module is not defined in Vue project I just created a new Vue application by running npmini tvue@latest as specified in the off...
From 2023-11-17 12:38:53
0
2
394
How to pass key as select option value in v-for when changed (VueJS) I'm using Vue3 and Bootstrap5. I have a select with multiple options. Now I am displaying ...
From 2023-11-17 08:55:24
0
1
276
Catching Guzzle exceptions I'm trying to catch exceptions in a set of tests running on an API I'm developing, and I'm...
From 2023-11-16 14:36:03
0
12
290
Vue 3 dynamically imports based on Props I am using unplugin-icon to create an icon component, normally I can import e.g. //scripti...
From 2023-11-16 11:40:01
0
1
235
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
About us Disclaimer Sitemap
php.cn：Public welfare online PHP training，Help PHP learners grow quickly！