Add Record when clicked Save in modal popup

Question

Hi Hi Sachin . How i can Add record in database with below code. I am using Ado.Net. @model IEnumerable "button" class = "btn btn-primary" data-toggle= "modal" data-target= "#myModal" onclick= "clearTextBox();" > class = "fa fa-plus" > Add New " style=" width:100% " id=" tblLocation"> @Html.DisplayNameFor(model => model.Id) @Html.DisplayNameFor(model => model.Description) @Html.DisplayNameFor(model => model.IsActive) Action @foreach ( var item in Model) { @Html.DisplayFor(modelItem => item.Id) @Html.DisplayFor(modelItem => item.Description) @Html.DisplayFor(modelItem => item.IsActive) class = 'btn btn-primary btn-sm' id= 'btnEdit' > class = 'fa fa-pencil' > Edit @ if (item.IsActive.ToUpper() == "N" ) { class = 'btn btn-danger btn-sm disabled' id= 'btnDelete' style= 'margin-left:5px' > class = 'fa fa-trash' > Delete } else { class = 'btn btn-danger btn-sm' id= 'btnDelete' style= 'margin-left:5px' > class = 'fa fa-trash' > Delete } } "~/Scripts/Appjs/Location.js" > class = "modal fade" id= "myModal" tabindex= "-1" role= "dialog" aria-labelledby= "myModalLabel" aria-hidden= "true" > class = "modal-dialog" > class = "modal-content" > class = "modal-header" > "button" class = "close" data-dismiss= "modal" > "true" >× class = "sr-only" >Close class = "modal-title" >Add New Location class = "modal-body" > class = "form-horizontal" > class = "form-group" > class = "control-label col-sm-3" for = "Id" >Id class = "col-sm-2" > "text" class = "form-control form-control-sm" id= "txtId" placeholder= "Id" > class = "form-group" > class = "control-label col-sm-3" for = "Description" >Description class = "col-sm-9" > "text" class = "form-control form-control-sm" id= "txtDescription" placeholder= "Description" > class = "form-group" > class = "control-label col-sm-3" for = "IsActive" >Active class = "col-sm-2" > "text" class = "form-control form-control-sm" id= "txtIsActive" placeholder= "Active" > class = "modal-footer" > "button" class = "btn btn-primary" id= "btnAdd" onclick= "return Add();" >Save "button" class = "btn btn-primary" id= "btnUpdate" style= "display:none;" onclick= "Update();" >Update "button" class = "btn btn-warning" data-dismiss= "modal" >Cancel Thanks

Sachin Singh · Answer

step 1. class = "modal-footer" > "button" class = "btn btn-primary" id= "btnAdd" ">Save "button" class = "btn btn-primary" id= "btnUpdate" style= "display:none;" onclick= "Update();" >Update "button" class = "btn btn-warning" data-dismiss= "modal" >Cancel step 2. $( "#btnAdd" ).click(function(){ // do your validation check here var model = { Description: $( "#txtDescription" ).val(), IsActive :$( "#IsAvtive" ).val(); }; $.ajax({ type: "post" , url: "/home/Save" , dataType: "json" , contentType: "application/json;charset=utf-8" , data: JSON.stringify(model), traditional: true , cache: false , success:function(){} }) }); step 3. public ActionResult Save(Location model) { using (Sqlconnection con= new SqlConnection( "yourConnectionString" )) { SqlCommand cmd= new SqlCommand( "insert into Location values(@Description,@IsActive)" ); cmd.Parameters.AddWithValue( "" @Description,model.Description); cmd.Parameters.AddWithValue( "" @IsActive,model.IsActive); con.Open(); cmd.ExecuteNonQuery(); return redirectToAction( "Index" ); } } Note:- I am considering that the Id column is identity in the SQL server, if not then send the value of id as well.