第一、先创建一个名为Store数据库，将下面脚本代码执行创建表；

USE [Store]

GO

/****** Object:  Table [dbo].[Category]    Script Date: 03/25/2014 09:39:23 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[Category](

    [CategoryID] [int] IDENTITY(1,1) NOT NULL,

    [Name] [nvarchar](50) NULL,

 CONSTRAINT [PK_Category] PRIMARY KEY CLUSTERED

(

    [CategoryID] ASC

)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]

) ON [PRIMARY]

GO

/****** Object:  Table [dbo].[Product]    Script Date: 03/25/2014 09:39:31 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[Product](

    [ID] [int] IDENTITY(1,1) NOT NULL,

    [Name] [nvarchar](50) NULL,

    [CategoryID] [int] NULL,

    [UnitPrice] [decimal](18, 2) NULL,

    [UnitsInStock] [int] NULL,

 CONSTRAINT [PK_Product] PRIMARY KEY CLUSTERED

(

    [ID] ASC

)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]

) ON [PRIMARY]

GO

第二、控制器ProductController
//

        // GET: /Product/

        public ActionResult Index()

        {

            var products = db.Products;

            return View(products.ToList());

        }

        /// <summary>

        // GET: /Products/Details/5

        /// </summary>

        /// <param name="id"></param>

        /// <returns></returns>

        public ActionResult Details(int id = )

        {

            var product = db.Products.First(p => p.ID == id);

            if (product == null)

                return HttpNotFound();

            return View(product);

        }

        //

        // GET: /Products/Create

        public ActionResult Create()

        {

            ViewBag.CategoryID = new SelectList(db.Categories, "CategoryID", "Name");

            return View();

        }

        //

        // POST: /Products/Create

        [HttpPost]

        public ActionResult Create(Product product)

        {

            if (ModelState.IsValid)

            {

                db.AddToProducts(product);

                db.SaveChanges();

                return RedirectToAction("Index");

            }

            ViewBag.CategoryID = new SelectList(db.Categories, "CategoryID", "Name", product.CategoryID);

            return View(product);

        }

        //

        //GET: /Products/Edit/5

        public ActionResult Edit(int id = )

        {

            Product entity = db.Products.First(p => p.ID == id);

            if (entity == null)

                return HttpNotFound();

            ViewBag.CategoryID = new SelectList(db.Categories.ToList(), "CategoryID", "Name", entity.CategoryID);

            return View(entity);

        }

        //

        //POST: /Products/Edit/5

        [HttpPost]

        public ActionResult Edit(Product product)

        {

            if (ModelState.IsValid)

            {

                db.CreateObjectSet<Product>().Attach(product);

                db.ObjectStateManager.ChangeObjectState(product, EntityState.Modified);

                db.SaveChanges();

                return RedirectToAction("Index");

            }

            ViewBag.CategoryID = new SelectList(db.Categories.ToList(), "CategoryID", "Name", product.CategoryID);

            return View(product);

        }

        //

        // GET: /Products/Delete/5

        public ActionResult Delete(int id = )

        {

            Product product = db.Products.First(p => p.ID == id);

            if (product == null)

            {

                return HttpNotFound();

            }

            return View(product);

        }

        //

        // POST: /Products/Delete/5

        [HttpPost, ActionName("Delete")]

        public ActionResult DeleteConfirmed(int id)

        {

            Product product = db.Products.First(p => p.ID == id);

            db.CreateObjectSet<Product>().Attach(product);

            db.ObjectStateManager.ChangeObjectState(product, EntityState.Deleted);

            db.SaveChanges();

            return RedirectToAction("Index");

        }

第3、视图
视图结构：
下面是视图代码：
Index：
@model IEnumerable<TMVC.DAL.Product>

@{

    ViewBag.Title = "Index";

}

<h2>

    产品页面</h2>

<p>@Html.ActionLink("添加", "Create")</p>

<table>

    <tr>

        @*<th>@Html.DisplayNameFor(model => model.Name)

        </th>

        <th>@Html.DisplayNameFor(model => model.CategoryID)

        </th>

        <th>@Html.DisplayNameFor(model => model.UnitPrice)

        </th>

        <th>@Html.DisplayNameFor(model => model.UnitsInStock)

        </th>*@

        <th>

            名称

        </th>

        <th>

            类别

        </th>

        <th>

            价格

        </th>

        <th>

            库存

        </th>

        <th>

            编辑

        </th>

    </tr>

    @foreach (var item in Model)

    {

        <tr>

            <td>@Html.DisplayFor(mi => item.Name)

            </td>

            <td>@Html.DisplayFor(mi => item.CategoryID)

            </td>

            <td>@Html.DisplayFor(mi => item.UnitPrice)

            </td>

            <td>@Html.DisplayFor(mi => item.UnitsInStock)

            </td>

            <td>@Html.ActionLink("编辑", "Edit", new { id = item.ID }) |

                @Html.ActionLink("详细", "Details", new { id = item.ID }) | @Html.ActionLink("删除", "Delete", new { id = item.ID })

            </td>

        </tr>

    }

</table>


Create：




@model TMVC.DAL.Product

@{

    ViewBag.Title = "Create";

}

<h2>

    添加</h2>

@using (Html.BeginForm())

{

    @Html.ValidationSummary(true);

    <fieldset>

        <legend>产品</legend>

        <div class="editor-label">

            名称 @* @Html.LabelFor(model => model.Name)*@

        </div>

        <div class="editor-field">

            @Html.EditorFor(model => model.Name)

            @Html.ValidationMessageFor(model => model.Name)

        </div>

        <div class="editor-label">

            类别 @* @Html.LabelFor(model => model.CategoryID, "CategoryPCategor")*@

        </div>

        <div class="editor-field">

            @*@Html.DropDownList("CategoryID", String.Empty)*@

            @Html.EditorFor(model => model.CategoryID)

            @Html.ValidationMessageFor(model => model.CategoryID)

        </div>

        <div class="editor-label">

            价格 @*@Html.LabelFor(model => model.UnitPrice)*@

        </div>

        <div class="editor-field">

            @Html.EditorFor(model => model.UnitPrice)

            @Html.ValidationMessageFor(model => model.UnitPrice)

        </div>

        <div class="editor-label">

            库存@* @Html.LabelFor(model => model.UnitsInStock)*@

        </div>

        <div class="editor-field">

            @Html.EditorFor(model => model.UnitsInStock)

            @Html.ValidationMessageFor(model => model.UnitsInStock)

        </div>

        <p>

            <input type="submit" value="确定添加" />

        </p>

    </fieldset>

}




Delete：




@model TMVC.DAL.Product

@{

    ViewBag.Title = "Delete";

}

<h2>

    删除</h2>

<h3>

    你确定要删除这个产品吗？</h3>

<fieldset>

    <legend>产品</legend>

    <div class="display-label">

        名称

    </div>

    <div class="display-field">

        @Html.DisplayFor(model => model.Name)

    </div>

    <div class="display-label">

        类别

    </div>

    <div class="display-field">

        @Html.DisplayFor(model => model.Name)

    </div>

    <div class="display-label">

        价格

    </div>

    <div class="display-field">

        @Html.DisplayFor(model => model.UnitPrice)

    </div>

    <div class="display-label">

        库存

    </div>

    <div class="display-field">

        @Html.DisplayFor(model => model.UnitsInStock)

    </div>

</fieldset>

@using (Html.BeginForm())

{

    <p>

        <input type="submit" value="删除" />

        |

        @Html.ActionLink("返回产品列表", "Index")

    </p>

}




Details：




@model TMVC.DAL.Product

@{

    ViewBag.Title = "Details";

}

<h2>

    详细</h2>

<fieldset>

    <legend>产品</legend>

    <p>

        名称：@Html.DisplayFor(model => model.Name)</p>

    <p>

        类别：@Html.DisplayFor(model => model.CategoryID)</p>

    <p>

        价格：@Html.DisplayFor(model => model.UnitPrice)</p>

    <p>

        库存：@Html.DisplayFor(model => model.UnitsInStock)</p>

</fieldset>

<p>@Html.ActionLink("编辑", "Edit", new { id = Model.ID }) | @Html.ActionLink("返回", "Index")</p>




Edit:




@model TMVC.DAL.Product

@{

    ViewBag.Title = "Edit";

}

<h2>

    编辑</h2>

@using (Html.BeginForm())

{

    @Html.ValidationSummary(true)

    <fieldset>

        <legend>产品</legend>

        @Html.HiddenFor(model => model.ID)

        <div class="editor-label">

            名称

        </div>

        <div class="editor-field">

            @Html.EditorFor(model => model.Name)

            @Html.ValidationMessageFor(model => model.Name)

        </div>

        <div class="editor-label">

            类别

        </div>

        <div class="editor-field">

            @*@Html.DropDownList("CategoryID", String.Empty)*@

            @Html.EditorFor(model => model.CategoryID)

            @Html.ValidationMessageFor(model => model.CategoryID)

        </div>

        <div class="editor-label">

            价格

        </div>

        <div class="editor-field">

            @Html.EditorFor(model => model.UnitPrice)

            @Html.ValidationMessageFor(model => model.UnitPrice)

        </div>

        <div class="editor-label">

            库存

        </div>

        <div class="editor-field">

            @Html.EditorFor(model => model.UnitsInStock)

            @Html.ValidationMessageFor(model => model.UnitsInStock)

        </div>

        <p>

            <input type="submit" value="保存" />

        </p>

    </fieldset>

}

<div>

    @Html.ActionLink("返回产品列表", "Index")

</div>




RouteConfig




            routes.MapRoute(

                name: "Default",

                url: "{controller}/{action}/{id}",

                defaults: new { controller = "Home", action = "Index", id = UrlParameter.Optional }

            );






 






 


												


																

最新文章
	

    
						
  1. jqGrid属性中文详细说明 (转)
		
    2. 
						
  2. Mac Pro  安装 最新版的 SVN 1.9.4
		
    3. 
						
  3. Html-Css-iframe的自适应高度方案
		
    4. 
						
  4. ssh 设置免password登录
		
    5. 
						
  5. thinkphp学习笔记10—看不懂的路由规则
		
    6. 
						
  6. webpack入门+react环境配置
		
    7. 
						
  7. Linux(ubuntu)安装MediaWiki
		
    8. 
						
  8. Problem B: 大整数的加法运算   升级版
		
    9. 
						
  9. 【Luogu1471】方差（线段树）
		
    10. 
						
  10. 索引法则--LIKE以%开头会导致索引失效进而转向全表扫描（使用覆盖索引解决）
		
    11. 
						
  11. Form表单 JSON Content-type解析
		
    12. 
						
  12. 关于 insufficient memory case 4 的解决记录
		
    13. 
						
  13. 第一章 Python基本语法元素分析（二）
		
    14. 
						
  14. Java 8 新特性:1-函数式接口
		
    15. 
						
  15. 【转】HTTP
		
    16. 
						
  16. 使用jquery load遇到一个问题解决
		
    17. 
						
  17. SparseArray
		
    18. 
						
  18. &lt;转&gt;特征工程（一）
		
    19. 
						
  19. bootstrapValidator  remote  的接受 验证 值
		
    20. 
						
  20. 简话Angular 06 Angular自定义指令
		
    21. 
		

	


热门文章
	

    
									
  1. IPA文件的自动化生成和无线分发
			
    2. 
						
  2. easyui datagrid fit 属性
			
    3. 
						
  3. JS 浏览器对象
			
    4. 
						
  4. linux学习之用户的切换
			
    5. 
						
  5. CTF 介绍及杂项
			
    6. 
						
  6. MongoDB 数据自动同步到 ElasticSearch
			
    7. 
						
  7. vue $emit 父组件与子组件之间的通信（父组件向子组件传参）
			
    8. 
						
  8. 利用Android Studio编写 Android上的c与c++程序
			
    9. 
						
  9. JS实现表格列宽拖动
			
    10. 
						
  10. Github概念理解备忘录
			
    11.