public void Process(string file) { const string conStr = @"server=localhost;user id=tns;persistsecurityinfo=True;database=adsurvey2;password=ad2016;"; //const string conStr = @"server=localhost;user id=root;persistsecurityinfo=True;database=adsurvey2;password=morningM00n;"; using (var con = new MySqlConnection(conStr)) { con.Open(); var tr = con.BeginTransaction(); var reader = new ExcelReader(new DbCommander(con), ExcelConfiguration.GetConfiguration()); try { reader.Read(file); tr.Commit(); } catch (Exception ex) { tr.Rollback(); _log.Write(ex.ToString()); } } }
public ExcelReader(DbCommander cmd, ExcelConfiguration config) { _cmd = cmd; _config = config; _step = 6; }