public int Import2Oracle(ISheet sheet, string tablename)
{
  DataTable dt = GetDataFromExcelByNPOI(sheet); //經(jīng)過轉(zhuǎn)換后獲得DataTable
  OracleCommand cmd = conn.CreateCommand();// conn為數(shù)據(jù)庫連接對(duì)象
  OracleDataAdapter da = new OracleDataAdapter(cmd);
  OracleCommandBuilder ocb = new OracleCommandBuilder(da);
  string SelectSQL = "select * from "+tablename+ " where ROWNUM=0";
  da.SelectCommand.CommandText = SelectSQL;
  da.InsertCommand = ocb.GetInsertCommand();
  da.Update(dt);
  return 1; //返回正常
}

int Sum = 0; //總記錄數(shù)
int rowNum = 0; //插入記錄數(shù)
public int Import2Oracle(ISheet sheet)
{
  Sum = sheet.LastRowNum - 1; //獲取總記錄數(shù)
  DataTable dt = GetDataFromExcelByNPOI(sheet); //經(jīng)過轉(zhuǎn)換后獲得DataTable，利用到了NPOI
  OracleCommand cmd = conn.CreateCommand();// conn為數(shù)據(jù)庫連接對(duì)象
  OracleDataAdapter da = new OracleDataAdapter(cmd);
  OracleCommandBuilder ocb = new OracleCommandBuilder(da);
  string SelectSQL = "select * from GZGDZL."+tablename+ " where ROWNUM=0";
  da.SelectCommand.CommandText = SelectSQL;
  da.InsertCommand = ocb.GetInsertCommand();
  
  // update, this operation fires two events 
  // (RowUpdating/RowUpdated) per changed row 
  //這里只用到RowUpdated事件
  da.RowUpdated += new OracleRowUpdatedEventHandler(OnRowUpdated);
  
  da.Update(dt);
  return 1; //返回正常
}
//OnRowUpdated事件
 private void OnRowUpdated(object sender, OracleRowUpdatedEventArgs e)
{
  //刷新界面進(jìn)度條 
  rowNum = rowNum + 1;
  reportValue = (int)(rowNum /m_sheet.LastRowNum * 100);
  this.progressBar1.Value = percent; //progressBar控件已經(jīng)設(shè)置最大值為100，最小值為0
}