使用javascript在SQL上添加数据

add data on sql using javascript

本文关键字：添加 数据 SQL javascript 使用      更新时间：2023-09-26

你好，我想在sql数据库中添加数据，但我找不到如何使用javascript做到这一点，我工作在visual studio

你可以使用Javascript将数据传递回你的。net MVC c#控制器方法

var myViewModel = {};
  var team= {};
  team.TeamID = 1234;
  team.TeamName = "Test Team";
  myViewModel.Team= team;
  var teamPlayerList = [];
  var player1= {};
  player1.id= "1";
  player1.Name = "Patrick";
  var player2 = {};
  player2.id= "2";
  player2.Name = "Padraig";
  teamPlayerList.push(player1);
  teamPlayerList.push(player2 );
  myViewModel.TeamPlayerList = teamPlayerList;
  $.ajax(
  {
   url: 'Team/Create',
   data: JSON.stringify({teamViewModel : myViewModel}),
   contentType: 'application/json',
   dataType: 'json',
   type: 'POST',
   success: function (data) {
    alert("success");
  },
  error: function () { alert('error'); }
});
在c#的后端，你需要一个控制器类和一些c#类来保存你从javascript传入的数据 
public class Team
{
 public long TeamID { get; set; }
 public string TeamName { get; set; }
}
public class TeamPlayer
{
 public string id{ get; set; }
 public string Name { get; set; }
}

A ViewModel 

public class TeamViewModel
{
 public Team Team { get; set; }
 public IList<TeamPlayer> TeamPlayerList { get; set; }
}

控制器方法是这样的

  public class TeamController : Controller
  {
   [HttpPost]
   public ActionResult Create(TeamViewModel teamViewModel)
   {
   //USE HERE TO EXTRACT DATA PASSED IN
     var myTeam = teamViewModel.Team;
     var teamPlayerList = teamViewModel.TeamPlayerList;
     //call your db insert class/code and use values passed in
   return Content("success");
  }
相关文章：