mvc3.0 +linq 操作数据库中表的数据（ps:本人菜鸟刚学）-mysql教程-PHP中文网

首页

数据库

mysql教程

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

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB

Jun 07, 2016 pm 03:11 PM

操作数据数据库

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

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

<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>string</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

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

mvc3.0 +linq 操作数据库中表的数据（ps:本人菜鸟刚学）
3：为控制器中的Action添加各自的视图

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

4 视图Index.cshtml的代码

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

<span>@using MvcTestData.Models
</span>


    <title>Index</title>


    <div>
    <table border="<span">"<span>0</span><span>"</span> cellspacing=<span>"</span><span>0</span><span>"</span> cellpadding=<span>"</span><span>0</span><span>"</span> width=<span>"</span><span>100%</span><span>"</span> style=<span>"</span><span>text-align:center</span><span>"</span> >
        <tr>
            <th>序号</th>
<th>学号</th>
<th>姓名</th>
<th>性别</th>
<th>年龄</th>
<th>住址</th>
<th>操作</th>
        </tr>
<span>
@foreach (StuTable info </span><span>in</span> (ViewData[<span>"</span><span>data</span><span>"</span>] <span>as</span> IEnumerable<stutable><span>))
{
   </span><tr>
        <td>@info.ID</td>
        <td>@info.StuId </td>
        <td>@info.StuName </td>
        <td>@info.StuSex </td>
        <td>@info.StuAge </td>
        <td>@info.StuAddress </td>
        <td>
            <form action="<span">"<span>/Home/Delete</span><span>"</span> method=<span>"</span><span>post</span><span>"</span>>
                <input type="<span">"<span>hidden</span><span>"</span> name=<span>"</span><span>id</span><span>"</span> value=<span>"</span><span>@info.ID</span><span>"</span>/>
                <input type="<span">"<span>submit</span><span>"</span> value=<span>"</span><span>删除</span><span>"</span>/>
              
            </form>
             
        </td>
   </tr>
<span>
}
          </span></stutable>
</table>
        <br><span>
        @Html.ActionLink(</span><span>"</span><span>添加个人信息</span><span>"</span>,<span>"</span><span>AddInfo</span><span>"</span>,<span>"</span><span>Home</span><span>"</span><span>)
    </span>
</div>

View Code

5 视图 Add.cshtml的代码

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

<span>@model MvcTestData.Models.StuTable

@{
    ViewBag.Title </span>= <span>"</span><span>Add</span><span>"</span><span>;
}
@if(ViewData[</span><span>"</span><span>result</span><span>"</span>].Equals(<span>"</span><span>ok</span><span>"</span><span>))
{
    </span><p>添加成功</p><span>
}
</span><span>else</span><span>
{
    </span><p>添加失败</p><span>
}</span>

View Code

6 视图AddInfo.cshtml代码

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

<span>@model MvcTestData.Models.StuTable

@{
    ViewBag.Title </span>= <span>"</span><span>AddInfo</span><span>"</span><span>;
}

</span><h2 id="AddInfo">AddInfo</h2>
<span>
@using(Html.BeginForm(</span><span>"</span><span>Add</span><span>"</span>,<span>"</span><span>Home</span><span>"</span><span>,FormMethod.Post))
{
    </span><p>Student 学号：@Html.TextBoxFor(x=>x.StuId)</p>
    <p>Student 姓名：@Html.TextBoxFor(x=>x.StuName)</p>
    <p>Student 性别：@Html.TextBoxFor(x=>x.StuSex)</p>
    <p>Student 年龄：@Html.TextBoxFor(x=>x.StuAge)</p>
    <p>Student 住址：@Html.TextBoxFor(x=>x.StuAddress)</p>
    <input type="<span">"<span>submit</span><span>"</span> value=<span>"</span><span>Add</span><span>"</span> /><span>
}

 </span>

View Code

7 视图Delete.cshtml代码

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

<span>@model MvcTestData.Models.StuTable

@{
    ViewBag.Title </span>= <span>"</span><span>Delete</span><span>"</span><span>;
}

@if (ViewData[</span><span>"</span><span>result</span><span>"</span>].Equals(<span>"</span><span>ok</span><span>"</span><span>))
{
    </span><p>删除成功</p><span>
}
</span><span>else</span><span>
{
   </span><p>删除失败</p><span>
}</span>

View Code

8 最终测试结果图：

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

声明

本文内容由网友自发贡献，版权归原作者所有，本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容，请联系admin@php.cn

将用户添加到MySQL：完整的教程May 12, 2025 am 12:14 AM

掌握添加MySQL用户的方法对于数据库管理员和开发者至关重要，因为它确保数据库的安全性和访问控制。1)使用CREATEUSER命令创建新用户，2)通过GRANT命令分配权限，3)使用FLUSHPRIVILEGES确保权限生效，4)定期审计和清理用户账户以维护性能和安全。

掌握mySQL字符串数据类型：varchar vs.文本与charMay 12, 2025 am 12:12 AM

chosecharforfixed-lengthdata，varcharforvariable-lengthdata，andtextforlargetextfield.1）chariseffity forconsistent-lengthdatalikecodes.2）varcharsuitsvariable-lengthdatalikenames，ballancingflexibilitibility andperformance.3）

MySQL：字符串数据类型和索引：最佳实践May 12, 2025 am 12:11 AM

在MySQL中处理字符串数据类型和索引的最佳实践包括：1)选择合适的字符串类型，如CHAR用于固定长度，VARCHAR用于可变长度，TEXT用于大文本；2)谨慎索引，避免过度索引，针对常用查询创建索引；3)使用前缀索引和全文索引优化长字符串搜索；4)定期监控和优化索引，保持索引小巧高效。通过这些方法，可以在读取和写入性能之间取得平衡，提升数据库效率。

mysql：如何远程添加用户May 12, 2025 am 12:10 AM

ToaddauserremotelytoMySQL,followthesesteps:1)ConnecttoMySQLasroot,2)Createanewuserwithremoteaccess,3)Grantnecessaryprivileges,and4)Flushprivileges.BecautiousofsecurityrisksbylimitingprivilegesandaccesstospecificIPs,ensuringstrongpasswords,andmonitori

MySQL字符串数据类型的最终指南：有效的数据存储May 12, 2025 am 12:05 AM

tostorestringsefliceflicyInmySql，ChooSetherightDataTypeBasedyOrneOrneEds：1）USEcharforFixed-LengthStstringStringStringSlikeCountryCodes.2）UseVarcharforvariable-lengtthslikenames.3）USETEXTCONTENT.3）

mysql blob vs.文本：为大对象选择正确的数据类型May 11, 2025 am 12:13 AM

选择MySQL的BLOB和TEXT数据类型时，BLOB适合存储二进制数据，TEXT适合存储文本数据。1)BLOB适用于图片、音频等二进制数据，2)TEXT适用于文章、评论等文本数据，选择时需考虑数据性质和性能优化。

MySQL：我应该将root用户用于产品吗？May 11, 2025 am 12:11 AM

No,youshouldnotusetherootuserinMySQLforyourproduct.Instead,createspecificuserswithlimitedprivilegestoenhancesecurityandperformance:1)Createanewuserwithastrongpassword,2)Grantonlynecessarypermissionstothisuser,3)Regularlyreviewandupdateuserpermissions

MySQL字符串数据类型说明了：选择适合您数据的合适类型May 11, 2025 am 12:10 AM

mySqlStringDatatatPessHouldBechoseBeadeDataCharacteristicsAndUsecases：1）USECHARFORFIXED LENGTHSTRINGSTRINGSLIKECOUNTRYCODES.2）USEDES.2）usevarcharforvariable-lengtthstringstringstringstringstringstringstringslikenames.3）usebinaryorvarrinaryorvarinarydatalbonydatalgebgeenfopical.4）

See all articles