/// <summary> /// 获取数据库信息 /// </summary> private void BindInfo() { int pageIndex = Convert.ToInt32(page); linq = new linqtisqlClassesDataContext(conn);//实例化Linq连接对象 var result = (from info in linq.员工信息 select new { 员工编号 = info.员工编号, 员工姓名 = info.员工姓名, 性别 = info.性别, 年龄 = info.年龄, 电话 = info.电话, 地址 = info.地址, 邮箱 = info.邮箱 }).Skip(pageSize * pageIndex).Take(pageSize); dataGridView1.DataSource = result; button5.Enabled = button6.Enabled = true; if (page == 0) { button5.Enabled = false; } if (page == getCount() - 1) { button6.Enabled = false; } }
/// <summary> /// 显示数据库表内容 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e) { linq = new linqtisqlClassesDataContext(conn); //获取选择的员工编号 textBox1.Text = Convert.ToString(dataGridView1[0, e.RowIndex].Value).Trim(); //根据选择的员工编号获取其详细内容,并重新生成一个表 var result = from info in linq.员工信息 where info.员工编号 == textBox1.Text select new { 员工编号 = info.员工编号, 员工姓名 = info.员工姓名, 性别 = info.性别, 年龄 = info.年龄, 电话 = info.电话, 地址 = info.地址, 邮箱 = info.邮箱 }; //在相应的文本框和下拉框中显示员工信息 foreach (var item in result) { textBox1.Text = item.员工编号; textBox2.Text = item.员工姓名; comboBox1.Text = item.性别; textBox3.Text = item.年龄; textBox4.Text = item.电话; textBox5.Text = item.地址; textBox6.Text = item.邮箱; } }
/// <summary> /// 修改信息 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void button2_Click(object sender, EventArgs e) { if (textBox1.Text == "") { MessageBox.Show("请选择要修改的数据!"); return; } linq = new linqtisqlClassesDataContext(conn);//实例化Linq连接对象 //根据员工编号获取要修改的员工信息 var result = from employee in linq.员工信息 where employee.员工编号 == textBox1.Text select employee; //对指定的员工信息进行修改 foreach (员工信息 tbemployee in result) { tbemployee.员工编号 = textBox1.Text; tbemployee.员工姓名 = textBox2.Text; tbemployee.性别 = comboBox1.Text; tbemployee.年龄 = textBox3.Text; tbemployee.电话 = textBox4.Text; tbemployee.地址 = textBox5.Text; tbemployee.邮箱 = textBox6.Text; linq.SubmitChanges(); } MessageBox.Show("信息修改成功!"); BindInfo(); }
/// <summary> /// 添加数据库信息 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void button1_Click(object sender, EventArgs e) { linq = new linqtisqlClassesDataContext(conn); //实例化Linq连接对象 员工信息 employee = new 员工信息(); //实例化"员工信息"类对象 //为"员工信息"类中的员工实体进行赋值 employee.员工编号 = textBox1.Text; employee.员工姓名 = textBox2.Text; employee.性别 = comboBox1.Text; employee.年龄 = textBox3.Text; employee.电话 = textBox4.Text; employee.地址 = textBox5.Text; employee.邮箱 = textBox6.Text; linq.员工信息.InsertOnSubmit(employee); //添加员工信息 linq.SubmitChanges(); //提交操作 MessageBox.Show("信息添加成功"); BindInfo(); }
private void 除ToolStripMenuItem_Click(object sender, EventArgs e) { if (textBox1.Text == "") { MessageBox.Show("请选择要删除的信息!"); return; } linq = new linqtisqlClassesDataContext(conn);//实例化linq连接对象 //根据员工编号查询出要删除的员工信息 var result = from employee in linq.员工信息 where employee.员工编号 == textBox1.Text select employee; //删除选择的员工信息 linq.员工信息.DeleteAllOnSubmit(result); //提交操作 linq.SubmitChanges(); MessageBox.Show("信息删除成功!"); BindInfo(); }