c# mysql oledb_C# oledb 数据库操作类

public classoperateDB

{private static stringconStr;public staticOleDbConnection cnn;

OleDbDataAdapter da;

OleDbCommandBuilder cb;

OleDbCommand cmd;//构造函数

#region initialize

publicoperateDB()

{//

//TODO: 在此处添加构造函数逻辑// cnn=newOleDbConnection();

da=newOleDbDataAdapter();//不用OleDbCommand对象更新到数据库时，必须有下面一行

cb=newOleDbCommandBuilder(da);

cmd=newOleDbCommand();

}#endregion initialize

//连接字符串

#region get&setConnectionString

///

///获取连接字符串///

public stringMyConStr

{get {returnconStr;}set {conStr =value;}

}#endregion get&setConnectionString

//获得表的名称

#region acquireTableNames

///

///获取数据库中的表名集合///

///

publicDataTable tablesCollection()

{

DataTable tbl=newDataTable();try{

cnn.ConnectionString=conStr;

cnn.Open();

tbl=cnn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables,new object[] {null, null, null, "TABLE"});

}catch(Exception ce)

{

Console.WriteLine("产生错误:\n{0}",ce.Message);

}finally{

cnn.Close();

}returntbl;

}#endregion acquireTableNames

//填充数据

#region fillTable

///

///填充dataTable的查询///

/// 数据表(必须输入数据库中存在的名称,也可以是视图)

/// SQL语句

/// 记录条数

public int select(DataTable tblName,stringsqlStr)

{int i=0;//try//{//

tblName.Clear();

da.Dispose();if (cnn.ConnectionString=="")

cnn.ConnectionString=conStr;if (cnn.State!=ConnectionState.Open)

cnn.Open();//OleDbCommand cmd=new OleDbCommand("select * from "+tblName.TableName+" where "+sqlStr,cnn);

cmd.Connection=cnn;

cmd.CommandType=CommandType.Text;

cmd.CommandText="select * from"+tblName.TableName+"where"+sqlStr;

da.SelectCommand=cmd;

i=da.Fill(tblName);//

//

//}//catch(Exception ce)//{//Console.WriteLine("产生错误:\n{0}",ce.Message);//}//finally//{//this.da.Dispose();

cnn.Close();//}

returni;

}#endregion fillTable

//插入记录

#region insert(use CommandBuilder)

///

///插入记录(用OleDbCommandBuilder)///

/// 数据表

/// 与表中字段对应的新行

/// 影响的行数

public intinsert(DataTable tblName,DataRow