private void button1_Click(object sender, EventArgs e)
{
String filepath = MyTools.GetOpenExcelFilePath();
if (filepath == null)
{
return;
}
try
{
//读取表格并导入到数组中
MyTools.ReadExcel(filepath);
}
catch (Exception exception)
{
textBox1.Text += "\r\n读取出错:" + exception.Message;
// textBox1.Text +=
}
if (Form1.PersonList != null)
{
//清空人员数据库
MySqlitePersons.DeletePersonsTable();
//写入人员到数据库
MySqlitePersons.WritePersonsToSQL();
//显示到数据ListView
AddDataToListView();
}
textBox1.Text += "\r\n读取成功";
}
private void button3_Click(object sender, EventArgs e)
{
//清除所有人员功能，清空人员数据
listView1.Items.Clear();
Form1.PersonList = new List <List <String> >();
//删除数据库表
MySqlitePersons.DeletePersonsTable();
}