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其代码如下：

 using   System;
  using   System.Collections.Generic;
  using   System.Linq;
  using   System.Web;
  using   System.Web.Mvc;
  using   MvcTestData.Models;
  namespace   MvcTestData.Controllers
{
      public   class   HomeController : Controller
    {
          // 
         //   GET: /Home/ 

         public   ActionResult Index()
        {
            TestDataContext txtData  =  new   TestDataContext();
              var  result= from  info  in   txtData.StuTable
                         select   info;
            ViewData[  "  data  " ] =  result;
              return   View(result);
        }

          public   ActionResult Add(FormCollection form)
        {
              string  id =form[ "  StuId  "  ];
              string  name=form[ "  StuName  "  ];
              string  sex = form[ "  StuSex  "  ];
              int  age =  int .Parse(form[ "  StuAge  "  ]);
              string  address = form[ "  StuAddress  "  ];

            StuTable stu  =  new   StuTable();
            stu.StuId  =  id;
            stu.StuName  =  name;
            stu.StuSex  =  sex;
            stu.StuAge  =  age;
            stu.StuAddress  =  address;

              try  
            {
                  using  ( var  db =  new   TestDataContext())
                {
                    db.StuTable.InsertOnSubmit(stu);
                    db.SubmitChanges();
                    ViewData[  "  result  " ] =  "  ok  "  ;
                }
            }
              catch   
            {
                ViewData[  "  result  " ] =  "  fail  "  ;
                  throw  ;
            }
              return  View( "  Add  "  );
        }

          public   ViewResult AddInfo()
        {
              return  View( "  AddInfo  "  );
        }

          public   ViewResult Delete()
        {
              int  id = Int16.Parse(Request.Form[ "  id  "  ]);
              try  
            {
                  using  ( var  db =  new   TestDataContext())
                {
                    db.StuTable.DeleteOnSubmit(db.StuTable.First(info  => info.ID ==  id));
                    db.SubmitChanges();
                    ViewData[  "  result  " ] =  "  ok  "  ;
                }
            }
              catch  
            {
                ViewData[  "  result  " ] =  "  fail  "  ;
                  throw  ;
            }
              return  View( "  Delete  "  );
        }

       

    }
}  

View Code

2：为models文件夹添加linq to sql 类文件然后把数据库中的表copy 进来

3：为控制器中的Action添加各自的视图

4 视图Index.cshtml的代码

 @using MvcTestData.Models
  
 
 
     Index 
 
 
    

     "  0  "  cellspacing= "  0  "  cellpadding= "  0  "  width= "  100%  "  style= "  text-align:center  "  >
         
             序号  学号  姓名  性别  年龄  住址  操作 
          
@foreach (StuTable info   in  (ViewData[ "  data  " ]  as  IEnumerable  ))
{
     
         @info.ID 
         @info.StuId  
         @info.StuName  
         @info.StuSex  
         @info.StuAge  
         @info.StuAddress  
         
            
             
         
     
}
            
          
        @Html.ActionLink(  "  添加个人信息  " , "  AddInfo  " , "  Home  "  )

      
查看更多关于mvc3.0+linq操作数据库中表的数据（ps:本人菜鸟刚学）的详细内容...
        

          
声明：本文来自网络，不代表【好得很程序员自学网】立场，转载请注明出处：http://www.haodehen.cn/did159096