csharp操纵access数据库类
来源:互联网 发布:图像分割算法有哪些 编辑:程序博客网 时间:2024/05/16 06:27
static string conn = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\\tb_taizhan.mdb";
public static int ExcuteNonQuery(string strSqlComm_)
{
//Clear null
OleDbConnection m_OleDbConnection = new OleDbConnection(conn);
try
{
//Execute strSqlComm_
m_OleDbConnection.Open();
OleDbCommand m_OleDbCommand = new OleDbCommand(strSqlComm_, m_OleDbConnection);
return m_OleDbCommand.ExecuteNonQuery();
}
catch (Exception err_)
{
//Throw error
throw new Exception("执行SQL语句出错:\r\n" + strSqlComm_ + "\r\n" + err_.ToString());
return -1;
}
finally
{
m_OleDbConnection.Close();
}
}
public static object ExcuteScalar(string strSqlComm_)
{
//Clear null
OleDbConnection m_OleDbConnection = new OleDbConnection(conn);
try
{
//Execute strSqlComm_
m_OleDbConnection.Open();
OleDbCommand m_OleDbCommand = new OleDbCommand(strSqlComm_, m_OleDbConnection);
return m_OleDbCommand.ExecuteScalar();
}
catch (Exception err_)
{
//Throw error
throw new Exception("执行SQL语句出错:\r\n" + strSqlComm_ + "\r\n" + err_.ToString());
return null;
}
finally
{
m_OleDbConnection.Close();
}
}
public static DataSet GetDataSet(string strSqlComm_)
{
DataSet ds=new DataSet();
OleDbConnection m_OleDbConnection = new OleDbConnection(conn);
try
{
OleDbDataAdapter m_DataAdapter= new OleDbDataAdapter(strSqlComm_, m_OleDbConnection);
m_DataAdapter.Fill(ds);
return ds;
}
catch (Exception err_)
{
throw new Exception("执行SQL语句出错:\r\n" + strSqlComm_ + "\r\n" + err_.ToString());
}
}
public static int ExcuteNonQuery(string strSqlComm_)
{
//Clear null
OleDbConnection m_OleDbConnection = new OleDbConnection(conn);
try
{
//Execute strSqlComm_
m_OleDbConnection.Open();
OleDbCommand m_OleDbCommand = new OleDbCommand(strSqlComm_, m_OleDbConnection);
return m_OleDbCommand.ExecuteNonQuery();
}
catch (Exception err_)
{
//Throw error
throw new Exception("执行SQL语句出错:\r\n" + strSqlComm_ + "\r\n" + err_.ToString());
return -1;
}
finally
{
m_OleDbConnection.Close();
}
}
public static object ExcuteScalar(string strSqlComm_)
{
//Clear null
OleDbConnection m_OleDbConnection = new OleDbConnection(conn);
try
{
//Execute strSqlComm_
m_OleDbConnection.Open();
OleDbCommand m_OleDbCommand = new OleDbCommand(strSqlComm_, m_OleDbConnection);
return m_OleDbCommand.ExecuteScalar();
}
catch (Exception err_)
{
//Throw error
throw new Exception("执行SQL语句出错:\r\n" + strSqlComm_ + "\r\n" + err_.ToString());
return null;
}
finally
{
m_OleDbConnection.Close();
}
}
public static DataSet GetDataSet(string strSqlComm_)
{
DataSet ds=new DataSet();
OleDbConnection m_OleDbConnection = new OleDbConnection(conn);
try
{
OleDbDataAdapter m_DataAdapter= new OleDbDataAdapter(strSqlComm_, m_OleDbConnection);
m_DataAdapter.Fill(ds);
return ds;
}
catch (Exception err_)
{
throw new Exception("执行SQL语句出错:\r\n" + strSqlComm_ + "\r\n" + err_.ToString());
}
}
- csharp操纵access数据库类
- Csharp连接Access数据库
- 【MFC】ADO数据库操纵access
- 通过 ADO.NET 操纵 Access 数据库
- 在SQL中操纵读取ACCESS数据库
- 在SQL中操纵读取ACCESS数据库
- 数据库操纵经典类(C#)
- ADO操纵数据库封装类
- SqlHelper操纵数据库工具类
- jdbc操纵access文件
- 相关的连接与操纵数据库的编程方法之ADO连接access数据库
- 东软实训,一个使用的数据库操纵类
- csharp数据库安全
- CSharp Tips:使用OleDb操纵Excel文件(1)
- CSharp Tips:使用OleDb操纵Excel文件(1)
- access数据库操作类
- 连接ACCESS数据库类
- Access数据库操作类
- 组建一个最简单的局域网(两台计算机)
- 跟我一步一步组建局域网
- MFC按行读取txt数据并分割每行数据
- 可访问性级别
- csharp tcp/ip连接发送消息
- csharp操纵access数据库类
- Javascript跨域和Ajax跨域解决方案
- Linq 之 join on 查询
- ORACL instr 函數 substr函數
- CopyU! v2.0.377.207新版正式上线!
- 求逆序数之分治排序
- 小波变换网文精粹:小波变换教程(二十)
- 文档
- 单例模式 Singleton模式