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
Post a Comment