EF增删改查
用EF实现的增删改查,首先是数据库连接首页效果图(以学生列表为例):
![](https://img-blog.csdn.net/20180911143502776?watermark/2/text/aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0d1b2JlaWJlaV8xMjM=/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70)
查询:用Repeater创建数据源(图)
![](https://img-blog.csdn.net/20180911143847127?watermark/2/text/aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0d1b2JlaWJlaV8xMjM=/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70)
HTML的前端页面代码
<div>
<table style="width: 800px; margin: auto;">
<tr>
<td>学生列表</td>
</tr>
<tr style="background-color: darkturquoise;">
<td>编号</td>
<td>姓名</td>
<td>年龄</td>
<td>手机</td>
<td>邮箱</td>
<td>班级</td>
<td style="width:100px;">操作</td>
</tr>
<asp:Repeater ID="repert_EFDemo" runat="server" OnItemCommand="repert_EFDemo_ItemCommand">
<ItemTemplate>
<tr>
<td><%# Eval("stuid")%></td>
<td><%# Eval("stuname")%></td>
<td><%# Eval("stuage")%></td>
<td><%# Eval("phone")%></td>
<td><%# Eval("email")%></td>
<td><%# Eval("classname")%></td>
<td>
<a href='Update.aspx?id=<%# Eval("stuid") %>'>修改</a>
<a href="javascript:;" onclick='delStudent(<%# Eval("stuid") %>)'>删除</a>
<asp:LinkButton ID="link_denete" runat="server" CommandName="del" CommandArgument='<%# Eval("stuid")%>' OnClientClick="return confirm('你确定要删除吗?')">删除</asp:LinkButton></td>
</tr>
</ItemTemplate>
</asp:Repeater>
<tr>
<td>
<asp:Button ID="bnt_add" runat="server" Width="100px" Height="30px" Text="添加" BackColor="#00CC00" OnClick="bnt_add_Click" /></td>
</tr>
</table>
</div>
查询与repeat的修改删除的后台代码:
public partial class Index : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostB