/* * 获取excel表格字段或者txt数据 */ private void obtainFieldButton_Click(object sender, EventArgs e) { if (this.txtFile.Text.Equals("") || this.txtFile.Text.Equals(String.Empty)) { return; } if (NameUnit.fileType.Equals("txt") || NameUnit.fileType.Equals("csv")) { finish = ImportFile.readFile(ref this.excelData, this.txtFile.Text, NameUnit.fileType, type = 1); } else { finish = ImportFile.readFile(ref this.excelData, this.txtFile.Text, NameUnit.fileType, type = 0); } //if (this.excelData.Rows.Count == 0) // return; //写入列表 this.excelFieldList.Items.Clear(); for (int i = 0; i < this.excelData.Columns.Count; i++) { this.excelFieldList.Items.Add(this.excelData.Columns[i].ColumnName); } }
void importData(int type) { int i = 0; if (!importDataTable()) { MessageBox.Show("数据库插入失败,请重试", "警告", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } if (!this.finish) { MessageBox.Show("导入数据成功", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } // Console.WriteLine("第" + ++i + "次导入"); while (this.finish) { this.finish = ImportFile.readFile(ref this.excelData, this.txtFile.Text, NameUnit.fileType, type); if (!importDataTable()) { MessageBox.Show("数据库插入失败,请重试", "警告", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } Console.WriteLine("第" + ++i + "次导入"); } if (!importDataTable()) { MessageBox.Show("数据库插入失败,请重试", "警告", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { MessageBox.Show("导入数据成功", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } }