private void btnAdd_Click(object sender, EventArgs e) { if (txtName.Text == "" || txtExplain.Text == "") { MessageBox.Show("请输入内容"); } else { Dbcontrol dbHelper = new Dbcontrol(); if (rdoSingle.Checked) { string strEx = "insert into [sheet1$] (名称,解释) VALUES('" + txtName.Text.Trim() + "','" + txtExplain.Text.Trim() + "')"; MessageBox.Show(dbHelper.ReExNum(strEx) > 0 ? "添加成功!" : "添加失败!"); } else { string[] charSplit = { "\n" }; char entrySeparator = txtName.Text[0]; string[] entries = txtExplain.Text.Trim().Replace("\r", "").Split(charSplit, StringSplitOptions.None); int succeedCount = 0; foreach (var item in entries) { string[] data = item.Split(entrySeparator); if (data.Length < 2) { continue; } succeedCount += dbHelper.ReExNum(string.Format("insert into [sheet1$] (名称,解释) VALUES('{0}','{1}');", data[0], data[1])); } MessageBox.Show("成功添加了【" + succeedCount + "】条记录。", "成功提示"); } ClearForm(); } }