C# AccessHelper 完整示例代码
来源:互联网 发布:淘宝论文的代写哪家好 编辑:程序博客网 时间:2024/05/21 22:44
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.OleDb;
using System.Data;
public class AccessHelper:IDisposable
{
private OleDbConnection m_conn = new OleDbConnection();
public static string DATABASE = AppDomain.CurrentDomain.BaseDirectory + "rate.accdb";
public AccessHelper()
{
string connstr = "Provider = Microsoft.ACE.OLEDB.12.0;";
connstr += "Data Source =\"" + DATABASE + "\"";
m_conn.ConnectionString = connstr;
m_conn.Open();
}
public void ExecuteCommand(string sql)
{
OleDbCommand cmd = null;
lock (cmd=new OleDbCommand())
{
cmd.Connection = m_conn;
cmd.CommandText = sql;
cmd.ExecuteNonQuery();
}
}
public void ExecuteCommand(string sql, OleDbParameter[] ps)
{
OleDbCommand cmd = null;
lock (cmd = new OleDbCommand())
{
cmd.Connection = m_conn;
cmd.CommandText = sql;
foreach (OleDbParameter p in ps)
{
cmd.Parameters.Add(p);
}
cmd.ExecuteNonQuery();
}
}
public DataTable GetSource(string strsql)
{
DataTable dt = null;
OleDbCommand cmd = null;
OleDbDataAdapter ad = null;
try
{
lock (dt = new DataTable())
{
cmd = new OleDbCommand(strsql, m_conn);
ad = new OleDbDataAdapter((OleDbCommand)cmd);
dt.Clear();
ad.Fill(dt);
}
}
catch (Exception e)
{
throw e;
}
return dt;
}
public object QuerySome(string sql)
{
OleDbCommand cmd = null;
lock (cmd = new OleDbCommand())
{
cmd.Connection = m_conn;
cmd.CommandText = sql;
using (OleDbDataReader or = cmd.ExecuteReader())
{
if (or.Read())
{
return or.GetValue(0);
}
}
}
return null;
}
public void ExecuteCommand(string sql)
{
OleDbCommand cmd = null;
lock (cmd=new OleDbCommand())
{
cmd.Connection = m_conn;
cmd.CommandText = sql;
cmd.ExecuteNonQuery();
}
}
void IDisposable.Dispose()
{
m_conn.Close();
m_conn.Dispose();
m_conn = null;
}
}
- C# AccessHelper 完整示例代码
- C# SqlServerHelper 代码完整示例
- C# AccessHelper
- 完整代码示例
- AccessHelper
- AccessHelper
- AccessHelper
- AccessHelper
- Ajax入门示例完整代码
- C#的Access数据库操作 AccessHelper类
- c#事件示例代码
- C#反射示例代码
- C#代码示例
- C#反射示例代码
- C#实现通用上传文件完整示例
- C# 完整上传文件 代码
- 一篇完整的doxygen示例代码
- Javax Mail发送邮件完整代码示例
- line
- 高斯滤波
- 会员卡管理系统技术解析(九)会员卡领卡记录查询
- 无废话WCF入门教程一[什么是WCF]
- ubuntu 编译SDK报appt 问题,32
- C# AccessHelper 完整示例代码
- 发现一个非常好的ping工具
- 2015百度之星初赛(1)problem1002
- c++ try_catch throw
- Jsp+Servlet+JavaBean简单mvc实例
- 树莓派控制GPIO
- 数字交换
- maven常用插件: 打包源码 / 跳过测试 / 单独打包依赖项
- LeetCode ---Merge k Sorted Lists