//public OleDbDataReader GetData(string tablename, string select_sql) //{ // MyDbHelper DbHelper = new MyDbHelper(MyDbHelper.connectstring_prec); // OleDbDataReader dr; // dr= DbHelper.ExecuteDataReader(select_sql); // return dr; //} private void CreateTable(string create_sql, string table_date) { try { MyDbHelper DbHelper = new MyDbHelper(MyDbHelper.connectstring_cardqs_bftb); int i = Convert.ToInt32(DbHelper.ExecuteScalar("select count(*) from user_tables where upper(table_name)=upper('" + table_date + "')")); if (i == 1) { DbHelper.ExecuteNonQuery("drop table " + table_date); } int ret = DbHelper.ExecuteNonQuery(create_sql); } catch (Exception ex) { MyLog.DbLog(table_date, "CreateTable 发生异常:" + ex.Message); MyLog.Log("3", "CreateTable 发生异常:" + ex.Message); } finally { if (DbHelper != null) { DbHelper.Dispose();//新加的 } } }
public void DropTable(string drop_sql, string pre_tablename) { try { MyDbHelper DbHelper = new MyDbHelper(MyDbHelper.connectstring_cardqs_bftb); int i = Convert.ToInt32(DbHelper.ExecuteScalar("select count(*) from user_tables where upper(table_name)=upper('" + pre_tablename + "')")); if (i == 1) { DbHelper.ExecuteNonQuery(drop_sql); } } catch (Exception ex) { MyLog.DbLog(pre_tablename, "DropTable 发生异常:" + ex.Message); MyLog.Log("3", "DropTable 发生异常:" + ex.Message); } finally { if (DbHelper != null) { DbHelper.Dispose();//新加的 } } }