17,740
社区成员
发帖
与我相关
我的任务
分享
<table>
<tr>
<td>标题:</td>
<td><input type="text" id="title" /></td>
</tr>
<tr>
<td>内容:</td>
<td><input type="text" id="content" /></td>
</tr>
<tr>
<td colspan="2"><input type="button" id="btn" value="Create" /></td>
</tr>
</table>
<script language="javascript" type="text/javascript">
$(function () {
$("#btn").click(function () {
var s_Title = $("#title").val;
var s_Content = $("#content").val;
var json = { "Title": s_Title, "Content": s_Content };
$.ajax({
type: "POST",
url: "/Json/Create",
data: json,
dataType: "json",
success: function (data) {
window.location.href = "/Json/Index";
}
});
});
});
</script>
using(var ctx = new YourEntities())
{
// 增:
SomeTable addedObj = new SomeTable();
// entity 属性赋值
addedObj.Property1 = "...";
ctx.SomeTable.AddObject(addedObj);
// 提交数据库
ctx.SaveChanges();
// 删
var deletedObj = ctx.SomeTable.Where(x => x.ID == "123").FirstOrDefault();
if (deletedObj != null)
ctx.SomeTable.DeleteObject(deletedObj);
// 提交数据库
ctx.SaveChanges();
// 改
var updatedObj = ctx.SomeTable.Where(x => x.ID == "456").FirstOrDefault();
if (updatedObj != null)
updatedObj.Name = "xxx";
// 提交数据库
ctx.SaveChanges();
// 查
var query = from s in ctx.SomeTable
where s.ID == "xxx"
select s;
}
function json2str(o) {
var arr = [];
var fmt = function(s) {
if (typeof s == 'object' && s != null) return json2str(s);
return /^(string|number)$/.test(typeof s) ? "'" + s + "'" : s;
}
for (var i in o) arr.push("'" + i + "':" + fmt(o[i]));
return '{' + arr.join(',') + '}';
}
$(function () {
$("#btn").click(function () {
var s_Title = $("#title")[0].value;
var s_Content = $("#content")[0].value;
alert(s_Title + ":" + s_Content);
var json = { "Title": s_Title, "Content": s_Content };
var jsonData = json2str(json);
$.ajax({
type: "POST",
url: "WebForm1.aspx",
data: "JsonData=" + jsonData,
dataType: "json",
success: function (data) {
alert(data);
}
});
});
});