mvc3.0 +linq 操作数据库中表的数据（ps:本人菜鸟刚学）

1：添加控制器类文件HomeController.cs其代码如下： using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.Mvc; using MvcTestData.Models; namespace MvcTestData.Controllers{ public class HomeContr

1：添加控制器类文件HomeController.cs其代码如下：

<span>using</span><span> System;</span><span>using</span><span> System.Collections.Generic;</span><span>using</span><span> System.Linq;</span><span>using</span><span> System.Web;</span><span>using</span><span> System.Web.Mvc;</span><span>using</span><span> MvcTestData.Models;</span><span>namespace</span><span> MvcTestData.Controllers{    </span><span>public</span> <span>class</span><span> HomeController : Controller    {        </span><span>//</span>        <span>//</span><span> GET: /Home/</span>        <span>public</span><span> ActionResult Index()        {            TestDataContext txtData </span>= <span>new</span><span> TestDataContext();            </span><span>var</span> result=<span>from</span> info <span>in</span><span> txtData.StuTable                       </span><span>select</span><span> info;            ViewData[</span><span>"</span><span>data</span><span>"</span>] =<span> result;            </span><span>return</span><span> View(result);        }        </span><span>public</span><span> ActionResult Add(FormCollection form)        {            </span><span>string</span> id =form[<span>"</span><span>StuId</span><span>"</span><span>];            </span><span>string</span> name=form[<span>"</span><span>StuName</span><span>"</span><span>];            </span><span>str<span>本文来源gaodai#ma#com搞*代#码9网#</span>ing</span> sex = form[<span>"</span><span>StuSex</span><span>"</span><span>];            </span><span>int</span> age = <span>int</span>.Parse(form[<span>"</span><span>StuAge</span><span>"</span><span>]);            </span><span>string</span> address = form[<span>"</span><span>StuAddress</span><span>"</span><span>];            StuTable stu </span>= <span>new</span><span> StuTable();            stu.StuId </span>=<span> id;            stu.StuName </span>=<span> name;            stu.StuSex </span>=<span> sex;            stu.StuAge </span>=<span> age;            stu.StuAddress </span>=<span> address;            </span><span>try</span><span>            {                </span><span>using</span> (<span>var</span> db = <span>new</span><span> TestDataContext())                {                    db.StuTable.InsertOnSubmit(stu);                    db.SubmitChanges();                    ViewData[</span><span>"</span><span>result</span><span>"</span>] = <span>"</span><span>ok</span><span>"</span><span>;                }            }            </span><span>catch</span><span>             {                ViewData[</span><span>"</span><span>result</span><span>"</span>] = <span>"</span><span>fail</span><span>"</span><span>;                </span><span>throw</span><span>;            }            </span><span>return</span> View(<span>"</span><span>Add</span><span>"</span><span>);        }        </span><span>public</span><span> ViewResult AddInfo()        {            </span><span>return</span> View(<span>"</span><span>AddInfo</span><span>"</span><span>);        }        </span><span>public</span><span> ViewResult Delete()        {            </span><span>int</span> id = Int16.Parse(Request.Form[<span>"</span><span>id</span><span>"</span><span>]);            </span><span>try</span><span>            {                </span><span>using</span> (<span>var</span> db = <span>new</span><span> TestDataContext())                {                    db.StuTable.DeleteOnSubmit(db.StuTable.First(info </span>=> info.ID ==<span> id));                    db.SubmitChanges();                    ViewData[</span><span>"</span><span>result</span><span>"</span>] = <span>"</span><span>ok</span><span>"</span><span>;                }            }            </span><span>catch</span><span>            {                ViewData[</span><span>"</span><span>result</span><span>"</span>] = <span>"</span><span>fail</span><span>"</span><span>;                </span><span>throw</span><span>;            }            </span><span>return</span> View(<span>"</span><span>Delete</span><span>"</span><span>);        }           }}</span>

View Code

喜欢 (0)赏

[搞代码]

分享 (0)