add data on sql using javascript -


hello want add data on database in sql can't find how using javascript,i work on visual studio

you can use javascript pass data .net mvc c# controller method

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'); } }); 

on backend in c# need controller class, , c# classes hold data pass in 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; } } 

the controllers method this

  public class teamcontroller : controller   {    [httppost]    public actionresult create(teamviewmodel teamviewmodel)    {    //use here extract data passed in       var myteam = teamviewmodel.team;      var teamplayerlist = teamviewmodel.teamplayerlist;       //call db insert class/code , use values passed in    return content("success");   } 

Comments

Popular posts from this blog

toolbar - How to add link to user registration inside toobar in admin joomla 3 custom component -

linux - disk space limitation when creating war file -

How to provide Authorization & Authentication using Asp.net, C#? -