db.transaction(
function (transaction) {
transaction.executeSql('INSERT INTO EmployeeTable(Firstname,Lastname,BirthDate,EmployeeType,MaritalStatus,Company,IsActive,Dependents) values(?,?,?,?,?,?,?,?)',
[Firstname.toString(), Lastname.toString(), BirthDate, parseInt(empType), parseInt(marital),Company.toString(),active, parseInt(Dependents)]);
transaction.executeSql('SELECT * FROM EmployeeTable', [], function (transaction, results) {
result = results;
alert(result.length);
for (i = 0; i < results.length; i++) {
var EmployeeID = results.rows.item(i).EmployeeID;
var Firstname = results.rows.item(i).Firstname;
var Lastname = results.rows.item(i).Lastname;
alert(results.rows.item(i).EmployeeID + " " + results.rows.item(i).Firstname + " " + results.rows.item(i).Lastname);
//var product = [productid, productname, price, qty];
//insertTableRow(product,i);
}
}, null);
}
);
我使用WEB SQL作为本地数据库
要发送从websql检索到的数据db.Transaction()方法到服务器控制器
Please Help On same.....
我应该如何传输数据到mvc控制器.....
[HttpPost]
public ActionResult Create(FormCollection collection)
{
try
{
if (Save(0, collection))
{
// List<char> bulkdata = collection["bulkdata"].ToList();
return RedirectToAction("Index");
}
else
{
return View("Edit");
}
}
catch
{
return View();
}
}
下面的教程展示了一个如何将本地数据库与WCF数据服务端点同步的示例。通过将此与WebAPI教程相结合,您将能够使用以下行同步到在线DB:
function synchronizeData() {
offlinedb
.TodoItems
.filter("it.InSync === false")
.toArray(function (todoItems) {
onlinedb.addMany(todoItems);
onlinedb.saveChanges(function () {
todoItems.forEach(function (todoItem) {
offlinedb.attach(todoItem);
todoItem.InSync = true;
});
offlinedb.saveChanges(function () {
listLocalTodoItems();
listRemoteTodoItems();
});
});
})
}
您可以尝试序列化您的本地存储字符串,然后发送到服务器…
ASP。如何将JSON对象作为参数从视图传递到控制器