创建ASP.NET 应用程序
添加Model类库→添加→新建项→数据→DAO.NET实体数据模型
选择EF设计器
选择新建连接
找到相关数据库
选择以下按钮
勾选表
结果图
Model→引用→右键
复制路径
Model,添加引用,浏览,点击浏览,粘贴路径
将App.Config中代码剪切 复制
粘贴到Web.Config中
添加DAL,BLL类库,DAL引用Model,BLL引用Model,DAL,Web窗体引用BLL,Model
DAL中添加UserDAO类,代码如下
using Model;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
namespace DAL{
public class UserDAO
{
SchoolEntities db = new SchoolEntities();
public IEnumerable<student> Select()
{
var result = (from st in db.student
select st).ToList();
return result;
}
查询指定id的用户
public student Select(int id)
{
var user = (from u in db.student
where u.Id == id
select u).FirstOrDefault();
return user;
}
添加
public int Add(student user)
{
db.student.Add(user);
return db.SaveChanges();
}
//删除指定用户
public int Delete(int id){
var user=(from u in db.student
where u.Id==id
select u).FirstOrDefault();
db.student.Remove(user);
return db.SaveChanges();
//修改用户信息
public int Update(student user){
db.Entry<student>(user).State=System.Data.Entity.EntityState.Modified;
return db.SaveChanges();
}
}
}
在BLL中添加UserService类
using DAL;
using Model;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
namespace BLL
{
public class UserService
{
private UserDAO udao = new UserDAO();
public IEnumerable<student> Select()
{
return udao.Select();
}
//查询指定用户信息
public student Select(int id)
{
return udao.Select(id);
}
//添加用户信息
public int AddUser(student user)
{
return udao.Add(user);
}
//删除指定用户
public int Del(int id)
{
return udao.Delete(id);
}
//修改用户信息
public int Upd(student user)
{
return udao.Update(user);
}
//更新 编写构造函数
public int Update(int id,string Name,int Age,string Address,DateTime StudyDate {
Student student = new Student();
student.Id = id;
student.Name = Name;
student.Age = Age;
student.Address = Address;
student.StudyDate = StudyDate;
return Update(student);
}
}
}
在Web项目中添加两个窗体
web Form1.aspx
添加HyperLink,GridView控件
HtperLink控件中添加NavigateUrl="~/WebForm2.aspx",实现跳转第二个界面功能
<body>
<form id="form1" runat="server">
<div>
<asp:HyperLink ID="HyperLink1" runat="server" NavigateUrl="~/WebForm2.aspx">添加用户</asp:HyperLink>
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataSourceID="ObjectDataSource2" DataKeyNames="id">
<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="Address" HeaderText="Address" SortExpression="Address" />
<asp:BoundField DataField="studyDate" HeaderText="studyDate" SortExpression="studyDate" />
<asp:CommandField ShowDeleteButton="True" />
<asp:CommandField ShowEditButton="True" />
</Columns>
</asp:GridView>
<asp:ObjectDataSource ID="ObjectDataSource2" runat="server" SelectMethod="Select" TypeName="BALL.UserService"></asp:ObjectDataSource>
<asp:ObjectDataSource ID="ObjectDataSource1" runat="server" SelectMethod="Select" TypeName="BALL.UserService"></asp:ObjectDataSource>
<%--<asp:ObjectDataSource ID="ObjectDataSource1" runat="server" SelectMethod="Select" DeleteMethod="Del" TypeName="BALL.UserService">
//删除
<DeleteParameters>
<asp:Parameter Name="id" />
</DeleteParameters>
//编辑
<UpdateParameters>
<asp:Parameter Name="id" />
<asp:Parameter Name="Name" />
<asp:Parameter Name="Age" />
<asp:Parameter Name="Address" />
<asp:Parameter Name="studyDate" />
</UpdateParameters>
</asp:ObjectDataSource>--%>
</div>
</form>
</body>
点击设计,右边箭头,
设计,添加新列,选择相关命令按钮
WebForm1.aspx.cs代码
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
namespace WebApplication4{
public partial calss WebForm1:System.Web.UI.Page{
protected void Page_Load(object sender, EventArgs e){
string msg = Request.QueryString["msg"];
if(!string.IsNullOrEmpty(msg))
Response.Write("<script>alert('" + msg + "');</script>");
}
}
}
WebForm2.aspx,添加button按钮,并添加事件
OnClick=“Button1_Click”
<body>
<form id="form1" runat="server">
<div>
<asp:Label ID="Label1" runat="server" Text="姓名"></asp:Label>
<asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
<br />
<asp:Label ID="Label3" runat="server" Text="年龄"></asp:Label>
<asp:TextBox ID="TextBox3" runat="server"></asp:TextBox>
<br />
<asp:Label ID="Label4" runat="server" Text="住址"></asp:Label>
<asp:TextBox ID="TextBox4" runat="server"></asp:TextBox>
<br />
<asp:Label ID="Label5" runat="server" Text="日期"></asp:Label>
<asp:TextBox ID="TextBox5" runat="server"></asp:TextBox>
</div>
<asp:Button ID="Button1" runat="server" Text="确定" OnClick="Button1_Click" />
</form>
</body>
结果设计图
WebForm2.aspx.cs代码
Button事件代码
protected void Button1_Click(object sender, EventArgs e)
{
student user = new student();
user.Name = this.TextBox1.Text;
user.Age = this.TextBox3.Text;
user.Address = this.TextBox4.Text;
user.studyDate = this.TextBox5.Text;
UserService userService = new UserService();
int count = userService.AddUser(user);
if (count > 0)
{
Response.Write("<script>alert('添加成功!');window.location.href='WebForm1.aspx';</script>");
}
}