通过cshtml表单将Windows登录和当前日期添加到数据库中
通过cshtml表单将Windows登录和当前日期添加到数据库中
提问于 2014-09-17 16:49:21
下午好。
我需要帮助，试图从我的cshtml文件中的表单中将我的Windows登录名和当前日期添加到我的当前数据库中。请记住我对这件事很陌生.我才刚开始理解HTML。
正在使用的工具: WebMatrix 3，火狐
数据库的名称是:清除危险货物library.sdf
表名为:cl1爆炸性
这是代码：
{
var db = Database.Open("sweep hazmat library");
var ASIN = "";
var description = "";
var dateadded = "";
var addedby = "";
if(IsPost){
//read ASIN.
ASIN = Request["ASIN"];
if (ASIN.IsEmpty()){
Validation.Equals("ASIN", "A Article is needed here");
}
//read description.
description = Request["description"];
if (description.IsEmpty()){
Validation.Equals("description", "a description is required");
}
//figure out how to add date automatically.
dateadded = Request["DateTime.Now"];
addedby = ;
var SQLINSERT =
"INSERT INTO kl1explosiv (ASIN, description, dateadded){Values (@0, @1, @datetime.now )";
db.Execute(SQLINSERT, ASIN, description, dateadded, addedby);
Response.Redirect("~/EntsorgungsTabelle.cshtml");
}
<html>
<head>
</head>
<body>
<h2>Add an Article</h2>
<form method="post">
<fieldset>
<p><label for="ASIN">Title:</label>
<input type="text" name="ASIN" value="@Request.Form["ASIN"]" />
@Html.ValidationMessage("ASIN")
</p>
<p><label for="description">beschreibung:</label>
<input type="text" name="description" value="@description" />
@Html.ValidationMessage("description")
</p>
<p><input type="datetime-local" name="Dateadded" value="@dateadded" />
</p>
<p><input type="submit" name="buttonSubmit" value="Add an Article" /></p>
</fieldset>
</form>
</body>
</html> 回答 1
Stack Overflow用户
回答已采纳
发布于 2014-09-19 14:44:56
我设法解决了我自己的问题，感谢我的一个朋友(干杯，英国人)的提示。
现在，Windows Login还将自己与当前日期一起添加到数据库中：
@{
var db = Database.Open("sweep hazmat library");
var asin = "";
var description = "";
var dateadded = DateTime.Now;
var addedby = Environment.UserName;
var now = DateTime.Now;
if(IsPost){
//read ASIN.
asin = Request["asin"];
if (asin.IsEmpty()){
Validation.Equals("asin", "A Article is needed here");
}
//read description.
description = Request["description"];
if (description.IsEmpty()){
Validation.Equals("description", "a short description is needed here");
}
//figure out how to add date automatically.
dateadded = DateTime.Now;
addedby = Environment.UserName;
var SQLINSERT = "INSERT INTO kl1explosiv (asin, description, dateadded, addedby) Values(@0, @1, @2, @3)";
db.Execute(SQLINSERT, asin, description, dateadded, addedby);
db.Close();
Response.Redirect("EntsorgungsTabelle.cshtml");
}
}
<html>
<head>
</head>
<body>
<time datetime="@now.ToString("o")" pubdate>@now.ToLongDateString() @now.ToShortTimeString()</time>
@addedby
<h2>Add a Movie</h2>
@Html.ValidationSummary()
<form method="post">
<fieldset>
<legend>Movie Information</legend>
<p><label for="ASIN">Title:</label>
<input type="text" name="ASIN" value="@Request.Form["ASIN"]" />
@Html.ValidationMessage("ASIN")
</p>
<p><label for="description">beschreibung:</label>
<input type="text" name="description" value="@description" style="width: 250px; height: 50px;"/>
@Html.ValidationMessage("description")
</p>
<p><input type="submit" name="buttonSubmit" value="Add an Article" /></p>
</fieldset>
</form>
</body>
</html>现在我可以通过.sdf表单将系统日期、时间和窗口登录到我的.cshtml数据库中
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/25896132
复制相关文章
相似问题
腾讯云开发者
Copyright © 2013 - 2026 Tencent Cloud. All Rights Reserved. 腾讯云 版权所有
深圳市腾讯计算机系统有限公司 ICP备案/许可证号：粤B2-20090059 
粤公网安备44030502008569号
腾讯云计算（北京）有限责任公司 京ICP证150476号 | 京ICP备11018762号