您好,欢迎访问一九零五行业门户网

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 序号学号姓名性别年龄住址操作
@foreach (stutable info in (viewdata[data] as ienumerable)){ @info.id @info.stuid @info.stuname @info.stusex @info.stuage @info.stuaddress
}
@html.actionlink(添加个人信息,addinfo,home)

view code 5 视图 add.cshtml的代码
@model mvctestdata.models.stutable@{ viewbag.title = add;}@if(viewdata[result].equals(ok)){ 添加成功
}else{ 添加失败
}
view code 6 视图addinfo.cshtml代码
@model mvctestdata.models.stutable@{ viewbag.title = addinfo;}addinfo@using(html.beginform(add,home,formmethod.post)){ student 学号:@html.textboxfor(x=>x.stuid)
student 姓名:@html.textboxfor(x=>x.stuname)
student 性别:@html.textboxfor(x=>x.stusex)
student 年龄:@html.textboxfor(x=>x.stuage)
student 住址:@html.textboxfor(x=>x.stuaddress)
}
view code 7 视图delete.cshtml代码
@model mvctestdata.models.stutable@{ viewbag.title = delete;}@if (viewdata[result].equals(ok)){ 删除成功
}else{ 删除失败
}
view code 8 最终测试结果图:
其它类似信息

推荐信息