使用Entity Framework添加，查看详情傻瓜教学

 

 

1.创建数据库，创建数据表，并添加测试数据（按要求添加主外键）

2.在Visual Studio创建项目

3.添加Model数据模型

4.创建视图窗体

5.为下拉框绑定数据（从数据库）

protected void Page_Load(object sender, EventArgs e)
        {
            ChangeDBEntities db = new ChangeDBEntities();
            var result = (from a in db.Catelog select a).ToList();
            if (!IsPostBack)
            {
                this.DropDownList1.DataSource = result;
                this.DropDownList1.DataTextField = "Name";
                this.DropDownList1.DataValueField = "id";
                this.DropDownList1.DataBind();
            }
            
        } 

6.添加数据

protected void Button1_Click(object sender, EventArgs e)
        {
            //实例化数据库
            ChangeDBEntities db = new ChangeDBEntities();
            //为文本框传值，下拉框
            string title = this.TextBox1.Text;
            string name = this.TextBox2.Text;
            string content = this.TextBox3.Text;
            int type = int.Parse(this.DropDownList1.SelectedValue);
            DateTime time = DateTime.Now;
            Article a = new Article();
            //进行添加操作
            a.Title = title;
            a.Author = name;
            a.Content = content;
            a.Catelogid = type;
            a.PushTime = time;
            db.Article.Add(a);
            db.SaveChanges();
            Response.Write("<script>alert('添加成功')</script>");
        }

7.编辑好详情页面

用Label控件来装数据

8.判断是否要显示详情页面，重定向到详情页面

protected void Repeater1_ItemCommand(object source, RepeaterCommandEventArgs e)
        {
            if (e.CommandName == "xq")
            {
                int id = int.Parse(e.CommandArgument.ToString());
                Response.Redirect($"详情.aspx?id={id}");
            }
           
        }

public partial class 详情 : System.Web.UI.Page
    {
        ChangeDBEntities db = new ChangeDBEntities();
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                int id = int.Parse(Request["id"].ToString());
                //读取数据库表的对象
                var result = db.Article.FirstOrDefault(p => p.id==id );
                this.Label1.Text = result.id.ToString();
                this.Label2.Text = result.Title;
                this.Label3.Text = result.Author;
                this.Label4.Text = result.Content;
            }
            
        }
    }