using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Text; using System.Windows.Forms; namespace EmployeeManager { public partial class Form1 : Form { public Form1() { InitializeComponent(); } private void Form1_Load(object sender, EventArgs e) { this.Text = "员工工资管理程序"; // TODO: 这行代码将数据加载到表“employeeDataset.pay”中。您可以根据需要移动或移除它。 this.payTableAdapter.Fill(this.employeeDataset.pay); // TODO: 这行代码将数据加载到表“employeeDataset.employee”中。您可以根据需要移动或移除它。 this.employeeTableAdapter.Fill(this.employeeDataset.employee); } //根据编号进行动态显示 private void textBox1_TextChanged(object sender, EventArgs e) { DataView dvResult = employeeDataset.pay.DefaultView; dvResult.Sort = "编号"; //设置过滤器 dvResult.RowFilter = "编号='" + textBox1.Text + "'"; //设置行状态过滤器 dvResult.RowStateFilter = DataViewRowState.CurrentRows; dataGridView1.DataSource = dvResult; } //保存按钮 private void toolStripButton1_Click(object sender, EventArgs e) { this.Validate(); //结束 this.employeebindingSource.EndEdit(); //更新表 this.employeeTableAdapter.Update(this.employeeDataset.employee); this.payTableAdapter.Update(this.employeeDataset.pay); MessageBox.Show("数据更新成功!", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } } }