2024年4月11日发(作者：)
c# 数据库操作类
public class operateDB
{
private static string conStr;
public static OleDbConnection cnn;
OleDbDataAdapter da;
OleDbCommandBuilder cb;
OleDbCommand cmd;
//构造函数
#region initialize
public operateDB()
{
//
// TODO: 在此处添加构造函数逻辑
//
cnn=new OleDbConnection();
da=new OleDbDataAdapter();
//不用OleDbCommand对象更新到数据库时，必须有下面一行
cb=new OleDbCommandBuilder(da);
cmd=new OleDbCommand();
}
#endregion initialize
//连接字符串
#region get&setConnectionString
///
/// 获取连接字符串
///
public string MyConStr
{
get {return conStr;}
set {conStr = value;}
}
#endregion get&setConnectionString
//获得表的名称
#region acquireTableNames
///
/// 获取数据库中的表名集合
///
///
public DataTable tablesCollection()
{
DataTable tbl=new DataTable();
try
{
tionString=conStr;
();
tbl = DbSchemaTable(,
new object[] {null, null, null, "TABLE"});
}
catch(Exception ce)
{
ine("产生错误:n{0}",e);
}
finally
{
();
}
return tbl;
}
#endregion acquireTableNames
//填充数据
#region fillTable
///
/// 填充dataTable的查询
///
/// 数据表(必须输入数据库中存在的名称,也可以是视图)
m>
/// SQL语句
///
public int select(DataTable tblName,string sqlStr)
发布评论