MyDBEntities db = new MyDBEntities();
//(实例化物理模型)
//(编写查询数据库语句)
var result = from Essay in db.Essay
join Types in db.Types on Essay.typeID equals Types.typeID
select new { id = Essay.id, author = Essay.author, content = Essay.content, times = Essay.times, title = Essay.title, typeID = Essay.typeID };
//(绑定数据源)
this.Repeater1.DataSource = result.ToList();
this.Repeater1.DataBind();
运行出现以下界面
在WebForm窗体添加HyperLink控件跳转到Add界面
绑定控件
MyDBEntities db = new MyDBEntities();
Essay essay = new Essay();
essay.author = this.TextBox1.Text;
essay.content = this.TextBox2.Text;
//(获取当前时间)
essay.times = DateTime.Now;
essay.title = this.TextBox4.Text;
//(绑定下拉框)
essay.typeID = int.Parse(DropDownList1.SelectedValue);
int id = int.Parse(DropDownList1.SelectedValue);
Response.Write("<script>alert('" + id + "')</script>");
db.Essay.Add(essay);
db.SaveChanges();
Response.Write("<script>alert('添加成功')</script>");