C#自己封装数据库操作类BaseADO

这几天学习数据库操作,就自己封装了一个数据库操作类,下面是代码展示

下面的例子是Access数据库

也可能用在Sql数据库中,只在在第一行代码上修改标识符即可

#define OLEDB_

using System;
using System.Data;
using System.Data.OleDb;
using System.Drawing;
using System.IO;
using System.Windows.Forms;
namespace MYDATACLASS
{
#if OLEDB_
    using MyCommand = OleDbCommand;
    using MyConnection = OleDbConnection;
    using MyDataAdapter = OleDbDataAdapter;
    using MyDataRead = OleDbDataReader;
    using MyParameter = OleDbParameter;

#elif SQL_
    using MyCommand = SqlCommand;
    using MyConnection = SqlConnection;
    using MyDataAdapter = SqlDataAdapter;
    using MyCommandBuilder = SqlCommandBuilder;
    using MyParameter = SqlParameter;
    using MyDataRead = SqlDataReader;

    //....