ASP.NET MVC2.0 基礎教程 實現CRUD操作

這個示範項目實現了CRUD增刪查改操作。

開發環境：Visual Studio 2010 ＋ Linq To Sql ＋ SQL Server 2005

一、Demo示範

1、下載本示範Demo源碼：http://files.cnblogs.com/rubyloveromantic/MyMikeDemo.rar

2、Visual Studio 2010開啟本示範項目，運行即可。

二、從頭開始建立這個示範項目

1、附加下載的Demo源碼中的資料庫：mike108mvp.mdf 【ok】
2、建立一個MVC Preview應用程式，在Models目錄下，添加一個Linq To Sql檔案：Mike108mvp.dbml，將資料庫中的User表拖入LinqToSql設計視窗中。【ok】
3、web.config中添加命名空間：【ok】
4、在相關目錄建立視圖檔案【ok】

5、Controllers/Users/目錄下，建立一個UsersController.cs檔案，輸入增刪查改代碼。【ok】

 

usersControl

    public class UsersController : Controller
    {
        Mike108mvpDataContext db = new Mike108mvpDataContext();

#region  CRUD操作
public ActionResult List()
        {
            List<User> model = db.User.ToList();
return View(model);
        }

public ActionResult Create()
        {
return View();
        }

        [HttpPost]
public ActionResult Add()
        {
            User model = new User();
            model.UserId = 0;
            UpdateModel(model, Request.Form.AllKeys);
            db.User.InsertOnSubmit(model);
            db.SubmitChanges();

return RedirectToAction("List");
        }
public ActionResult Details(int userID)
        {
            User model = db.User.FirstOrDefault(e => e.UserId == userID);
return View(model);
        }
public ActionResult Edit(int userID)
        {
            User model = db.User.FirstOrDefault(e => e.UserId == userID);
return View(model);
        }

        [HttpPost]
public ActionResult Edit(int userID, string parm)
        {
if (parm == "更新")
            {
                User model = db.User.FirstOrDefault(e => e.UserId == userID);
                UpdateModel(model, Request.Form.AllKeys);
                db.SubmitChanges();
            }
return RedirectToAction("List");
        }
public ActionResult Delete(int userID)
        {

            User model = db.User.FirstOrDefault(e => e.UserId == userID);
            db.User.DeleteOnSubmit(model);
            db.SubmitChanges();

return RedirectToAction("List");
        }
#endregion

#region 資料重設

public ActionResult DataReset()
        {
//大量刪除
            List<User> oldList = db.User.ToList();
            db.User.DeleteAllOnSubmit(oldList);

//大量新增
            List<User> newlist = new List<User>
            {
new User { UserName = "孫中山", Age = 53, Career = "中國總統" },
new User { UserName = "蔣中正", Age = 36, Career = "中國總統" },
new User { UserName = "小布希", Age = 61, Career = "美國總統" },
new User { UserName = "列寧", Age = 49, Career = "邪惡蘇聯" },
new User { UserName = "史達林", Age = 49, Career = "邪惡蘇聯" },
new User { UserName = "比爾蓋茨", Age = 62, Career = "微軟老大" },
new User { UserName = "Scott Guthrie", Age = 33, Career = "ASP.NET Leader" }
            };
            db.User.InsertAllOnSubmit(newlist);
            db.SubmitChanges();
return RedirectToAction("List");
        }
#endregion
    }

註：該教程是在學習Mike In Jesus課程是對他的代碼作的升級(to MVC2.0)。 無侵權之意。