增
添加新增控件
<asp:HyperLink ID="HyperLink1" NavigateUrl="~/WebForm2.aspx" runat="server">添加用户</asp:HyperLink>
在新建窗体中输入需要添加时的样式
<div>
ID:
<asp:TextBox ID="Text_Id" runat="server"></asp:TextBox>
<br />
姓名:
<asp:TextBox ID="Text_Name" runat="server"></asp:TextBox>
<br />
年龄:
<asp:TextBox ID="Text_Age" runat="server"></asp:TextBox>
<br />
家庭住址:
<asp:TextBox ID="Text_Home" runat="server"></asp:TextBox>
<br />
入学时间:
<asp:TextBox ID="Text_Time" runat="server"></asp:TextBox>
<br />
</div>
输入添加按钮并添加点击事件
<asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="添加" />
</div>
在按钮点击事件里输入
protected void Button1_Click(object sender, EventArgs e)
{
Student student = new Student();
添加用户ID
student.Id = int.Parse(this.Text_Id.Text);
添加用户姓名
student.Name = this.Text_Name.Text;
添加用户年龄
student.Age = int.Parse(this.Text_Age.Text);
添加用户入学时间
student.Addres = this.Text_Home.Text;
student.StudyDate = DateTime.Parse(this.Text_Time.Text);
StudentService stuvice = new StudentService();
int count = stuvice.AddStudent(student);
添加成功后的显示和跳转网页
if (count > 0)
{
Response.Write("<script>alert('添加成功!');window.location.href='WebForm1.aspx'</script>");
}
}
在数据访问层键入
public int Add(Student student)
{
db.Student.Add(student);
return db.SaveChanges();
}
在业务逻辑层处键入
public int AddStudent(Student student)
{
return udao.Add(student);
}
删
添加删除控件
<asp:CommandField HeaderText="删除" ShowDeleteButton="True" ShowHeader="True" />
在数据访问层键入
public int Delete(int id)
{
var student= (from u in db.Student
where u.id == id
select u).FirstOrDefault();
db.Student.Remove(student);
return db.SaveChanges();
}
在业务逻辑层处键入
public int Del(int id)
{
return udao.Delete(id);
}
改
添加更改控件
<asp:CommandField HeaderText="编辑" ShowEditButton="True" ShowHeader="True" />
在数据访问层键入
public int Update(Student student)
{
db.Entry<Student>(student).State = System.Data.Entity.EntityState.Modified;
return db.SaveChanges();
}
在业务逻辑层处键入
public int Update(Student student)
{
return udao.Update(student);
}
查
<div>
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataSourceID="ObjectDataSource1">
查询样式
<Columns>
<asp:BoundField DataField="id" HeaderText="id" SortExpression="id" />
<asp:BoundField DataField="name" HeaderText="name" SortExpression="name" />
<asp:BoundField DataField="age" HeaderText="age" SortExpression="age" />
<asp:BoundField DataField="addres" HeaderText="addres" SortExpression="addres" />
<asp:BoundField DataField="studyDate" HeaderText="studyDate" SortExpression="studyDate" />
</Columns>
绑定数据查询
</asp:GridView>
<asp:ObjectDataSource ID="ObjectDataSource1" runat="server" SelectMethod="Select" TypeName="BLL.StudentService">
<DeleteParameters>
<asp:Parameter Name="Id" />
</DeleteParameters>
<UpDateParameters>
<asp:Parameter Name="Id" />
<asp:Parameter Name="Name" />
<asp:Parameter Name="Age" />
<asp:Parameter Name="Addres" />
<asp:Parameter Name="StudyDate" />
</UpDateParameters>
</asp:ObjectDataSource>
</div>
在数据访问层键入
public Student Select(int id)
{
var student = (from u in db.Student
where u.id == id
select u).FirstOrDefault();
return student;
}
在业务逻辑层处键入
public Student Select(int id)
{
return udao.Select(id);
}