private void button2_Click(object sender, EventArgs e) { if (textBox1.Text == "") { MessageBox.Show("请选择文件!"); } else { DataSet dataset = new DataSet(); dataset = _excel.getDataSetFromExcel(textBox1.Text, _excel.GetFirstSheetName(textBox1.Text)); _dba.ExecuteCommand("delete remedy7"); _dba.InsertDataToDB(dataset, "remedy7"); MessageBox.Show("Successed!"); } }
private void button15_Click(object sender, EventArgs e) { string weekday = dateTimePicker1.Value.DayOfWeek.ToString(); if (weekday == "Monday") { ExcelBus excelbiz = new ExcelBus(); string sheetName = excelbiz.GetFirstSheetName(textBox3.Text); DataSet dsRemedy7 = excelbiz.getDataSetFromExcel(textBox3.Text, sheetName); _dba.ExecuteCommand("truncate table " + "CorpRemedy"); _dba.InsertDataToDB(dsRemedy7, "CorpRemedy"); MessageBox.Show("Insert CorpRemdy Successed!"); } else { MessageBox.Show("请选择正确日期!"); } }
private void button15_Click(object sender, EventArgs e) { string weekday = dateTimePicker1.Value.DayOfWeek.ToString(); if (weekday == "Monday") { ExcelBus excelbiz = new ExcelBus(); string sheetName = excelbiz.GetFirstSheetName(textBox3.Text); DataSet dsRemedy7 = excelbiz.getDataSetFromExcel(textBox3.Text, sheetName); _dba.ExecuteCommand("truncate table " + "CorpRemedy"); _dba.InsertDataToDB(dsRemedy7, "CorpRemedy"); MessageBox.Show("Insert CorpRemdy Successed!"); } else { MessageBox.Show("请选择正确日期!"); } }