private void btnInto_Click(object sender, EventArgs e)//导入控件的单击事件
{
OpenFileDialog openFile = new OpenFileDialog();
openFile.Filter = “所有文件(.)|.”;
if (openFile.ShowDialog() == DialogResult.OK)
{
FilePath = openFile.FileName;
}
else return;//如果没有选择或者其他 直接退出
//读取文件到List
try
{
objListTable = FileOperator.ReadFile(FilePath);
}
catch (Exception ex)
{
MessageBox.Show("读取文件失败,具体原因:" + ex.Message, "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
return;
}
//展示数据到dgv
dgvM_Table.DataSource = null;
dgvM_Table.AutoGenerateColumns = false;
dgvM_Table.DataSource = objListTable;
if (dgvM_Table.DataSource != null)
{
DialogResult dr = MessageBox.Show("数据添加成功,是否上传到数据库", "系统消息", MessageBoxButtons.YesNo);
if (dr == DialogResult.Yes)
{
try
{
int a = DAL.M_TanleService.M_TableInfoToSql(objListTable);
MessageBox.Show("成功上传到数据库" + a.ToString() + "条信息");
}
catch (Exception ex)
{
MessageBox.Show("数据上传到SQL有误具体原因:" + ex.Message, "系统消息", MessageBoxButtons.YesNo);
}
}
}
}