asp.net-mvc - 如何从 ASP.NET MVC 项目的前端将数据插入数据库表？

Question

我想检索用户在视图（.cshtml 文件）中输入的值并发送到数据库，而不是硬编码值。我是 MVC 的新手，试图通过控制器将视图数据发送到数据库。我写了这样的代码：

public ActionResult InPost(InputFormsModel FormData)
    {
        //Properties in Model hardcoded
        //FormData["AgentName"] = "'Frontend SB'"; wrong way
        FormData.AgentName = "'Frontend'"; 
        FormData.email_id = "'[e-mail]'";
        FormData.gender = "'female'";
        //Data Full hardcode way of insert into DB table.
        //Successful please note: remove comments not other change required.
        //DALAcess.execQuerySQL("insert into ATMTMP_Devproject_EmpMaster(EmpName,EmpEml,Gender) values("+"'hardcode'"+",'devtestattr.e'"+",'male'"+")"); 
        //partial hardcode of data, insert to table.
        DALAcess.execQuerySQL("insert into ATMTMP_Devproject_EmpMaster(EmpName,EmpEml,Gender)" +
                             "values(" + FormData.AgentName.ToString() + "," + FormData.email_id.ToString() +
                            "," + FormData.gender.ToString() +")");
        return RedirectToAction("Dashboard", "Home");
        //return View();
    }

.cshtml 文件代码如下：

<form id="input" action="@Url.Action("InPost","InputForms")" method="post">
                            <label>Agent Name</label>
                            <input id="txtEmpName" type="text" /><br />
                            
                            <label>Email (Official)</label>
                            <input id="txtEmail" type="text" /><br />
                            <label>Gender</label>
                            <input id="txtGender" type="text" /><br />
                            @* Other properties of Model *@
                            <input type="submit" value="Submit">
                        </form>

标签： asp.net-mvcasp.net-mvc-3