MVC3+Linq to sql 显示数据库中数据表的数据
Jun 07, 2016 pm 03:11 PM
sql
数据
数据库
数据表
显示
首先
1:首先创建asp.net mvc3应用程序 2:创建项目完成后 找到controllers文件鼠标右击选择添加控制器 3 为models文件夹添加一个linq to sql类文件,然后把数据库中的数据库复制进来。如截图操作 4:添加控制器好后会生成一个HomeController.cs类文件,其代码如
1:首先创建asp.net mvc3应用程序
2:创建项目完成后 找到controllers文件鼠标右击选择添加控制器
3 为models文件夹添加一个linq to sql类文件,然后把数据库中的数据库复制进来。如截图操作
4:添加控制器好后会生成一个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>
登录后复制
5 为HomeController.cs类文件中的Index()添加视图,其操作如下所示:
6 添加视图完成后,其视图前台代码如下:
<span>@using MvcTestData.Models </span><span><span>DOCTYPE html</span><span>></span> <span><span>html</span><span>></span> <span><span>head</span><span>></span> <span><span>title</span><span>></span>Index<span></span><span>title</span><span>></span> <span></span><span>head</span><span>></span> <span><span>body</span><span>></span> <span><span>div</span><span>></span> <span><span>table </span><span>border</span><span>="0"</span><span> cellspacing</span><span>="0"</span><span> cellpadding</span><span>="0"</span><span> width</span><span>="100%"</span><span> style</span><span>="text-align:center"</span> <span>></span> <span><span>tr</span><span>></span> <span><span>th</span><span>></span>序号<span></span><span>th</span><span>><span>th</span><span>></span>学号<span></span><span>th</span><span>><span>th</span><span>></span>姓名<span></span><span>th</span><span>><span>th</span><span>></span>性别<span></span><span>th</span><span>><span>th</span><span>></span>年龄<span></span><span>th</span><span>><span>th</span><span>></span>住址<span></span><span>th</span><span>></span> <span></span><span>tr</span><span>></span><span> @foreach (StuTable info in (ViewData["data"] as IEnumerable</span><span><span>StuTable</span><span>></span><span>)) { </span><span><span>tr</span><span>></span> <span><span>td</span><span>></span>@info.ID<span></span><span>td</span><span>></span> <span><span>td</span><span>></span>@info.StuId <span></span><span>td</span><span>></span> <span><span>td</span><span>></span>@info.StuName <span></span><span>td</span><span>></span> <span><span>td</span><span>></span>@info.StuSex <span></span><span>td</span><span>></span> <span><span>td</span><span>></span>@info.StuAge <span></span><span>td</span><span>></span> <span><span>td</span><span>></span>@info.StuAddress <span></span><span>td</span><span>></span> <span></span><span>tr</span><span>></span><span> } </span><span></span><span>table</span><span>></span> <span></span><span>div</span><span>></span> <span></span><span>body</span><span>></span> <span></span><span>html</span><span>></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span>
登录后复制
7 最终测试运行结果
本站声明
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系admin@php.cn

热门文章
仓库:如何复兴队友
3 周前
By 尊渡假赌尊渡假赌尊渡假赌
击败分裂小说需要多长时间?
3 周前
By DDD
R.E.P.O.能量晶体解释及其做什么(黄色晶体)
1 周前
By 尊渡假赌尊渡假赌尊渡假赌
Hello Kitty Island冒险:如何获得巨型种子
3 周前
By 尊渡假赌尊渡假赌尊渡假赌
公众号网页更新缓存难题:如何避免版本更新后旧缓存影响用户体验?
3 周前
By 王林

热门文章
仓库:如何复兴队友
3 周前
By 尊渡假赌尊渡假赌尊渡假赌
击败分裂小说需要多长时间?
3 周前
By DDD
R.E.P.O.能量晶体解释及其做什么(黄色晶体)
1 周前
By 尊渡假赌尊渡假赌尊渡假赌
Hello Kitty Island冒险:如何获得巨型种子
3 周前
By 尊渡假赌尊渡假赌尊渡假赌
公众号网页更新缓存难题:如何避免版本更新后旧缓存影响用户体验?
3 周前
By 王林

热门文章标签

记事本++7.3.1
好用且免费的代码编辑器

SublimeText3汉化版
中文版,非常好用

禅工作室 13.0.1
功能强大的PHP集成开发环境

Dreamweaver CS6
视觉化网页开发工具

SublimeText3 Mac版
神级代码编辑软件(SublimeText3)

美国空军高调展示首个AI战斗机!部长亲自试驾全程未干预,10万行代码试飞21次

单卡跑Llama 70B快过双卡,微软硬生生把FP6搞到了A100里 | 开源
