先建立数据库和web窗体之间的连接
然后在web窗体的加载事件中展示数据
视图代码
<div>
<asp:Repeater ID="Repeater1" runat="server">
<ItemTemplate>
<tr>
<td><%# Eval("title") %></td>
<td><%# Eval("author") %></td>
<td><%# Eval("context") %></td>
<td><%# Eval("cateName") %></td><br />
</tr>
</ItemTemplate>
</asp:Repeater><br />
<asp:Button ID="Button1" runat="server" Text="添加" OnClick="Button1_Click" />
</div>
cs后台代码
MyDBEntities1 db = new MyDBEntities1();
if (!IsPostBack)
{
var result = from a in db.Article
join c in db.Catelog on a.catelogid equals c.id
select new { title = a.title, author = a.author, context = a.content, cateName = c.name };
Repeater1.DataSource = result.ToList();
Repeater1.DataBind();
}
添加一个Button按钮在它的OnClick事件进行添加的代码编写
MyDBEntities1 db = new MyDBEntities1();
Article article = new Article();
article.title = "天天大笑";
article.author = "露丝";
article.content = "你笑点太低了";
article.Catelog = new Catelog() { name="生活",comment="吐槽"};
db.Article.Add(article);
db.SaveChanges();
if (db.SaveChanges()>=0)
{
Response.Write("<script>alert('添加成功!')</script>");
}