static void TestDAL()
{
using (Model1 en = new Model1())
{
Console.WriteLine("默认记录数量：{0}", en.Students.Count());
Student stu = new Student {
Name = "LY", Sex = "M", Age = 28, Pwd = "L38"
};
StuDbAccessor.Add(stu);
Console.WriteLine("添加了一条记录后记录数量：{0}", en.Students.Count());
StuDbAccessor.Delete(2);
Console.WriteLine("删除了一条记录后记录数量：{0}", en.Students.Count());
Student stuUpdate = new Student {
Name = "name1", Sex = "M", Age = 1, Pwd = "pwd1"
};
StuDbAccessor.Update(1, stuUpdate);
Console.WriteLine("更新了第一条记录，下面是更新后的属性");
Student updated1 = StuDbAccessor.SelectById(1);
Console.WriteLine(string.Format("{0}\t{1}\t{2}\t{3}",
updated1.Name, updated1.Pwd, updated1.Sex, updated1.Pwd));
}
}
private void btnUpdate_Click(object sender, EventArgs e)
{
Student selStudent = this.GetFirstSelectedStudent();
if (selStudent != null)
{
frmEdit editor = new frmEdit(selStudent);
int oldId = selStudent.ID;
if (editor.ShowDialog() == DialogResult.OK)
{
StuDbAccessor.Update(oldId, selStudent);
this.ViewAllStudent();
}
}
}