private void btnSave_Click(object sender, EventArgs e) { string sSql = ""; ArrayList lstSql = new ArrayList(); DataTable dtChanges = m_configValue.Table.GetChanges(); if (dtChanges != null) { if (Program.frm1.PWDCheck("rg")) { foreach (DataRow row in dtChanges.Rows) { sSql = "update Config set ConfigValue=" + "'" + row["ConfigValue"].ToString() + "'" + " where [Description]=" + "'" + row["Description"].ToString() + "'"; lstSql.Add(sSql); } try { SQLHelper.ExecuteSql(lstSql); m_configValue.Table.AcceptChanges(); TableConfig.setFill(); MessageBox.Show("保存成功!"); ChangeState(); this.Close(); } catch { m_configValue.Table.RejectChanges(); MessageBox.Show("保存失败!"); } } else { MessageBox.Show("密码错误!"); } } else { MessageBox.Show("数据未改变!"); this.Close(); } }